topic jdbc issue using OCI8 driver in Operating System - HP-UX

jdbc issue using OCI8 driver

Ciaran Byrne — Thu, 27 Jun 2002 23:38:48 GMT

Hi,
I have a problem on HP-UX 11i connecting to an Oracle 8.1.7.2 database. The client can connect using the Oracle jdbc thin client but not the OCI8 client. The error message is "java.sql.SQLException: ORA-12154: TNS:could not resolve service name". However I can do a 'tnsping SID' and sqlplus to the database. Any ideas/suggestions would be appreciated.

Re: jdbc issue using OCI8 driver

Brian Bientz — Fri, 28 Jun 2002 11:18:05 GMT

I suspect that there is something wrong with the connect string in the java program. If I'm not mistaken, the connect string for the OCI8 driver is different from the connect string for the JDBC Thin driver. I think I would try putting some debug statements in the Java code to ensure the proper connect string is being passed to the driver. Another option would be to turn on SQL*Net (Net8) client tracing. The trace file would show you exactly what connect string is being passed. Hope this helps.

Re: jdbc issue using OCI8 driver

Ciaran Byrne — Fri, 28 Jun 2002 20:27:53 GMT

Brian,
thanks for your response. I found the issue was with the way the driver was registered.
Needs to be
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

which is different than for the thin driver.

Thanks,