Tomcat reconnect to database server? 2004-01-08 - By Derek Mahar
Back
Actually, I am correct that the Microsoft SQL Server JDBC driver does not
support a validationQuery option. However, I agree that I was incorrect in
assuming that the resource parameters configured the JDBC driver, rather than
the connection pool (and the JDBC driver indirectly). I'm glad that you
corrected my mistake.
Fortunately, one thing that I've learned from using mailing lists is that there
's no better way to get someone to give you the right answer than to suggest the
wrong one!
Derek
-- --Original Message-- --
From: Altankov Peter [mailto:PAltankov@(protected)]
Sent: January 8, 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-- --
> From: Derek Mahar [mailto:DMahar@(protected)]
> Sent: 07 ������ 2004 �. 20:41
> To: Altankov Peter
> Subject: RE: Tomcat reconnect to database server?
>
>
> Thanks for the suggestion. After reading the MS SQL Server
> JDBC driver documentation, however, it appears that the
> driver does not support the validationQuery option. :-(
>
> Derek
>
> -- --Original Message-- --
> From: Altankov Peter [mailto:PAltankov@(protected)]
> Sent: January 7, 2004 11: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 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)
|
|
