wood burning stoves 2.0*
The moose likes JDBC and the fly likes JDBC connection to Oracle 8.0.5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC connection to Oracle 8.0.5" Watch "JDBC connection to Oracle 8.0.5" New topic
Author

JDBC connection to Oracle 8.0.5

Chitra Sundaram
Greenhorn

Joined: Oct 24, 2000
Posts: 18
Hi,
I am trying to connect to the Oracle database ( v 8.0.5) on Windows NT 4.0 using the JDBC drivers. I am using JDK 1.3. This program has run before. Now, it gives an "UnsatisfiedLinkError: c:\orawin95\bin\oci805jdbc.dll....." This file is present.
My ClassPath has .;c:\orawin95\jdbc\lib\classes111.zip;c:\orawin95\bin
among other things
and PATH has c:\orawin95\bin;c:\jdk1.3.... among other paths.
Any help??
Thanks
Chitra
Michal Harezlak
Ranch Hand

Joined: Jul 06, 2000
Posts: 185
Some libraries used by oci805jdbc.dll might not be visible for the VM. Check what they are (quick view).

Chitra Sundaram
Greenhorn

Joined: Oct 24, 2000
Posts: 18
Based on what you said, I did a quick view on oci805jdbc.dll. It requires 5 dlls
ora805.dll
core40.dll
nlsrtl33.dll
javai.dll
kernel32.dll
I am not sure how to check the visibility of it. This is the detailed error that I am getting:
Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\orawin95\BIN\oci80
5jdbc.dll: One of the library files needed to run this application cannot be found
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.loadLibrary0(Unknown Source)
at java.lang.System.loadLibrary(Unknown Source)
at oracle.jdbc.oci7.OCIDBAccess.logon ( OCIDBAccess.java:142)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:103)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:148)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ConnectClass.main(ConnectClass.java:9)

Any more clues?
Thanks
Chitra
Michal Harezlak
Ranch Hand

Joined: Jul 06, 2000
Posts: 185
Check if all the directories containing depended dlls are in the system´┐Żs PATH.
Chitra Sundaram
Greenhorn

Joined: Oct 24, 2000
Posts: 18
Thanks for that tip. I had missed putting the JRE11\bin in the path and also reinstalled my Oracle client. Now, my program works if I use thin driver. But when I use oci8, it is giving me a new error:
Exception in thread "main" java.lang.UnsatisfiedLinkError: make_c_state
at oracle.jdbc.oci7.OCIDBAccess.make_c_state(Native Method)
at oracle.jdbc.oci7.OCIDBAccess.logon(OCIDBAccess.java:148)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:103)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:148)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at ConnectClass.main(ConnectClass.java:9)

The problem is that I can't find the make_c_state.
Thanks
Chitra Sundaram
Chitra Sundaram
Greenhorn

Joined: Oct 24, 2000
Posts: 18
I rearranged my PATH contents and it worked. ( Sounds strange though). I do not understand this, but am happy that it worked!!!
Thanks for your help
Regards
Chitra
Michael Brewer
Ranch Hand

Joined: Jun 27, 2002
Posts: 54
How do you find out what DLLs a DLL is dependent on in Win2000?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC connection to Oracle 8.0.5
 
Similar Threads
Jboss not starting aka shutting down
having problem with jdbc connection for Personal Oracle8i on win98
Unsatisfied Linker Error
installing Tomcat
environment setting