Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problems connecting to Oracle on NT using Weblogic 5.1 sp9

23 views
Skip to first unread message

Gary Marsh

unread,
May 25, 2001, 1:36:44 PM5/25/01
to

Hi;

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 Clark

unread,
May 29, 2001, 3:59:21 PM5/29/01
to
As for D:\weblogic\classes>java utils.t3dbping t3://localhost:7001 cdidev2
BBBBBB WDEV
make sure weblogicaux.jar is in the classpath.

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
)

0 new messages