That's wierd -- I've used DbConnectionBroker for a long time and have never had
this problem. Just an idea -- are you closing you Statements and
PreparedStatements before you call myBroker.freeConnection(Connection)? If you
don't close them DbConnectionBroker will not think they are free.
Hope that helps,
James Wilson
[EMAIL PROTECTED] wrote:
> 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/
> /
--
James Wilson
Internet Developer
U.S. District Court
District of New Mexico
333 Lomas Blvd., NW
Albuquerque, NM 87102
Phone: (505) 348-2081
Fax: (505) 348-2028
[EMAIL PROTECTED]
--
___________________________________________________________________________
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
