| Author |
Message |
|
|
Post subject: Help with 'Database Explorer' and Oracle 9i [Closed]
Posted: Nov 12, 2004 - 10:54 PM
|
|
Registered Member


Joined: Jun 14, 2004
Posts: 7
|
|
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? |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 12, 2004 - 11:06 PM
|
|
Registered Member


Joined: Jun 14, 2004
Posts: 7
|
|
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) |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 12, 2004 - 11:24 PM
|
|
Registered Member


Joined: Jun 14, 2004
Posts: 7
|
|
I didn't change anything, however, it is now working. I didn't even restart Eclipse/MyEclipse. (???) |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 13, 2004 - 02:55 PM
|
|
Moderator


Joined: May 05, 2003
Posts: 1037
|
|
Hmm! Possibly a network glitch or other.
Thanks for providing feedback. |
_________________ Michael
MyEclipse Support
Posting Guidelines FYI
When posting a bug report, click the "Insert" button above the message window and fill out the empty fields to help us troubleshoot your problem.
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Dec 14, 2004 - 06:29 PM
|
|
Veteran Member


Joined: Dec 14, 2004
Posts: 2
|
|
Well, I've followed the same path and I am receiving the same "Network" error. Any advice other than wait for it to work? |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Dec 14, 2004 - 07:47 PM
|
|
Veteran Member


Joined: Dec 14, 2004
Posts: 2
|
|
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. |
|
|
| |
|
|
|
 |
|
|