dcsimg
JDBC Basic question - Oracle 8i rel 8.1.5
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Mohan_Kambli
Posted On:   Wednesday, February 11, 2004 02:16 AM

Hello, I am sure that this question or a similar one has been asked countless times. I am trying to teach myself Java/JDBC using an Oracle 8i (rel 8.1.5) database. I've installed the 8.0.5 JDBC Thin & OCI drivers on my pc and this has created a jdbc folder below my oracle_home (orant) with the lib and samples folder below it. I have created a CLASSPATH environment variable which has just the following entries: '.;d:jdk1.1.7B in;d:orantjdbclibclasses111.zip'. I'm using the 1.1.7 of the JDK. With the above I can then compile the JdbcCheckup.java sample problem that exists in my orantjdbcsamplesoci7 folder. H   More>>


Hello,
I am sure that this question or a similar one has been asked countless times.



I am trying to teach myself Java/JDBC using an Oracle 8i (rel 8.1.5) database. I've installed the 8.0.5 JDBC Thin & OCI drivers on my pc and this has created a jdbc folder below my oracle_home (orant) with the lib and samples folder below it.



I have created a CLASSPATH environment variable which has just the following entries:
'.;d:jdk1.1.7B in;d:orantjdbclibclasses111.zip'.




I'm using the 1.1.7 of the JDK.




With the above I can then compile the JdbcCheckup.java sample problem that exists in my orantjdbcsamplesoci7 folder.




However, when running this sample program it gives me the following error:



java.lang.UnsatisfiedLinkError: no oci73jdbc in shared library path
at java.lang.Runtime.loadLibrary(Compiled Code)
at java.lang.System.loadLibrary(System.java:561)
at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:142)
at oracle.jdbc.driver.OracleConnection. (OracleConnection.java:103)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:148)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:126)
at JdbcCheckup.main(Compiled Code)




Please could someone advise on what I've done incorrectly?
Any help would be welcome.




thank you,
Mohan.

   <<Less

Re: JDBC Basic question - Oracle 8i rel 8.1.5

Posted By:   Chandra_Patni  
Posted On:   Wednesday, February 11, 2004 02:37 AM

The error is due to failure to load "oci7.dll" file (see item 2 of list below). Make sure that you have following environment for the java process.

  1. ORACLE_HOME environment variable

  2. ORACLE_HOMElib is in your System PATH

  3. ORACLE_HOMEjdbclibclasses111.jar is included in CLASSPATH environment variable

About | Sitemap | Contact