aspose file tools*
The moose likes JDBC and the fly likes ResultSet Exhausted Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSet Exhausted Error" Watch "ResultSet Exhausted Error" New topic
Author

ResultSet Exhausted Error

sovan chatt
Ranch Hand

Joined: Aug 09, 2010
Posts: 43
I have the following java class which is called from a servlet ...Whenever I try to retrieve the data using getString()method I get a resultset exhausted message...But when I replaced withit worked...I am totally confused...I am giving both the sevlet code and java class code here....

Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61066
    
  66

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Sandeep Sanaboyina
Ranch Hand

Joined: Dec 14, 2009
Posts: 72
If you are saying the issue is solved, just by replacing s1 with "700x900", the issue can't be with your code.
It could either be a data issue or that s1 does not have the correct value during execution. Better check your data.

Since you are already printing s1 before execution, I can only guess that there may be an extra space in the end.


They say you have to be the first, the best or different. I say, is it too much to ask for all three.
Sandeep Sanaboyina
Ranch Hand

Joined: Dec 14, 2009
Posts: 72
Also, is the below code supposed to be inside the while loop



If it is in the while loop, I don't think the s1 will have proper values everytime.
sovan chatt
Ranch Hand

Joined: Aug 09, 2010
Posts: 43
Also, is the below code supposed to be inside the while loop

If it is in the while loop, I don't think the s1 will have proper values everytime.

@Sandeep Sanaboyina Why do you think if s is inside while loop s1 wont get proper values...?And there is no extra space in values of s1...please reply..
 
Consider Paul's rocket mass heater.
 
subject: ResultSet Exhausted Error