Tomcat reconnect to database server? 2004-01-07 - By Altankov Peter
Back
The DBCP pool that you lookup from JNDI is already such a connection manager.
Just try adding the validation query that Arthur suggested.
Im not sure for MSSQL but I use this for Oracle:
<parameter>
<name>validationQuery</name>
<value>SELECT 1 FROM dual</value>
</parameter>
This goes under <ResourceParams name="jdbc/your_resource">....
BR
> -- --Original Message-- --
> From: Derek Mahar [mailto:DMahar@(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
> 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)
>
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)
|
|
