tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Curwen" <>
Subject RE: Microsoft SQL Server validation query
Date Thu, 08 Jan 2004 19:07:49 GMT
Does it really matter if it's different?  You are setting up a
datasource in  a configuration file, the contents of that configuration
are pretty much guaranteed to be different for every database anyways.
(JDBC URL and Driver come to mind). Adding one more (the validation
query) is not too much of a burden.

> -----Original Message-----
> From: Peter Lin [] 
> Sent: Thursday, January 08, 2004 10:32 AM
> To: Tomcat Users List
> Subject: RE: Microsoft SQL Server validation query
> off hand I know selecting the date from sybase, sql server 
> and oracle are all different. one way around it is to use a 
> stored procedure, that way you can have the same stored proc 
> in each RDBMS and the java call is the same.
> I'm sure others have done it a different way, but that's how 
> I've tackled the problem in the past.
> peter
> Derek Mahar <> wrote:
> Thank you to all of you for your quick replies. It seems that 
> the connection pool validation query is not specific to any 
> database server implementation unless the query statement 
> itself is server-specific (that is, it refers to a special 
> server system database, table, or function). I like the idea 
> of querying the server for the date, but I'm not sure that 
> the date function is standard SQL and portable across all 
> server implementations. Does anyone know otherwise?
> Derek
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes

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

View raw message