This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
Joined: Oct 31, 2001
JDBC thin driver does not use tnsnames.ora to make a connection. Using a tnsname here instead of the SID is quite an easy error to make. If it is a name in your TNS file, then replace the host string name with the network name of the Oracle server. That should resolve your problem.
Also, to add to this, some extra info with regard to OCI and Thin driver is...
The JDBC OCI driver provides an implementation of the JDBC interfaces using the Oracle Call Interface (OCI). The JDBC OCI driver requires an Oracle client installation including Net8.
The JDBC Thin driver establishes a direct connection to the database server using Java Sockets. The JDBC Thin driver does not require Oracle software on the client side; however, there must be an Oracle listener process correctly installed on the Oracle server.
Hope this helps.
Note: Please donot use Display Name for the Topic, as this will not help anybody to understand what the topic is all about.