Im not familiar with that particualt Database but if you follow Oracles ideas on
how to configure Connection Pools (Many logical connections to 1 Physical Connection)
and Connection Caching (how big should the cache be and when should you release the resource) you can tweak you Connection Pooling/Caching Algorithm to such factors as
1)Pooling/Caching Connections for connections which are accessed Intermittently
2)Pooling/Caching Connections for connections which are being accessed constantly
Here is a link to get you started:
http://otn.oracle.com/products/oracle9i/daily/jul16.htmlAfter designing a strategy for Connection Pooling/Caching you might also want to
take a look at commensurate policy for dbcursors.
In either let me know you make out,
Martin Gainty
>From: "Campano, Troy" <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Connection Pooling
>Date: Tue, 20 Aug 2002 13:20:55 -0400
>MIME-Version: 1.0
>Received: from [192.18.99.108] by hotmail.com (3.2) with ESMTP id MHotMailBF2BC591006140043718C012636CA64C0; Tue, 20 Aug 2002 10:21:45 -0700
>Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by swjscmail2.java.sun.com (Postfix) with ESMTPid 7A8802255E; Tue, 20 Aug 2002 11:18:38 -0600 (MDT)
>Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8d) with spool id 2512437 for [EMAIL PROTECTED]; Tue, 20 Aug 2002 11:16:52 -0600
>Received: from charon.lmig.com (charon.lmig.com [143.115.190.14]) by swjscmail1.java.sun.com (Postfix) with ESMTP id 055E4484B for <[EMAIL PROTECTED]>; Tue, 20 Aug 2002 11:16:52 -0600 (MDT)
>Received: from LM-EXIMS-02.lm.lmig.com (lm-exims-02.lm.lmig.com [147.179.184.111]) by charon.lmig.com (8.10.2+Sun/8.10.2) with ESMTP id g7KHKwA02365 for <[EMAIL PROTECTED]>; Tue, 20 Aug 2002 13:20:58 -0400 (EDT)
>From [EMAIL PROTECTED] Tue, 20 Aug 2002 10:23:22 -0700
>Delivered-To: [EMAIL PROTECTED]
>content-class: urn:content-classes:message
>X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3
>X-MS-Has-Attach:
>X-MS-TNEF-Correlator:
>Thread-Topic: Connection Pooling
>Thread-Index: AcJIbfGc02X9XcQKTaONWRFzIntxPg==
>Message-ID: <
[EMAIL PROTECTED]>
>Sender: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]>
>
>I'm new to connection pooling. Could someone please tell me if I am on the right track?
>
>
>If I set the amount of MAXIMUM ACTIVE CONNECTIONS to 4, does that mean that only 4 people can be logged into the web app or that there are 4 connections that are shared among all the users?
>
>Does this mean I want to set MAXIMUM ACTIVE CONNECTIONS to the amount of users I think would be using a webapp at a given time?
>
>
>Are there docs on how a lot of this connection pooling stuff works?
>I am using Tomcat with DBCP.
>
>
>thank you!
>
>
>==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
>For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
