-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 (rather
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
?xml version=1.0 encoding=UTF-8?
!-- Connessione al db sul server jsys--
Context path=/xxx docBase=xxx debug=5 reloadable=true
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
@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 ?xml version=1.0 encoding=UTF-8? !--
Connessione al db sul
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 with
does not endorse distribution to any party other than intended recipient.
Sender does not necessarily endorse content contained within this
transmission. Date: Sun, 28 Dec 2008 12:25:05 -0800 From:
gbatt...@alice.it To: users@tomcat.apache.org Subject:
java.sql.SQLException: Already closed