Java Resultset exception

[vijay_nandanwar]

The process I am following are the following:
1. I am getting a ResultSet, which is a set of rows to be updated one by one.
2. So I put them in a while loop while(resultSet.next()) { ... }
3. Within the while loop, I need to update a value for which I need to do another search query (I need value from a previous row). This throws an exception.

Any solutions?

[DarrylBurke]

Moved from Advanced Java. A question asking the meaning of an unspecified Exception isn't advanced anyways.

What exception? From what code? Recommended reading: How to ask questions the smart way

db

[Tolls]

What exception?
We're not mind readers...

[vijay_nandanwar]

Sorry, my mistake. The question was about nested resultsets. I used the same Statement and ResultSet for both which led to this trouble. Also my first time using this site. I tried to remove this post, but could not. If anyone can help me remove the same, would be helpful.

I hope to be active on this forum though.

Thanks to all,

Vijay