facebook

Help with ‘Database Explorer’ and Oracle 9i [Closed]

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #219449 Reply

    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?

    #219450 Reply

    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)

    #219453 Reply

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

    #219459 Reply

    support-michael
    Keymaster

    Hmm! Possibly a network glitch or other.

    Thanks for providing feedback.

    #221019 Reply

    cogitoboy
    Member

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

    #221031 Reply

    cogitoboy
    Member

    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.

Viewing 6 posts - 1 through 6 (of 6 total)
Reply To: Help with ‘Database Explorer’ and Oracle 9i [Closed]

You must be logged in to post in the forum log in