This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Tomcat and the fly likes Tomcat Connection Pooling problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat Connection Pooling problem " Watch "Tomcat Connection Pooling problem " New topic
Author

Tomcat Connection Pooling problem

Insia ahmad
Greenhorn

Joined: Jun 15, 2005
Posts: 3
Hi Guys,

I am having continuous problem with the Tomcat Connection Pooling,... my applicaion works fine with the connection and ......after some time when i try to login it throws the following exception ...

java.sql.SQLException: System or internal error
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:348)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2202)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1053)
at com.informix.jdbc.IfxResultSet.executePrepare(IfxResultSet.java:185)
at com.informix.jdbc.IfxPreparedStatement.setupExecutePrepare(IfxPreparedStatement.java:195)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:173)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1647)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:187)
at com.i2c.modules.LoginDAOImpl.isValidUser(LoginDAOImpl.java:44)


where the 44th line of LoginDAOImpl.java is:



where my getConnection() method goes as follwos




Any Help whould be greatly appreciated ...
Insia Ahmad
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
my applicaion works fine with the connection and ......after some time when i try to login it throws the following exception ...


1. I would recommend that you review your code for situations where you are acquiring a connection and when finished, you are not closing the connection(s), thus not returning it to the connection pool.


2. Is this the 44th line:


or this one:


If the problem is traced to the latter, I would recommend that you display
"LOGIN_QUERY" and review that the syntax is correct.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Tomcat Connection Pooling problem