Tomcat reconnect to database server? 2004-01-07 - By Derek Mahar
Back
Thanks for your reply. Unfortunately, the Microsoft SQL Server JDBC
driver does not support an autoreconnect option. Do I need a separate
connection pool manager? The MS SQL Server JDBC driver documentation
suggests that I might need such a manager since the driver does not
itself manage the connection pool.
Derek
-- --Original Message-- --
From: Philipp Taprogge [mailto:philipp.taprogge@(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 ?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)
|
|
