Tomcat reconnect to database server? 2004-01-07 - By Derek Mahar
Back
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:Arthur.Dalessandro@(protected)]
Sent: January 7, 2004 9:48 AM
To: Tomcat Users List
Subject: RE: Tomcat reconnect to database server?
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.
-Art
-- --Original Message-- --
From: Philipp Taprogge [mailto:philipp.taprogge@(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, 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
> 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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
