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 <[EMAIL PROTECTED]> 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
