Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 84327 invoked from network); 9 Oct 2003 13:31:02 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 9 Oct 2003 13:31:02 -0000 Received: (qmail 95769 invoked by uid 500); 9 Oct 2003 13:30:34 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 95734 invoked by uid 500); 9 Oct 2003 13:30:33 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 95704 invoked from network); 9 Oct 2003 13:30:33 -0000 Received: from unknown (HELO mbi-hq-it-ex001.mbi.co.at) (80.64.133.20) by daedalus.apache.org with SMTP; 9 Oct 2003 13:30:33 -0000 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: AW: Urgent help, please!Best practices using Connection Pool X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 Date: Thu, 9 Oct 2003 15:27:57 +0200 Message-ID: <75B2597ADD28AD4A9D1B002C8043298A2D8C50@mbi-hq-it-ex001.mbi.co.at> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Urgent help, please!Best practices using Connection Pool Thread-Index: AcOOaGjFnwtJgGxgQN6GIVT/AhxpkgAADdPA From: "Nitschke Michael" To: "Tomcat Users List" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I could remember that there was a mail today that answered your = question. The pool provides an wrapper for the connection object that you receive, = this means you call getConnection and you do not get the real connection = instead you recive an object implementing the Connection functionality = with an altered "close()" method, which does not close/release the = connection, but returns the connection to the pool. If it was to short, read the original post in the archives. Mike -----Urspr=FCngliche Nachricht----- Von: Jose Euclides da Silva Junior - DATAPREVRJ = [mailto:Jose.Euclides@rj.previdenciasocial.gov.br]=20 Gesendet: Donnerstag, 09. Oktober 2003 15:27 An: 'tomcat-user@jakarta.apache.org' Betreff: Urgent help, please!Best practices using Connection Pool Hi gurus, help me please. i am using DBCP 1.0 to make connection pool avaiable. My question can be easy: since DBCP 1.0 doesnt create a singleton object ( just a = datasource object), what should i do whenever my sql queries are done? Should i = close the connection after each sql command is completed? But, if i do this, = will i loose my connection pool facility, so my next sql command will spend = more time since the connection process ( with the database ) would be started before the sql running. I really need to improve my database response = time! Thanks in advance, Euclides. =20 --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org