Return-Path: Delivered-To: apmail-tomcat-users-archive@www.apache.org Received: (qmail 65886 invoked from network); 8 Jul 2008 12:54:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 8 Jul 2008 12:54:15 -0000 Received: (qmail 91050 invoked by uid 500); 8 Jul 2008 12:54:05 -0000 Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org Received: (qmail 91022 invoked by uid 500); 8 Jul 2008 12:54:05 -0000 Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Tomcat Users List" Delivered-To: mailing list users@tomcat.apache.org Received: (qmail 91005 invoked by uid 99); 8 Jul 2008 12:54:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jul 2008 05:54:05 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Jonas.Wagner@bucher-suter.ch designates 212.103.69.150 as permitted sender) Received: from [212.103.69.150] (HELO webmail.bucher-suter.ch) (212.103.69.150) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Jul 2008 12:53:10 +0000 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: Configuring DataSources using jsp: reload context.xml? Date: Tue, 8 Jul 2008 14:53:09 +0200 Message-ID: In-Reply-To: <203834.75147.qm@web52409.mail.re2.yahoo.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Configuring DataSources using jsp: reload context.xml? Thread-Index: Acjg5zRkO8oqJGFYR2uSDekXkFdHTAAEWjiQ References: <203834.75147.qm@web52409.mail.re2.yahoo.com> From: "Jonas Wagner" To: "Tomcat Users List" X-CT-RefID: str=0001.0A0B0206.48736336.0021,ss=1,fgs=0 X-Virus-Checked: Checked by ClamAV on apache.org Thanks Sameer for your reply! > That may work for new datasources but could create a problem > for existing data sources specifically if they are already > being used and have pooled connections. The existing pooled > connections may be in use by the applications too. Since the application connects to its datasources using the DriverManager class, I cannot use connection pooling. That's one of the reasons I tried using JNDI for such a long time :-( > Restarting the tomcat after modifying datasource may be a > better and simpler option. I have to restart (at least) the application anyway, because I open database connections in the init() of my servlet. Restarting Tomcat should not be necessary when using the DriverManager approach because Tomcat is not involved in the database connections. Using the JNDI approach, restarting Tomcat does not apply any changes made to the datasources (see my previous mails). Jonas --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For additional commands, e-mail: users-help@tomcat.apache.org