If you send me a piece of your code I'll look it over. :)
James
[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
> Hi James
>
> I'm closing the statements prior to myBroker.freeConnection(Connection).
>
> I must be doing something wrong but I sure don't know what it is.
>
> Thanx, PLA
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of James
> Wilson
> Sent: Tuesday, August 28, 2001 11:36 AM
> To: [EMAIL PROTECTED]
> Subject: Re: DbConnectionBroker & Connections Exhausted message
>
> 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
>
> ___________________________________________________________________________
> 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
--
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
