updates in sqlite3 do not work

John Machin sjmachin at lexicon.net
Tue May 29 20:28:59 EDT 2007


On May 30, 8:43 am, "Stefan Sonnenberg-Carstens"
<stefan.sonnenb... at pythonmeister.com> wrote:
> Did you try a commit() ?
>
> SQLite3 works in autocommit mode by default,

Errrrmmmm .... IF it worked in auto-commit mode, then the OP wouldn't
need to use Connection.commit(-:)

The underlying SLQite3 may work in auto-commit mode, but the Python
interface should not. See PEP 249 : """Note that if the database
supports an auto-commit feature, this must be initially off."""
Consequently the user of any/every DPAPIv2.0-compliant package should
be calling commit.

HTH,
John






More information about the Python-list mailing list