For Postgres I use: select now() On Thu, May 22, 2008 at 10:06 PM, Mark Shifman <[EMAIL PROTECTED]> wrote:
> 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] > >
