SQLite Backend - Fails on multiple commits

chop-dbhi / dataexpress

[NOT MAINTAINED] DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite

http://dataexpress.research.chop.edu

BSD 2-Clause "Simplified" License

72 stars 9 forks source link

SQLite Backend - Fails on multiple commits #6

Open masinoa opened 12 years ago

masinoa commented 12 years ago

SQLite backend does not allow multiple commits. Not sure why.

mitalia commented 11 years ago

This is a symptom of a wider issue where we are a bit too fast and loose with commit. This doc gives an overview of the JDBC transaction semantics. It's likely we should push autocommit(false) further down the stack and only enable/disable during execution of combined SQL statements.