SQLite error: transaction cannot be completed - SQL statements are executed using Java code

Question

I encountered a SQLite error, although I am not using explicit AutoCommit true or false. can anyone provide any data on this error. In what situation will you get this error.

Thanks in advance. Regards, Saving Manashi

Answer 1

I ran into a similar problem several times (in my case it was a rollback that was not possible) when I was inside a loop iterating over table entries. While the cursor is processing records, an SQL statement is executed. I don’t know exactly if this also prohibits commits, but it could be.

, , .

: "Autocommit" "True" SQLite (, , - Python apsw, ). , .

== > . , , - .