• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

JDBC connection to Oracle 8.0.5

 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 185
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Some libraries used by oci805jdbc.dll might not be visible for the VM. Check what they are (quick view).

 
Chitra Sundaram
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 185
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Check if all the directories containing depended dlls are in the system´┐Żs PATH.
 
Chitra Sundaram
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How do you find out what DLLs a DLL is dependent on in Win2000?
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic