Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 81722 invoked by uid 500); 5 Oct 2001 19:27:49 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk Reply-To: tomcat-user@jakarta.apache.org list-help: list-unsubscribe: list-post: Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 81707 invoked from network); 5 Oct 2001 19:27:49 -0000 From: "Will Stranathan" Subject: Tyrex pool size To: tomcat-user@jakarta.apache.org X-Mailer: CommuniGate Pro Web Mailer v.3.2.4 Date: Fri, 05 Oct 2001 14:30:11 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Is there a way in the ResourceParams to set up the initial, max, min, and desired sizes of the Tyrex pools? And is there something special you have to do to get it to actually pool the connections? When I do a DataSource.getConnection(), it always returns a brand new connection even though I properly close() connections when I'm done with them. Then it takes about 5 minutes or so for those connections to clear. I would prefer to make a handful of connections, then grab one of the available ones (more like a real connection pool.) I've seen this behavior with both the mm.mysql driver and with the FreeTds driver. Does my driver have to support something special to work properly? Will Stranathan