wood burning stoves 2.0*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 518
    
    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: 15964
    
  19

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: 518
    
    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: 15964
    
  19

TNS names are still valid for 10g, just discouraged.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to configure the database connection in eclipse
 
Similar Threads
connect to Oracle cluster over JDBC thin client
Creating Database Connection profile using connection url
Oracle database connection problem
Oracle RAC intermittent connection
Using oracle conn. manager - connection refused