learn java
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

Win a copy of The Software Craftsman this week in the Agile forum!
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(ResultSet.java:3601)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3614)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:3625)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:1772)
at org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:137)
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: 17260

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 - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Have you tried LearnNowOnline? http://www.learnnowonline.com/
subject: Trouble with MySQL+TOMCAT Resultset