I'm reusing connection within 1 class 3 times. Stored procedures are =
slow and sometimes take about 5 - 10 min each to get data. I'm getting =
this message from the pool :
21 Sep 2004 21:26:46,053 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
000001 (00/00/00) - #0001 removed because it has been active for too =
long.
21 Sep 2004 21:26:46,059 [WARN ] org.logicalcobwebs.proxool.CPS {?:?} - =
#0001 was active for 10330 milliseconds and has been removed =
automaticaly. The Thread responsible was named 'Thread-4'.
21 Sep 2004 21:26:46,071 [DEBUG] =
org.logicalcobwebs.proxool.SmartConnection {?:?} - 000001 (00/00/00) - =
#0001 removed because it has been active for too long.
21 Sep 2004 21:26:46,074 [FATAL] ocs.app.smartconn.Package {?:?} - =
TransferPackages(BatchId =3D 47621) - Failed
com.ibm.db2.jdbc.app.DB2JDBCException: Internal driver error.
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 =
(Throwable.java:85)=20
java/lang/Exception.<init>(Ljava/lang/String;)V+1 =
(Exception.java:33)=20
=
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1 =
(SQLException.java:34)=20
=
com/ibm/db2/jdbc/app/DB2Exception.<init>(Ljava/lang/String;Ljava/lang/Str=
ing;I)V+1 (DB2Exception.java:49)=20
=
com/ibm/db2/jdbc/app/DB2JDBCException.<init>(Ljava/lang/String;)V+1 =
(DB2JDBCException.java:121)=20
=
com/ibm/db2/jdbc/app/DB2CallableStatementRuntimeImpl.getRealType(II)I+43 =
(DB2CallableStatementRuntimeImpl.java:319)=20
com/ibm/db2/jdbc/app/DB2CallableStatement.getInt(I)I+74 =
(DB2CallableStatement.java:845)=20
=
org/logicalcobwebs/proxool/ProxyStatement.invoke(Ljava/lang/Object;Ljava/=
lang/reflect/Method;[Ljava/lang/Object;)Ljava/lang/Object;+89 =
(ProxyStatement.java:68)=20
=
org/logicalcobwebs/cglib/proxy/Proxy$ProxyImpl$$EnhancerByCGLIB$$eb57bddb=
.getInt(I)I+47 (<generated>:0)=20
ocs/app/smartconn/Package.TransferPackages(I)Z+105 =
(Package.java:479)=20
ocs/app/smartconn/Package.StartTransfer(I)Z+109 (Package.java:66)=20
ocs/app/smartconn/MainThread.run()V+333 (MainThread.java:105)=20
ocs/util/lang/WorkerThread.run()V+14 (ThreadPool.java:152)=20
21 Sep 2004 21:26:46,106 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Closing statement 6f8bf22b automatically
21 Sep 2004 21:26:46,110 [WARN ] org.logicalcobwebs.proxool.CPS {?:?} - =
Unable to set status of connection 1 from ACTIVEto AVAILABLE. It remains =
NULL
21 Sep 2004 21:26:46,113 [WARN ] =
org.logicalcobwebs.proxool.SmartConnection {?:?} - Unable to set status =
of connection 1 from ACTIVEto AVAILABLE. It remains NULL
I've tried to setup bigger timeout but it doesn't look like it works , =
here is the configuration :
21 Sep 2004 21:25:38,143 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Recognised proxool property: =
proxool.driver=3Dcom.ibm.db2.jdbc.app.DB2Driver
21 Sep 2004 21:25:38,146 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Recognised proxool property: proxool.url=3Djdbc:db2://localhost
21 Sep 2004 21:25:38,148 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Recognised proxool property: proxool.maximum-active-time=3D6000
21 Sep 2004 21:25:38,151 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Delegating property to driver: user=3Droman
21 Sep 2004 21:25:38,153 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Delegating property to driver: password=3D********
21 Sep 2004 21:25:38,155 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Recognised proxool property: proxool.maximum-connection-count=3D10
21 Sep 2004 21:25:38,157 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Recognised proxool property: proxool.house-keeping-test-sql=3Dselect =
CURRENT_DATE
21 Sep 2004 21:25:38,256 [DEBUG] org.logicalcobwebs.proxool.CPS {?:?} - =
Ignoring attempt to map reset method getHoldability (probably because it =
isn't implemented in this JDK)
Any thoughts ?=20
Thanks,
Roman
###########################################=0A=
=0A=
This message has been scanned by F-Secure Anti-Virus for Microsoft =
Exchange.=0A=
For more information, connect to http://www.F-Secure.com/ |
