tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Mon, 05 Mar 2012 21:06:22 GMT
> No if the connection has been reset by the instance. The query will result
> in a SQLException. You have to close the connection and open a new one. The
> query works on an open connection only. That's the point.
> See the second paragraph of this [1].

But the problem was when you restart the remote database , not the
local database.
In this case, SELECT 1 FROM DUAL works ( doesn't return a SQL exception ).
But , when you execute after the query "SELEC * FROM TABLE@remotedb",
then fails , was this the problem, right ?

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message