for Oracle use validationQuery="SELECT 1 from dual"
James Carman wrote: > I'd use a validation query. I believe that will solve your problem. > That way, the pool implementation can check to see that the connection > is "valid" before handing it off to you. For HSQLDB, I use: > > select 1 from INFORMATION_SCHEMA.SYSTEM_USERS > > You can come up with something similar for other database products. > Hope that helps! > > On Thu, May 22, 2008 at 4:43 AM, <[EMAIL PROTECTED]> wrote: >> Hello, >> >> I use database connection pool BasicDataSource for manegment of DB >> connections. When DB Server is restarted all connections are loosed. >> How can I handle this situation? Should I create new BasicDataSource >> or invoke some method. >> >> Thank you. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- Mark Shifman MD. Ph.D. Yale Center for Medical Informatics Phone (203)737-5219 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
