Thank you guys!
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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
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 implementati
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
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 d
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.
--
