Re: Oracle listener and JDBC - newbie question

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 9 Jan 2009 11:35:34 -0800 (PST)
Message-ID: <070eb36b-e44b-4f5c-9215-207354fa5f46_at_r37g2000prr.googlegroups.com>

On Jan 9, 1:37 pm, Loial <jldunn2..._at_googlemail.com> wrote:
> In order to connect to an oracle database via JDBC  the oracle
> listener must be running on the database server.  Thats correct isn't
> it?

On Jan 9, 1:37 pm, Loial <jldunn2..._at_googlemail.com> wrote:
> In order to connect to an oracle database via JDBC the oracle
> listener must be running on the database server. Thats correct isn't
> it?

The only two cases where you would *not* need a listrener is:

• If you are running the JVM inside the database (kprb driver), or
• If you are using OCI and connecting on the database server itself with your ORACLE_SID set in your environment. i.e.,

C:\java>type local.java
import java.sql.*;

public class local {
  public static void main(String args[]) {     try {

      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection conn = DriverManager.getConnection

("jdbc:oracle:oci:_at_","system"
,"fake_pwd");

      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
}

C:\java>javac local.java

C:\java>set oracle_sid=tst11g

C:\java>set oracle_sid=orcl11g

C:\java>java local
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

        at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.ja
va:70)

        at oracle.jdbc.driver.DatabaseError.newSQLException (DatabaseError.java:1
10)

        at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java
:171)

        at oracle.jdbc.driver.T2CConnection.checkError (T2CConnection.java:686)

        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java: 338)

        at oracle.jdbc.driver.PhysicalConnection.<init> (PhysicalConnection.java:
490)

        at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java: 133)

        at oracle.jdbc.driver.T2CDriverExtension.getConnection (T2CDriverExtensio
n.java:53)

        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java: 465)

        at java.sql.DriverManager.getConnection(DriverManager.java: 582)

        at java.sql.DriverManager.getConnection(DriverManager.java: 185)

        at local.main(local.java:7)

C:\java> Received on Fri Jan 09 2009 - 13:35:34 CST