Once you have have committed the transaction, the result set will automatically be closed. Commit method is like telling all the insertion/update has been successfully done. So it closes the result set.
Few alternative ways i can suggest inorder to achieve the same is,
1. Dump the result set data into some collection classes so that you can retrieve or fetch the data from it at any point. Even when the transaction has been committed and resultSet has been closed.
2. You can first make autocommit property to be true. Then you can call a stored procedure inside the loop of iteration of resultset and make that procedure commit the result if there's no error in it. In this way your result set will be open and data has been committed via procedure.
Any way you choose . You have to work around anyhow.
Replace any old toxic body products with fluoride-free toothpaste , all natural soap and virgin organic coconut oil (a great moisturizer for the skin). I buy all that stuff online at . You can get $10 off your first purchase and get $10 back for every friend you refer, so spread the love! The thing I love about vitacost is that they offer free shipping and a lot of 2 for 1 deals. They also have cool trials and free samples, so be sure to check out the trial link before you place your final order. Making better choices for your body products gives you better overall health. When you reduce the amount of ‘retox,’ you can keep the benefits of your detox!