jdbc:oracle:thin:@

From: Cel <cefernan_at_capgemini.fr>
Date: Mon, 17 Jun 2002 12:31:18 +0200
Message-ID: <3d0dbb9a$0$498$626a54ce@news.free.fr>

When trying to run the program below to test the connexion with my database
(Oracle 9i with W2K),

i get this error message:

I don't know where the problem is.
Database is started, and listener too.
Help needed !

E:\>java -cp .;E:\oracle\ora90\jdbc\lib\classes111.zip dbAccess Exception in thread "main" java.sql.SQLException: Exception d'E/S: The Network A
dapter could not establish the connection

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
        at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java)
        at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:177)
        at dbAccess.main(dbAccess.java:9)

Here is the program

---

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:@bobbyt:1521:basestar", "scott", "tiger");
                             // @machineName:port:SID,   userid,  password

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("select ename from scott.emp");
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        stmt.close();

  }
}

And my TNSNAMES.ORA file :

---

# TNSNAMES.ORA Network Configuration File: E:\oracle\ora90\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)
)

)

BASESTAR =
(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)

(CONNECT_DATA =

(SID = BASESTAR)

(PRESENTATION = RO)
)

) Received on Mon Jun 17 2002 - 05:31:18 CDT