Stores should handle wedged sql properly

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

Stores should handle wedged sql properly #16

Open mitalia opened 11 years ago

mitalia commented 11 years ago

In databases like postgres, transactions can get wedged and leave the user of the DSL with a connection in an unusable state. If this happens we need some mechanism to manually rollback the transaction easily with a dsl command.