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.

Gaurav Chikara
Ranch Hand

Joined: Jun 09, 2000
Posts: 410

posted Apr 17, 2007 18:05:00

0

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