• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to configure the database connection in eclipse

 
Kumar Raja
Ranch Hand
Posts: 547
2
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18277
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 547
2
Hibernate Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 18277
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
TNS names are still valid for 10g, just discouraged.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic