use Perl

• AutoCommit (Score:1)

  by echo (2881) on 2003.11.24 9:03 (#26014)

  Apparently SQLite effectively does a commit on every statement when you have auto-commit on.
  
  Is there any other way it could behave with auto-commit on?

  Reply to This

  • Re:AutoCommit (Score:2)

    by jdavidb (1361)

    Yes. Autocommit describes the behavior the driver takes when an exit occurs without an explicit commit or rollback. Upon exit, the driver will commit if autocommit is true and rollback if autocommit is false. There's nothing in there that says it has to commit every SQL statement and indeed, if you'll try a simple experiment with DBD::Oracle, you'll see that with autocommit on it doesn't commit until you tell it to or exit.

    --
    J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
    • Re:AutoCommit (Score:2)

      by Matts (1087)

      You describe the behaviour for a "Databases in which a transaction is always active". Grep the DBI docs for that line for more details.
      
      SQLite is more of the category: "Databases in which a transaction must be explicitly started"
      
      It could have behaved more like Oracle, but I didn't know that was an option.