[Haskell-beginners] HDBC commit problem

Moritz Tacke moritz.tacke at gmail.com
Mon Dec 8 11:55:56 EST 2008


I am running into problems while using HDBC with the sqlite3 backend.
The HDBC "commit" statement frequently results in exceptions with the
sqlite3 errorcode 1, "SQL logic error or no database". As far as I
know, and as far as the HDBC docs tell me, "commit" simply writes all
yet open transactions onto the disk. How can it fail? The HDBC
documetation mentions the prepare- and execute-steps as the ones which
might throw exceptions - what are the problems a call to "commit"
might encounter? I do not suspect SQL errors to be the cause - those
should lead to earlier exceptions - and the database is definitly
present and opened, as select calls following the failing commit
statments succeed.

More information about the Beginners mailing list