DB2 connection failing under tomcat.
Posted: Wed Nov 01, 2006 3:42 pm
Hi,
I have configured the DB2 connection in server.xml as you recommend, and added the necessary tags to provide things like user ids and passwords, etc. The xml file is also configured in Catalina/localhost/newapp.xml as outlined.
However, when trying to connect from a java servlet, I receive no errors, however was able to get the IBM trace information which suggests that that there are no available pooled connections and no used pooled connections.
Here are the contents of /tmp/mytrce.JTRACE
<2006.11.01 15:13:55.652> <Entry> <printHeader> <COM.ibm.db2os390.sqlj.util.DB2SQLJTrace> <http-9090-Processor25>
-- <p#1=Start of DB2 SQLJ/JDBC Tracing <2006.11.01 15:13:55.647>>
-- <p#2=DB2 for OS/390 SQLJ/JDBC Driver build version is: DB2 7.1 PQ69861 JDBC 2.0>
<2006.11.01 15:13:55.659> <Entry> <Constructor> <com.ibm.db2.jcc.DB2ConnectionCache> <http-9090-Processor25>
<2006.11.01 15:13:55.664> <Exit> <Constructor> <com.ibm.db2.jcc.DB2ConnectionCache> <http-9090-Processor25>
-- <p#1=com.ibm.db2.jcc.DB2ConnectionCache@542e98e3[mPoolSize=0;mActiveSize=0;mMaxLimit=100]>
<2006.11.01 15:13:55.675> <Entry> <getConnection> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=databaseName=DSN1>
-- <p#2=PlanName=null>
-- <p#3=username=XXXXXXXX>
-- <p#4=password was specified>
<2006.11.01 15:13:55.680> <Entry> <removeFromPool> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=PlanName=DSNJDBC>
<2006.11.01 15:13:55.686> <Exit> <removeFromPool> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=PooledConnection=null>
-- <p#2=Available PooledConnections=0>
-- <p#3=Total Open PooledConnections=0>
<2006.11.01 15:13:56.060> <Entry> <Constructor> <COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2> <http-9090-Processor25>
-- <p#1=source=DSN1>
-- <p#2=parser=COM.ibm.db2os390.sqlj.jdbc.parser.DB2JDBCParser@1a6a18e3>
-- <p#3=planname=DSNJDBC>
-- <p#4=pooledConnection=com.ibm.db2.jcc.DB2PooledConnection@7ad4d8e2>
<2006.11.01 15:13:56.163> <Entry> <setError> <COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2> <http-9090-Processor25>
-- <p#1=DB2SQLJConnection=COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2[pCONN=0]>
-- <p#2=rc=-1>
-- <p#3=name=DB2SQLJConnection error in native method: constructor: RRS "CREATE THREAD" failed using DB2 system:DSN1, Plan:DSNJDBC , RC=08 and REASON=00f30034
I just can't seem to get this to connect..... Any ideas anyone?
I have configured the DB2 connection in server.xml as you recommend, and added the necessary tags to provide things like user ids and passwords, etc. The xml file is also configured in Catalina/localhost/newapp.xml as outlined.
However, when trying to connect from a java servlet, I receive no errors, however was able to get the IBM trace information which suggests that that there are no available pooled connections and no used pooled connections.
Here are the contents of /tmp/mytrce.JTRACE
<2006.11.01 15:13:55.652> <Entry> <printHeader> <COM.ibm.db2os390.sqlj.util.DB2SQLJTrace> <http-9090-Processor25>
-- <p#1=Start of DB2 SQLJ/JDBC Tracing <2006.11.01 15:13:55.647>>
-- <p#2=DB2 for OS/390 SQLJ/JDBC Driver build version is: DB2 7.1 PQ69861 JDBC 2.0>
<2006.11.01 15:13:55.659> <Entry> <Constructor> <com.ibm.db2.jcc.DB2ConnectionCache> <http-9090-Processor25>
<2006.11.01 15:13:55.664> <Exit> <Constructor> <com.ibm.db2.jcc.DB2ConnectionCache> <http-9090-Processor25>
-- <p#1=com.ibm.db2.jcc.DB2ConnectionCache@542e98e3[mPoolSize=0;mActiveSize=0;mMaxLimit=100]>
<2006.11.01 15:13:55.675> <Entry> <getConnection> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=databaseName=DSN1>
-- <p#2=PlanName=null>
-- <p#3=username=XXXXXXXX>
-- <p#4=password was specified>
<2006.11.01 15:13:55.680> <Entry> <removeFromPool> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=PlanName=DSNJDBC>
<2006.11.01 15:13:55.686> <Exit> <removeFromPool> <com.ibm.db2.jcc.DB2ConnectionCache@542e98e3> <http-9090-Processor25>
-- <p#1=PooledConnection=null>
-- <p#2=Available PooledConnections=0>
-- <p#3=Total Open PooledConnections=0>
<2006.11.01 15:13:56.060> <Entry> <Constructor> <COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2> <http-9090-Processor25>
-- <p#1=source=DSN1>
-- <p#2=parser=COM.ibm.db2os390.sqlj.jdbc.parser.DB2JDBCParser@1a6a18e3>
-- <p#3=planname=DSNJDBC>
-- <p#4=pooledConnection=com.ibm.db2.jcc.DB2PooledConnection@7ad4d8e2>
<2006.11.01 15:13:56.163> <Entry> <setError> <COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2> <http-9090-Processor25>
-- <p#1=DB2SQLJConnection=COM.ibm.db2os390.sqlj.jdbc.DB2SQLJConnection@6a3d58e2[pCONN=0]>
-- <p#2=rc=-1>
-- <p#3=name=DB2SQLJConnection error in native method: constructor: RRS "CREATE THREAD" failed using DB2 system:DSN1, Plan:DSNJDBC , RC=08 and REASON=00f30034
I just can't seem to get this to connect..... Any ideas anyone?