Why exhausted resultset

The code executed is as follows:. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on. The ResultSet set will be created and pointing to a row before the first result of the data. You can look it this way:. So, after openning your ResulSet, you execute the method next to move it to the first row.

If the set. And what if there is a new column inserted at position 1? Which code would you prefer? Or if the order of the columns is changed, which code version would you need to change at all? I figured it out Unfortunately, the server is not under my control so I will just have to deal with it.

Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy. Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Connect and share knowledge within a single location that is structured and easy to search.

I get the error java. The connection is via a connection pool defined in Websphere. The code executed is as follows:. If you reset the result set to the top, using rs. When there is no records returned from Database for a particular condition and When I tried to access the rs. This exception occurs when the ResultSet is used outside of the while loop.

Please keep all processing related to the ResultSet inside the While loop. This occurs typically when the stmt is reused butexpecting a different ResultSet, try creting a new stmt and executeQuery. It fixed it for me! Problem behind the error: If you are trying to access Oracle database you will not able to access inserted data until the transaction has been successful and to complete the transaction you have to fire a commit query after inserting the data into the table.

Because Oracle database is not on auto commit mode by default. Please make sur that res. You are getting this error because you are using the resultSet before the resultSet. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 2 months ago. Active 6 months ago. Viewed k times. The code executed is as follows: if rs!