aspose file tools*
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
Author

Exausted ResultSet

Anonymous
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
Author
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 =?");
s.setInt(employeeID);
ResultSet result = s.executeQuery();


chanoch<p><a href="http://www.amazon.com/exec/obidos/ASIN/1861007736/" target="_blank" rel="nofollow">Author of Professional Apache Tomcat</a></p>
Sean MacLean
author
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
"scsantos",
Thanks for participating here at the Ranch. However, the name you are using does not comply with our naming convention described at http://www.javaranch.com/name.jsp . Please log in with a new name, which meets these requirements.
You can change your name here.
Thanks.
Sean
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.
 
 
subject: Exausted ResultSet