File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes Trouble with MySQL+TOMCAT Resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Trouble with MySQL+TOMCAT Resultset" Watch "Trouble with MySQL+TOMCAT Resultset" New topic

Trouble with MySQL+TOMCAT Resultset

toum toum

Joined: Nov 06, 2003
Posts: 1
I'm programming applets & servlets on Tomcat and MySQL with my desktop (PIII500 - Win2000 - 512Mo).
- jakarta-tomcat-4.1.27-LE-jdk14
- mysql-4.0.14b
- j2sdk1.4.2
- mysql-connector-java-3.0.9-stable
- Tomcat DBCP (collections-2.1 dbcp-1.0 pool-1.0.1)
But ! I can not have stable behaviour with ResultSet :
- Sometimes all records are returned. Fine !!!
- Sometimes, 0 (Zero) record is returned. Too bad !
- Sometimes, some (but not all) records are returned. Bad !
And, When all records are not returned, one of the two following exception types is raised :
java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.ResultSet.checkClosed(
at com.mysql.jdbc.ResultSet.checkRowPos(
at com.mysql.jdbc.ResultSet.checkRowPos(
at com.mysql.jdbc.ResultSet.getString(
at org.apache.commons.dbcp.DelegatingResultSet.getString(
What my application does :
- Inserting rows in a table (strings, dates, integers).
- And the, selecting table in a Resultset for gettind data
- I use ResultSet.getString() for getting all fields.
Database Pooling configuration in server.xml file :
What I DO NOT suspect :
- Having not closed connection, statement or cursor.
- Doing some computation with null variables.
Thanks in advance for your help.
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

Is MySQL transactional? Meaning if you have one session and you insert records, but don't commit, then wouldn't a sepertae session not see those records yet. Not much help, but an idea. Maybe it has to do with closing or not closing Connections correctly. But not much else to help since we don't see your code.

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: Trouble with MySQL+TOMCAT Resultset
It's not a secret anymore!