JDBC thin driver does not use tnsname.ora file. You need to make that
listener is running on bobbyt at port 1521.
hth
santosh sharma
"Cel" <cefernan_at_capgemini.fr> wrote in message
news:3d0dbb9a$0$498$626a54ce_at_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 - 10:51:10 CDT
