Two Laptop Bag
The moose likes JDBC and the fly likes result set exhausted Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "result set exhausted" Watch "result set exhausted" New topic
Author

result set exhausted

thri nath
Greenhorn

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: 1318

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.


Saifuddin..
[Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: result set exhausted
 
Similar Threads
Convert List to ResultSet?
how to know when server automatically invalidates session
RMI-JDBC
Result Set Sorting
Accessing Return Code Closes RecordSet?