Meaningless Drivel is fun!*
The moose likes IDEs, Version Control and other tools and the fly likes Unable to configure the database connection in eclipse Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Unable to configure the database connection in eclipse" Watch "Unable to configure the database connection in eclipse" New topic
Author

Unable to configure the database connection in eclipse

Kumar Raja
Ranch Hand

Joined: Mar 18, 2010
Posts: 524
    
    2

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 =


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


Regards
KumarRaja

Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16246
    
  21

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
Kumar Raja
Ranch Hand

Joined: Mar 18, 2010
Posts: 524
    
    2

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
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16246
    
  21

TNS names are still valid for 10g, just discouraged.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Unable to configure the database connection in eclipse