This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc oci8 connectivity

 
SOMASUNDAR SAMBATHINI
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
im trying to connect to oracle server which is in
linux. From a different machine in which i have oracle client and windows 2000 im trying to connect
im using oci8 driver.
im getting the error
java.lang.UnsatisfiedLinkError: do_open
at oracle.jdbc.oci8.OCIDBAccess.do_open(Native Method)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Offline$connect.run(Offline.java:126)
pl any body help me
thanx in advance
sundar
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you need to set the Path as well as classpath when using the OCI drivers:
JDBC OCI Driver:
If you are installing the JDBC OCI driver, you must also set the following value for the library path environment variable
On Solaris, set LD_LIBRARY_PATH as follows:
[Oracle Home]/lib

This directory contains the libocijdbc9.so shared object library.
On Windows NT, set PATH as follows:
[Oracle Home]\lib

This directory contains the ocijdbc8.dll dynamic link library.

you can read more in the Oracle9i JDBC Developer's Guide and Reference. The above exerpt was taken from chapter 2 - getting started.
Jamie
 
SOMASUNDAR SAMBATHINI
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx for reply
but it is working with oracle server in winodows 2000 machine
but it is not working with oracle clint
what should i do
thanx in advance
sundar
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!