Search:

You are calling the next() method on a closed result set. Where does the code close the result set?
Make sure you don't call next() when the result set is closed.

If you need help with SQL try...

I can't edit your post so you will have to fix it. The ending code tag needs a / before code

Post the full text of the error message that shows where the error happens. You need to add calls to...

Please Edit your post and wrap your code with


<YOUR CODE HERE>

to get highlighting and preserve formatting.