wood burning stoves
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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Products » Tomcat
Bookmark "Tomcat Connection Pooling problem " Watch "Tomcat Connection Pooling problem " New topic

Tomcat Connection Pooling problem

Insia ahmad

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
It's not a secret anymore!