[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

McKoi AutoCommit



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?