We get exhausted resultset when resultset contents are not current and/or resultset contains stale data We need to explicitly commit the transaction for batch updates
SCJP,SCWCD,SCBCD<br />If Opportunity doesn't knock then build the door
Joined: Oct 17, 2005
But when i am executing batch updates then even if i have not said commit() it is committing the changes to DB(Oracle) even if the setAutoCommit() is set to false.
I didnt get this how this is happening?
Thanks once again.
Joined: Jun 09, 2000
Idieally it doesn insert into dabase but doesn't commit.In other words If we run query on database we can see records but if we try to execute query from program we won't see them. (Dirty read) Please recheck this scenario
And use executeBatch rather than execute method as execute method some hoe opens the resultset and we get some weied erros like too many open cursors or exhausted resultset etc etc [ April 17, 2007: Message edited by: Gaurav Chikara ]
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com