Need help connecting to oracle with JDBC thin

From: VWP914 <vwp914_at_aol.com>
Date: 20 Jan 2001 15:42:41 GMT
Message-ID: <20010120104241.10339.00000356@ng-mf1.aol.com>

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 - 09:42:41 CST