Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Tomcat Connection Pooling problem

 
Insia ahmad
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 405
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic