Hi,
I am using weblogic 5.1/6.1 to access the database (DB2) either locally or remotely.
Initially i am using DB2 installed in the remote System using weblogic6.1/5.1. It was working fine.
Now it is giving error for remote system using COM.ibm.jdbc.db2.net.DB2Driver but to access the DB2 in the local System using COM.ibm.jdbc.db2.app.DB2Driver,it is working fine.
The log file(weblogic5.1) is given below:
In this server i am using DB2Pool for remote DB2 accessing and oraclePool for remote oracle accessing and DB2Pool2 for local DB2 accessing. Please let me know what was the reason for above error and how to solve it.
Thanks & Regards,
M.S.Raman
{refreshMinutes=10, poolName=DB2Pool2, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=wcs;password=wcs;, allowShrin
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:47 GMT+05:30 2001:<I> <
JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:48 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:49 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Delaying 1 seconds before making a DB2Pool2 pool connection.
Mon Jan 15 10:29:50 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "DB2Pool2" created.
Mon Jan 15 10:29:50 GMT+05:30 2001:<I> <JDBC Pool> Creating connection pool DB2Pool with:
{refreshMinutes=10, poolName=DB2Pool, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=wcs;password=wcs;, allowShrink
Delaying 1 seconds before making a DB2Pool pool connection.
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketException(SQLExceptionGenerator.java:574)
at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java, Compiled Code)
at COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:205)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:210)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:149)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
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: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 Jan 15 10:29:56 GMT+05:30 2001:<I> <JDBC Pool> Sleeping in createResource()
Mon Jan 15 10:29:57 GMT+05:30 2001:<E> <JDBC Pool> Failed to create connection pool "DB2Pool"
weblogic.common.ResourceException: weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0616E Error opening socket. SQLSTATE=08S01
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.socketException(SQLExceptionGenerator.java:574)
at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java, Compiled Code)
at COM.ibm.db2.jdbc.net.DB2Connection.<init>(DB2Connection.java:205)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:210)
at java.sql.DriverManager.getConnection(DriverManager.java:457)
at java.sql.DriverManager.getConnection(DriverManager.java:137)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:172)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
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: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)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:182)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:109)
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: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)
at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:125)
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: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 Jan 15 10:29:57 GMT+05:30 2001:<I> <JDBC Pool> Creating connection pool oraclePool with:
{refreshMinutes=10, poolName=oraclePool, loginDelaySecs=1, testTable=dual, maxCapacity=10, props=user=SCOTT;password=tiger;, allo
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:29:59 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:00 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:05 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Delaying 1 seconds before making a oraclePool pool connection.
Mon Jan 15 10:30:06 GMT+05:30 2001:<I> <JDBC Pool> Connection for pool "oraclePool" created.
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Beginning startup process
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Init JMS Security
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Initializing from weblogic.properties
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Startup process complete. JMS is active
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Bound SessionPoolManager as weblogic.jms.SessionPoolManager
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <JMS> Bound ConnectionConsumerManager as weblogic.jms.ConnectionConsumerManager
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <WebLogicServer> Invoking main-style startup RMI Registry weblogic.rmi.internal.RegistryIm
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <RMI> Registry started
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <
EJB> 0 EJB jar files loaded, containing 0 EJBs
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <EJB> 0 deployed, 0 failed to deploy.
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ZAC> ZAC ACLs initialized
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ZAC> ZAC packages stored in local directory exports
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <ListenThread> Listening on port: 7001
<NT Performance Pack> NATIVE: created IoCompletionPort successfully. IoPort=0x000001e4
Mon Jan 15 10:30:10 GMT+05:30 2001:<I> <SSLListenThread> Listening on port: 7002
Mon Jan 15 10:30:11 GMT+05:30 2001:<I> <WebLogicServer> WebLogic Server started