RE: AutoCommit does not work



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
.



Relevant Pages

  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)
  • Re: Java and MySql program example ?
    ... > I am trying to learn Java and need an example program with MySql ... > MySql database. ... Database connection established ...
    (comp.lang.java.programmer)
  • Re: Creating Mysql DB with PHP
    ... >> userID and password for that MySQL server. ... > I am only going by what I have to do when setting up a new database. ...
    (alt.php)