Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
rcontreras63
Post subject: Help with 'Database Explorer' and Oracle 9i [Closed]  PostPosted: Nov 12, 2004 - 10:54 PM
Registered Member
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?
 
 View user's profile Send private message  
Reply with quote Back to top
rcontreras63
Post subject:   PostPosted: Nov 12, 2004 - 11:06 PM
Registered Member
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)
 
 View user's profile Send private message  
Reply with quote Back to top
rcontreras63
Post subject:   PostPosted: Nov 12, 2004 - 11:24 PM
Registered Member
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. (???)
 
 View user's profile Send private message  
Reply with quote Back to top
support-michael
Post subject:   PostPosted: Nov 13, 2004 - 02:55 PM
Moderator
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.
 
 View user's profile Send private message  
Reply with quote Back to top
cogitoboy
Post subject:   PostPosted: Dec 14, 2004 - 06:29 PM
Veteran Member
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?
 
 View user's profile Send private message  
Reply with quote Back to top
cogitoboy
Post subject:   PostPosted: Dec 14, 2004 - 07:47 PM
Veteran Member
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.
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits