File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Problem with database connection pooling resin+mysqlw
Joined: May 31, 2001
Jul 23, 2005 17:19:00
Urgent.. We are facing a problem with database connection pooling in our production setup.
Our current setup is:
application running on Resin 3.0.12 web server with MySQL 4.0.23 database
We have configured database connection pooling as per resin documentation.
extracted from resin.conf:
Randomly the application throws an
with message as'Opearation not allowed after Resultset is closed' or
'Connection reset by peer'.
The datasource(ds) is looked up in the init method and the connection is opened once using ds.getConnection at the top of the
jsp page within a try block and is closed in the corresponding finally block at the very end of the jsp page. The connection
or the result set is not closed anywhere else except in the finally block.
( MySQL is configured with MaxConnections 100 )
Any kind of help is appreciated, Thank you !
author and iconoclast
Joined: Jul 08, 2003
Jul 23, 2005 18:35:00
Please don't post duplicate queries in multiple forums. I deleted the copy you left in JSP.
[Jess in Action]
I agree. Here's the link:
subject: Problem with database connection pooling resin+mysqlw
JBOSS startup error
Jboss connection pool doesn't release the connections
Resin DB-pooling + authentication. HELP!
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015