• Post Reply Bookmark Topic Watch Topic
  • New Topic

Weblogic Oracle JDBC Problem

 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have created a Connection Pool.
The problem is that when I test the connection I get the following error message.
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: System.loadLibrary(weblogicoci37> threw java.lang.UnsatisfiedLinkError:
no weblogicoci37 in java.library.path
java.library.Path is
C:\jdk1.3.1_04\jre\bin;.;C:\WINDOWS\System32;C:\WINDOWS;.;C:\jdk1.3.1_04\bin;C:\j2sdkee1.3.1\bin;C:\jakarta-ant-1.3\bin;C:\oracle\ora90\bin;C:\oracle\ora90\Apache\Perl\5.00503\bin\mswin32-x86;C:\Program Files\Oracle\jre\1.1.8\bin;C:\oracle\ora90\jdbc\lib\classes111.zip;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\WBEM;C:\WINDOWS\COMMAND;C:\bea\wlserver6.0\bin\oci816_8\weblogicoci37;
Thanks for any help.
TE
 
Dave Landers
Ranch Hand
Posts: 401
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have weblogic6.x/bin/oci816_8 in your PATH
You have:
C:\bea\wlserver6.0\bin\oci816_8\weblogicoci37
Probably should be:
C:\bea\wlserver6.0\bin\oci816_8
 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Dave I did have just C:\bea\wlserver6.0\bin\oci816_8; but still got the same error message.
I was wondering does it count where you add it in the path.
Cheers for any help.
TE
 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I also have C:\bea\wlserver6.1\lib\weblogic.jar
set in my CLASSPATH .;C:\oracle\ora90\jdbc\lib\classes111.zip;C:\projects\jakarta-Tomcat-4.0\bin\bootstrap.jar;C:\jdk1.3.1_04\lib\tools.jar;C:\j2sdkee1.3.1\lib\j2ee.jar;C:\bea\wlserver6.1\lib\weblogic.jar.
URL is set to :jdbc:weblogic racle
URL is set to: weblogic.jdbc.oci.Driver
user=SYSTEM
server=MYDB
 
Dave Landers
Ranch Hand
Posts: 401
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The way I read your paths, you are using the 6.1 version of weblogic.jar with the 6.0 version of oci816_8. If that is what you have, it is likely to have problems.
Check your PATH and CLASSPATH and make sure all the entries point to valid jars or directories (and make sure all the WLS pieces match the same install). Like, make sure that the oci816_8 directory actually exists - there are several versions of oci and I can't remember which oci versions go with which WLS versions. I'm just assuming 816_8 is OK for whatever version you have.
Order of PATH or CLASSPATH doesn't matter unless there are two copies of something - then the first one wins. Or, if there is a mistake in a path (misplaced ";" or ":") sometimes it will goof up something that looks OK untill you look really close.... Thining out unnecessary stuff in paths helps this
 
Tony Evans
Ranch Hand
Posts: 598
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you Dave.
My face is very red, its that old problem where you look at the problem so much you miss the obvious in my case a incorrect path.
Path is now set to C:\bea\wlserver6.1\bin\oci816_8.
Thanks again Tony
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!