wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes result set exhausted Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "result set exhausted" Watch "result set exhausted" New topic

result set exhausted

thri nath

Joined: Mar 13, 2007
Posts: 4
i am getting and error as result set exhausted.in tomcat webserver and one thing i didn't close anyone like con.closeor resultset.close
Subhadip Chatterjee
Ranch Hand

Joined: Dec 12, 2006
Posts: 93
Hi Nath,
what i can infer from this, is your resultset has got no records in it, and you are trying to do resultset.next() & the trying to access the field values. Check your resultset & probably SQL query. whether it's actually giving you back some records!!!

Refreshing life every moment...
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

Well, i can't really get what you are trying to do.
Can you make it simpler with details.

or it's better to comeup with you code, exception or error in order to help you.

[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: result set exhausted
It's not a secret anymore!