tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "D'Alessandro, Arthur" <>
Subject RE: Tomcat reconnect to database server?
Date Wed, 07 Jan 2004 14:48:18 GMT
You may also want to put in a validation query, it adds overhead, but it
forces a reconnection.. I had a similar problem with postgres where the
pooled connections didn't know they were no longer properly connected.
By adding the validation query, it forces the manager to verify
connection before handing the connection down to the requesting code. 


-----Original Message-----
From: Philipp Taprogge [] 
Sent: Wednesday, January 07, 2004 9:47 AM
To: Tomcat Users List
Subject: Re: Tomcat reconnect to database server?


I don't know MSSQL in particular, but in princible it should be as
simple as adding ?autoreconnect=true to the driver URL.


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 
> datasources (through <Resource> and <ResourceParam> elements within 
> <GlobalNamingResources>).  I presume that at startup, Tomcat connects 
> to the server and creates a pool of connections for later use.  
> However, when we restart our server, Tomcat loses its connection(s) 
> and does not re-establish these connections.

And on the seventh day, He exited from append mode.
(Book of create(2), line 255)

To unsubscribe, e-mail:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message