Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exausted ResultSet

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 245
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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();
 
Sean MacLean
author
Ranch Hand
Posts: 621
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
Posts: 445
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic