943,708 Members | Top Members by Rank

Ad:
  • Java Discussion Thread
  • Unsolved
  • Views: 2388
  • Java RSS
Feb 1st, 2006
0

problem in installing jdbc...

Expand Post »
hi guys,
I'm a new member. By the way, I had an error that showed up on my jdbc program that connected to oracle. It showed 'java.sql.SqlException'. When I looked up on it in a book called Oracle8i Complete Reference, it told me that I could set my environment variables and test run my jdbc connection with a program that was there when Oracle is installed. It was called JdbcCheckup.java. Now its compiling all fine and dandy, but this run time error keeps popping up called java.lang.UnsatisfiedLinkError. Can someone help this fair lady in distress?

E:\Oracle\Ora81\jdbc\demo\samples\oci8\basic-samples>javac JdbcCheckup.java

E:\Oracle\Ora81\jdbc\demo\samples\oci8\basic-samples>java JdbcCheckup
Please enter information to test connection to the database
user: scott
password: tiger
database (a TNSNAME entry): 10.0.2.141
Connecting to the database...Connecting...
Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.l
ibrary.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
at java.lang.Runtime.loadLibrary0(Runtime.java:822)
at java.lang.System.loadLibrary(System.java:992)
at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:192)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:142)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.ja
va:214)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:193)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at JdbcCheckup.main(JdbcCheckup.java:42)
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Poornima is offline Offline
1 posts
since Feb 2006
Feb 1st, 2006
0

Re: problem in installing jdbc...

looks like you're missing a jarfile in your classpath. I don't have Oracle installed here so I can't tell you which one, but the name it gives as missing should be a good indication.
Team Colleague
Reputation Points: 1658
Solved Threads: 331
duckman
jwenting is offline Offline
7,719 posts
since Nov 2004
Feb 1st, 2006
0

Re: problem in installing jdbc...

Poornima,

This sample program is trying to use the OCI (Oracle Call Interface) JDBC driver. This is a platform dependant driver. I would strongly recommend researching how to use the Oracle Thin JDBC driver, unless you have specific need to use the OCI driver. The Thin driver is platform indepentent and is highly optimised, it is as fast and in some cases faster than the OCI driver and will work on any platform without a care in the world.

The reason this sample appplication is not working is because it cannot locate the OCI library. I suspect you will have to set the LD_LIBRARY_PATH enviroment variable to point to the OCI library.

Kate
Reputation Points: 10
Solved Threads: 1
Junior Poster in Training
Kate Albany is offline Offline
71 posts
since Jun 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Java Forum Timeline: Place to start learning Java!
Next Thread in Java Forum Timeline: String class help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC