And this also works for mySQL
Siegfried Goeschl
Mark Shifman 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
