Unable to configure the database connection in eclipse

[Kumar Raja]

Hello All,

I'm not sure, if my question needs to be posted in this forum at all, as this is related to eclipse but I'm having trouble in configuring the DB connection. Due to license issues, I can not use Toad or other products and hence wanted to leverage eclipse for this.

My JDBC connection URL =

   
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(Host=someDNS/IP)(Port = some port))(ADDRESS=(PROTOCOL=TCP)(Host=some other load balancing DNS/IP)(Port=some other port)))(CONNECT_DATA=(SERVICE_NAME=some service name(FAILOVER_MODE=(TYPE=SESSION)(METHOD=basic))))
 

I have deliberately removed some actual information from the above string.

Based on this, I was trying to setup the DB Connection in eclipse.

as shown, this is a thin client driver.

I entered the SERVICE_NAME as SID, HOST as one of the DNS listed in the above string and the corresponding PORT and entered the correct User Name and Password.

But when I try to test the connectivity but receiving the below error

    
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
<<above DNS>>:<<above port>>:<<above service name>>

[Tim Holloway]

Actually, I have absolutely no idea what you mean by "configure the database connection in Eclipse", because Eclipse itself doesn't have database support, although various Eclipse plugins do, including the Data Tools plugin, which I find makes a decent substitute for Toad.

Your Oracle JDBC URL looks like no other I've ever seen. The more common format is something like: "jdbc:oracle:thin@serverhost/instancename". It usually doesn't attempt to include advanced TNS information, since that should be configured in a central place. Plus, my understanding was that TNS names were no longer the preferred reference as of about Oracle 9i, and we're currently up to Oracle 11.

[Kumar Raja]

Tim Holloway wrote:Actually, I have absolutely no idea what you mean by "configure the database connection in Eclipse", because Eclipse itself doesn't have database support, although various Eclipse plugins do, including the Data Tools plugin, which I find makes a decent substitute for Toad.

Your Oracle JDBC URL looks like no other I've ever seen. The more common format is something like: "jdbc:oracle:thin@serverhost/instancename". It usually doesn't attempt to include advanced TNS information, since that should be configured in a central place. Plus, my understanding was that TNS names were no longer the preferred reference as of about Oracle 9i, and we're currently up to Oracle 11.

Hmm, I too read that usage of TNS names is no longer valid, but not sure why, it is still around in our project (atleast for unit tests) and we are using Oracle 10g

[Tim Holloway]

TNS names are still valid for 10g, just discouraged.