Artem Harutyunyan wrote: > Hi, > > Consider, please, the following piece of code: [snip] > > It connects to the database, turns AutoCommit off, prepares the > statement, executes it, waits for 60 seconds and commits the > statement. > Although I do not get any errors, it does not work as I expect. The > problem is that I can see the new entry inside the table before > $dbh->commit() is called from the code. The same problem appears > also when $dbh->begin_work is used. > > The underlying database is mySQL version 5.0.24 and the version of > DBI is 1.50.
Are you using a table type in mysql that supports transactions? Philip
