Re: Need help connecting to oracle with JDBC thin

Hi,
  check your listener.ora file for the SID. I don't believe that what you have( oracle.ga.com) is correct.

hth,
cindy

VWP914 wrote:

> Could someone please look at the error message I received after trying to
> connect to my local oracle database using JDBC. The source code follows as
> well (taken from Oracle FAQ page). My JDBC driver is in the CLASSPATH
> (classes12.zip). Also, I think my connection string is right, because I
> checked the tnsnames.ora file. Any help would be appreciated. Thanks.
>
> Thomas
>
> Error Message: +++++++++++++++++++++++++++++++++++++
>
> F:\>java dbAccess
> Exception in thread "main" java.sql.SQLException: Io exception: Connection
> refus
> ed(DESCRIPTION=(TMP=)(VSNNUM=135290880)(ERR=12505)(ERROR_STACK=(ERROR=(COD
> E=1250
> 5)(EMFI=4))))
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
> at
> oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:212)
>
> at
> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
> va:251)
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at java.sql.DriverManager.getConnection(Unknown Source)
> at dbAccess.main(dbAccess.java:7)
>
> SOURCE CODE ++++++++++++++++++++++++++
>
> import java.sql.*;
> class dbAccess {
> public static void main (String args []) throws SQLException
> {
> DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
>
> Connection conn = DriverManager.getConnection
> ("jdbc:oracle:thin:@tt1:1521:oracle.ga.com", "scott", "tiger");
> // @machineName:port:SID, userid, password
>
> Statement stmt = conn.createStatement();
> ResultSet rset = stmt.executeQuery("select BANNER from
> SYS.V_$VERSION");
> while (rset.next())
> System.out.println (rset.getString(1)); // Print col 1
> stmt.close();
> }
> }
  Received on Sat Jan 20 2001 - 21:26:49 CST