Hello,
This is the first time I'm trying to connect to Oracle from my
servlet on Weblogic 5.1. I have Oracle 8i on my machine. In the
Weblogic.properties file, I have added the following code:
=============
weblogic.jdbc.connectionPool.oraclePool=\
url=jdbc:weblogic:oracle,\
driver=weblogic.jdbc.oci.Driver,\
loginDelaySecs=1,\
initialCapacity=4,\
maxCapacity=10,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=MTS;password=MTS;server=NEXTSTEP
weblogic.allow.reserve.weblogic.jdbc.connectionPool.oraclePool=\
MTS
weblogic.allow.reset.weblogic.jdbc.connectionPool.oraclePool=\
MTS
weblogic.allow.shrink.weblogic.jdbc.connectionPool.oraclePool=\
MTS
============================
When I run my Weblogic server it gives the following message:
=====================
...
...
Delaying 1 seconds before making a oraclePool pool connection.
java.sql.SQLException: System.loadLibrary threw
java.lang.UnsatisfiedLinkError
with the message 'no weblogicoci36 in java.library.path'.
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:116)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(Connection
EnvFactory.ja
va:149)
at
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.ja
va:109)
at
weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j
ava, Compiled
Code)
at
weblogic.common.internal.ResourceAllocator.<init>(ResourceAllocator.java,
Compiled Code)
at
weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330
)
at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java,
Compiled Code)
at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200)
at
weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219)
at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java,
Compiled Code)
at
weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62)
Mon Feb 12 15:01:45 CST 2001:<I> <JDBC Pool> Sleeping in createResource()
Mon Feb 12 15:01:46 CST 2001:<E> <JDBC Pool> Failed to create connection
pool "oraclePool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: System.loadLibrary threw
java.lang.UnsatisfiedLinkError
with the message 'no weblogicoci36 in java.library.path'.
at weblogic.jdbcbase.oci.Driver.connect(Driver.java:116)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
....
....
==================================
That is why when I try to connect to oracle thrugh my code then it gives me
NullPointerException
Could you please let me know, what special settings do I need to do for
WebLogic in order to Connect to Oracle.
Thanks.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html