Re: McKoi AutoCommit

[Tobias Downer <toby@xxxxxxxxx>]

Justin,

This should work as you expect.  When you 'commit()' after you have 
'setAutoCommit(false)' then any changes made on the connection will be 
visible to other connections and survive after the database is shut 
down.  Check the log and see if there are any errors when you commit. 
Also, make sure you 'commit' on the same connection that you have made 
the changes on.

Toby.

Justin Cobb wrote:

> I am having a problem with the auto commit feature on a database
> connection. Initially I use setAutoCommit(true). When I come to a large
> insert I setAutoCommit(false) and then try to manually commit the
> changes with connection.commit(). The problem is when I try to do a
> commit the changes are never committed into the database. Next time I
> start up the database the new data does not exist. Is my thinking behind
> this right? I also tried just setting autoCommit to false from the
> beginning and committing all changes that I made using the commit()
> function. Not having any luck with that either. Is there something else
> I need to do to get the data committed?
>