[Richard Contreras]

Using:
Eclipse 3.0.0
MyEclipse 3.8.2
Oracle 9i

Can connect through code but not through MEDatabase Explorer
ctx.addNameURLDriver(“TEST”,
“jdbc:oracle:thin:@<IP-ADDR>:1521:test”,
“oracle.jdbc.driver.OracleDriver”);

Profile window
Profile Name: TEST
Driver: Oracle Thin Driver (from dropdown)
URL: jdbc:oracle:thin:@<IP-ADDR>:1521:test
User Name: admin
Password: <<pwd>>

Error:
Error while trying to login to database:
oracle.jdbc.driver.OracleDriver

Questions:
1- Where can I look for more specific error message detail?
2- Can anyone see a flaw in the way I set this connection up in MEDExp?

[Richard Contreras]

I’m now at this point in the process:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 Nov 12, 2004 17:05:27.923
!MESSAGE Error while trying to login to database
!STACK 0
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.sessiontree.actions.LoginProgress$Login.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)

[Richard Contreras]

I didn’t change anything, however, it is now working. I didn’t even restart Eclipse/MyEclipse. (???)

[support-michael]

Hmm! Possibly a network glitch or other.

Thanks for providing feedback.

[cogitoboy]

Well, I’ve followed the same path and I am receiving the same “Network” error. Any advice other than wait for it to work?

[cogitoboy]

I transposed my SID and machine name (hey, the are very similiar). This “Network Adapter” error is simply that the SID is invalid. Dang Oracle error messages.

[Author]

Posts