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
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.