
8 Dec
2008
8 Dec
'08
11:55 a.m.
Hi! 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. Greetings!