there are many softwares available for connection pooling. In fact many of the servers have support for connection pooling in built in them. You could check out your server documentation, for more details. TC4.x has support.
check out this link http://www.webdevelopersjournal.com/columns/DBConnectionManager.java -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Paul van Beukering Sent: Tuesday, February 04, 2003 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Connection Is there no generic free software avaliable for connection pooling? -----Original Message----- From: Vikramjit Singh [mailto:[EMAIL PROTECTED]] Sent: dinsdag 4 februari 2003 13:41 To: [EMAIL PROTECTED] Subject: Re: Connection use connection pooling. make a singleton class which handles connection pooling for you. In your servlet, load-on-startup in your init() method you can call the beans method, which opens a number of connections for you. You could check out the archives where this topic has been discussed. -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Uthiresh Narayanan Sent: Tuesday, February 04, 2003 3:56 PM To: [EMAIL PROTECTED] Subject: Connection Hi, In one of the functions in my servlet a connection is opened thru JDBC. In the try - catch - finally block of the code the connection is closed. I know that to open and close connections in not the correct way to do it. After sometime the database shows maximum sessions exceeded and locks up. Could this be becoz of this reason or someother reason. I also wanted a design stratergy to open database connections in a servlet. Maybe define a global static connection object and open it in init() and close it when the servelet is unloaded in destroy(). any better ideas? TIA, uthiresh ___________________________________________________________________________ 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 ___________________________________________________________________________ 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
