-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ken,
Ken Bowen wrote:
> validationQuery="select 1"
validationQuery="/* ping */ SELECT 1"
would be better. Newer versions of Connector/J will detect the "ping"
comment and use an even cheaper connection test than what is required to
execute this (rat
mcat.apache.org> Subject:
> java.sql.SQLException: Already closed..strange!> > > Hello guys,> I've a
> strange problem with my jsp application.> I use Tomcat 6.0.18.> I use
> connection pool with dbcp and this is context.xml of my application> > >
>
Can you post relevant portions of your code? This smells like your code
is accessing the underlying connection object DBCP wraps and closing
that instead of the DBCP connection object. That'll subvert DBCP and
give you problems.
--David
gbattine wrote:
> Hello guys,
> I've a strange problem wit
it> To:
users@tomcat.apache.org> Subject: java.sql.SQLException: Already
closed..strange!> > > Hello guys,> I've a strange problem with my jsp
application.> I use Tomcat 6.0.18.> I use connection pool with dbcp and this is
context.xml of my application> > >
You're probably running into the fact that MYSQL closes connections
which have been open "too long".
Probably if you make the request to the server again, you'll find that
it works because the connection is reopened.
One way to deal with this is to add the following to your context.xml
Resour
Hello guys,
I've a strange problem with my jsp application.
I use Tomcat 6.0.18.
I use connection pool with dbcp and this is context.xml of my application
>
When I run application it works correctly.
Sometimes (I'm not able to understand why) I've got, running application,
this error:
