The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: Exhausted Resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: Exhausted Resultset" Watch "java.sql.SQLException: Exhausted Resultset" New topic

java.sql.SQLException: Exhausted Resultset

Jinal Jhaveri

Joined: Aug 12, 2004
Posts: 4

When I try to stress test my servlet with lots of request (clicks), I get the java.sql.SQLException: Exhausted Resultset exception. Anyways to solve this problem?
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 672
You can check if your ResultSet, Statement are closed correctly.

We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design

Crazy Bikes created by m-Power
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

Unless this is a servlet design issue, it sounds more of a JDBC problem, so I'll move the thread there. You may want to post some sample code.
I agree. Here's the link:
subject: java.sql.SQLException: Exhausted Resultset
It's not a secret anymore!