Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC OCI works without listener?

Re: JDBC OCI works without listener?

From: news.zoominternet.net <JeffreyH_at_comanage.net>
Date: Mon, 6 Oct 2003 19:56:15 -0400
Message-ID: <3f8201ae$1_6@corp.newsgroups.com>


Yes, it is possible. Simply make sure the ORACLE_SID environment variable is set to the SID you want to login to. When constructing the URL connection, simply leave the "connect string" blank. (The part after the @ symbol). Here is a simply program to demonstrate:

import java.sql.*;

class JdbcTestOCI {

  public static void main (String args[]) throws SQLException {

    DriverManager.registerDriver(
      new oracle.jdbc.driver.OracleDriver());

    String anURL = "jdbc:oracle:oci8:@";     Connection conn =
      DriverManager.getConnection(anURL, "scott", "tiger");

    Statement stmt = conn.createStatement();

    ResultSet rset =
      stmt.executeQuery("SELECT emp_id, name FROM emp");

    while (rset.next()) {

      System.out.println("Emp ID   : " + rset.getInt(1) );
      System.out.println("Emp Name : " + rset.getString(2) + "\n");
    }
    rset.close();
    stmt.close();
    conn.close();

  }
} java JdbcTestOCI

Emp ID : 1
Emp Name : Name at : 1989

Emp ID : 2
Emp Name : Name at : 1734

Emp ID : 3
Emp Name : Name at : 1717

Emp ID : 4
Emp Name : Name at : 1802

Emp ID : 5
Emp Name : Name at : 1989

Regards,
-- jeff



Jeffrey M. Hunter
Sr. Database Administrator
jhunter_at_idevelopment.info
www.idevelopment.info

"JZ" <ibm_97_at_yahoo.com> wrote in message news:10bc841c.0310061421.4770fbda_at_posting.google.com...
> Oracle 9.2

>

> Suppose I install Oracle server 9.2, JDBC OCI drive into one machine.
> Can I use 'IPC' to connect to database server without listener is
> running? If not, why? If yes, how?

>
> Thnx a lot,

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Received on Mon Oct 06 2003 - 18:56:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US