RE: Tomcat reconnect to database server?

2004-01-08 Thread Derek Mahar
, 2004 7:24 AM To: Derek Mahar Subject: RE: Tomcat reconnect to database server? I think u r just wrong. We are not talking bout the JDBC driver itself but for the apache DBCP and POOL implementations. And THAT dbpool package supports the option of validation query -Original Message

Re: Tomcat reconnect to database server?

2004-01-07 Thread Philipp Taprogge
Hi! I don't know MSSQL in particular, but in princible it should be as simple as adding ?autoreconnect=true to the driver URL. Phil Derek Mahar wrote: How can I configure Tomcat 5.0.16 to reconnect to a Microsot SQL Server after a server restart? I have configured Tomcat to use JNDI

RE: Tomcat reconnect to database server?

2004-01-07 Thread D'Alessandro, Arthur
handing the connection down to the requesting code. -Art -Original Message- From: Philipp Taprogge [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 9:47 AM To: Tomcat Users List Subject: Re: Tomcat reconnect to database server? Hi! I don't know MSSQL in particular

RE: Tomcat reconnect to database server?

2004-01-07 Thread Derek Mahar
the connection pool. Derek -Original Message- From: Philipp Taprogge [mailto:[EMAIL PROTECTED] Sent: January 7, 2004 9:47 AM To: Tomcat Users List Subject: Re: Tomcat reconnect to database server? Hi! I don't know MSSQL in particular, but in princible it should be as simple as adding

RE: Tomcat reconnect to database server?

2004-01-07 Thread Derek Mahar
Where do I specify the validation query? Is there a way to configure the default connection pool manager? Derek -Original Message- From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED] Sent: January 7, 2004 9:48 AM To: Tomcat Users List Subject: RE: Tomcat reconnect to database server

RE: Tomcat reconnect to database server?

2004-01-07 Thread Altankov Peter
This goes underResourceParams name=jdbc/your_resource BR -Original Message- From: Derek Mahar [mailto:[EMAIL PROTECTED] Sent: 07 2004 . 18:21 To: Tomcat Users List Subject: RE: Tomcat reconnect to database server? Thanks for your reply. Unfortunately, the Microsoft SQL

RE: Tomcat reconnect to database server?

2004-01-07 Thread Steve Nelson
? -Original Message- From: Altankov Peter [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 10:38 AM To: Tomcat Users List Subject: RE: Tomcat reconnect to database server? The DBCP pool that you lookup from JNDI is already such a connection manager. Just try adding the validation query