I am having problems creating a connection to the Oracle db connection pool.
I am using the following script in the weblogic.properties file:
weblogic.jdbc.connectionPool.CDIOraclePool=\
url=jdbc:oracle:thin:@cabernet.goship.com:1521:WDEV,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=1,\
initialCapacity=10,\
maxCapacity=20,\
capacityIncrement=2,\
allowShrinking=true,\
shrinkPeriodMins=15,\
refreshMinutes=10,\
testTable=dual,\
props=user=CDIDEV2;password=BBBBBB
weblogic.allow.reserve.weblogic.jdbc.connectionPool.CDIOraclePool=everyone
and when I start the weblogic server I get the following Error message:
Fri May 25 09:00:18 PDT 2001:<I> <JDBC Pool> Sleeping in createResource()
Fri May 25 09:00:19 PDT 2001:<E> <JDBC Pool> Failed to create connection pool
"CDIOraclePool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:406)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:169)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:231)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:208)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:146)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
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:220)
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)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:154)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:108)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
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:220)
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)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:124)
at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.java,
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:220)
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)
I have tried testing the connection using the utils.t3dbping and this is the result:
D:\weblogic\classes>java utils.t3dbping t3://localhost:7001 cdidev2 BBBBBB WDEV
oracle.jdbc.driver.OracleDriver jdbc:
oracle:thin:@cabernet.goship.com:1521:WDEV
Connecting to WebLogic with the WebLogic JDBC Driver
Exception in thread "main" java.lang.NoClassDefFoundError: COM/rsa/jsafe/JSAFE_InvalidUseException
at weblogic.security.WLMessageDigest.getInstance(WLMessageDigest.java:53)
at weblogic.security.MD5RandomBitsSource.seed(MD5RandomBitsSource.java:56)
at weblogic.rjvm.LocalRJVM.<init>(LocalRJVM.java:108)
at weblogic.rjvm.LocalRJVM.getLocalRJVM(LocalRJVM.java:85)
at weblogic.rjvm.RJVMManager.getLocalRJVM(RJVMManager.java:89)
at weblogic.rjvm.RJVMManager.initialize(RJVMManager.java:78)
at weblogic.kernel.Kernel.ensureInitialized(Kernel.java:137)
at weblogic.common.T3Client.<init>(T3Client.java:218)
at weblogic.common.T3Client.<init>(T3Client.java:269)
at weblogic.common.T3Client.<init>(T3Client.java:323)
at weblogic.jdbcbase.t3.Driver.connect(Driver.java:121)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at utils.t3dbping.main(t3dbping.java:115)
I would appreciate any advice that can get me past this problem. Thanks,
Jim
"Gary Marsh" <gma...@goship.com> wrote in message
news:3b0e8a1c$1...@newsgroups.bea.com...
weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection
EnvFactory.java:124)
> 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
)