no weblogicoci37 in java.library.path

[Adam Adams]

i am trying to run the jdbc/oracle/simpleselect examples.
i folowed all the instruction from:
setting the enviornment and build the examples and after i run it i get this error: even thought i have my path sets to in my startup scripts to:
set PATH=.\bin;.\bin\oci817_8;c:\oracle\ora81\bin;%PATH%
here is the error:
C:\bea\wlserver6.1\samples\examples\jdbc\oracle>java examples.jdbc.oracle.simple
select
Starting Loading jDriver/Oracle .....
Exception in thread "main" java.sql.SQLException: System.loadLibrary(weblogicoci
37) threw java.lang.UnsatisfiedLinkError: no weblogicoci37 in java.library.path
at weblogic.jdbc.oci.Driver.loadLibraryIfNeeded(Driver.java:226)
at weblogic.jdbc.oci.Driver.connect(Driver.java:76)
at examples.jdbc.oracle.simpleselect.main(simpleselect.java:113)
any help would be very appreciate it

[Vijay Shrivastava]

This error is not path related it is classpath related.
Assuming followings.
1. You are using WebLogic provided river not Oracle Provided driver.
2. you are running client locally and server is listening on Port 7001.
3. You have set the path correctly (set PATH=%WL_HOME%\bin\oci817_8;c:\ORANT817\bin;%PATH%).

Your classpath should include
%WL_HOME%/lib/weblogic.jar
In your code you will use
Driver class: weblogic.jdbc.oci.Driver
URL: jdbc:weblogic racle
This should work fine.
Hope it helps,

------------------
Vijay shrivastava
Consultant - ObjectNetTechnologies ,Atlanta USA.
SCJP2, WLS5.1,SCJEA (Part I)

[Adam Adams]

Vijay, i am still having the same error even thoughti am using the examples which comes with wls6.1 (ex: simpleselect.java.. i did not make any changes). Also, here my classpath setting in startScript:
set JAVA_HOME=C:\bea\jdk131
set WL_HOME=C:\bea\wlserver6.1
set ORACLE_HOME=C:\oracle\ora81
@rem Check that script is being run from the appropriate directory
if not exist lib\weblogic.jar goto wrongplace
goto checkJDK

:wrongplace
echo startExamplesServer.cmd must be run from the config\examples directory. 1>&2
goto finish
:checkJDK
if exist %JAVA_HOME%/bin/javac.exe goto runWebLogic
echo.
echo Javac wasn't found in directory %JAVA_HOME%/bin.
echo Please edit the startExamplesServer.cmd script so that the JAVA_HOME
echo variable points to the root directory of your JDK installation.
goto finish
:runWebLogic
echo on
set PATH=.\bin;.\bin\oci817_8;c:\oracle\ora81\bin;%PATH%
@rem set WEBLOGIC_CLASSPATH=c:\classes\nz\gov\winz\app\ucv
set CLASSPATH=%JAVA_HOME%\lib\tools.jar;%WL_HOME%\lib\weblogic_sp.jar;%WL_HOME%\lib\weblogic.jar;%ORACLE_HOME%\jdbc\lib\classes111.zip;%ORACLE_HOME%\jdbc\lib\classes12.zip;%CLASSPATH%

Originally posted by Vijay Shrivastava:
This error is not path related it is classpath related.
Assuming followings.
1. You are using WebLogic provided river not Oracle Provided driver.
2. you are running client locally and server is listening on Port 7001.
3. You have set the path correctly (set PATH=%WL_HOME%\bin\oci817_8;c:\ORANT817\bin;%PATH%).

Your classpath should include
%WL_HOME%/lib/weblogic.jar
In your code you will use
Driver class: weblogic.jdbc.oci.Driver
URL: jdbc:weblogic racle
This should work fine.
Hope it helps,