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

Exausted ResultSet

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
I have an application web in development using JSP + Servlets in a Resin 2.1.4 integrated with the Apache 1.3.26 + J2SDK 1.4, everything turning on SuSE Linux 7.2. The application accesses a database Oracle 9i remote R1 and sometimes during the execution of some heavier routines I obtain the error message
of Exausted ResultSet. What can cause this? Which the solution for the problem?
I thank for the help
chanoch wiggers
Ranch Hand

Joined: May 24, 2001
Posts: 245
this seems to be an oracle specific problem try. You are probably doing something like:
ResultSet result = select.executeQuery(
"select * from employee where id = 'employeeID' ");
try this
ResultSet result = select.executeQuery("select * from employee where id = '"+employeeID+"' ");
or (my preference) a PreparedStatement:
PreparedStatement s = select.prepareStatement("select * from employee where id =?");
ResultSet result = s.executeQuery();

chanoch<p><a href="" target="_blank" rel="nofollow">Author of Professional Apache Tomcat</a></p>
Sean MacLean
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at . Please log in with a new name, which meets these requirements.
You can change your name here.
Vedhas Pitkar
Ranch Hand

Joined: Jan 27, 2001
Posts: 445
Hi! I think that this exception usually occurs when u have taken the values from a ResultSet & try to do it again.Check how u r reteiving the values from the ResultSet.
I agree. Here's the link:
subject: Exausted ResultSet
jQuery in Action, 3rd edition