Hi All
I'm testing the DbConnectionBroker.class and
HttpServletJXGB.class found at http://www.javaexchange.com .
I've got it running on two different machines.
Win2k/TomCat 3.2.3/mySQL
AS400/TomCat 3.2.1/DB2
I can't get either of them to reuse the connections
in my the pool. I'm closing the statements and
freeing the connection in a finally.
To test, I'm using a HTML document with 9 IFRAMES to the same
servlet.
My dblog.txt files looks like this after 2 tries on the
AS/400 machine:
START SNIPPET ------->
Starting DbConnectionBroker Version 1.0.11:
dbDriver = com.ibm.db2.jdbc.app.DB2Driver
dbServer = jdbc:db2://*LOCAL
dbLogin =
log file = /home/javaexchange/servlet/dblog.txt
minconnections = 10
maxconnections = 10
Total refresh interval = 10.0 days
-----------------------------------------
Mon Aug 27 19:01:33 EDT 2001 Opening connection 0 *LOCAL:
Mon Aug 27 19:01:36 EDT 2001 Opening connection 1 *LOCAL:
Mon Aug 27 19:01:37 EDT 2001 Opening connection 2 *LOCAL:
Mon Aug 27 19:01:37 EDT 2001 Opening connection 3 *LOCAL:
Mon Aug 27 19:01:38 EDT 2001 Opening connection 4 *LOCAL:
Mon Aug 27 19:01:38 EDT 2001 Opening connection 5 *LOCAL:
Mon Aug 27 19:01:38 EDT 2001 Opening connection 6 *LOCAL:
Mon Aug 27 19:01:39 EDT 2001 Opening connection 7 *LOCAL:
Mon Aug 27 19:01:39 EDT 2001 Opening connection 8 *LOCAL:
Mon Aug 27 19:01:39 EDT 2001 Opening connection 9 *LOCAL:
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 3
-----> Connections Exhausted! Will wait and try again in loop 3
-----> Connections Exhausted! Will wait and try again in loop 1
-----> Connections Exhausted! Will wait and try again in loop 4
-----> Connections Exhausted! Will wait and try again in loop 2
-----> Connections Exhausted! Will wait and try again in loop 3
<----- END SNIPPET
A couple of things jump out at me. The "Version 1.0.11", the
web site says version 2.0.
"Total refresh interval = 10.0 days" I change this from .5 to
10 I don't think this should be causing my problem.
Any ideas on what is causing this would be appreciated.
Thanx, PLA
/
/ Patrick L Archibald
/ http://HomeTelco.com/pla/
/
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
