Re: JDBC Rollbacks and Exceptions

2015-11-13 Thread Sean Corfield
Andy Chambers wrote on Thursday, November 12, 2015 at 10:49 PM: I threw up an example repo demonstrating the type of test I'd like to be able to write somehow. Maybe I'm just trying to test something that should be tested in other ways. https://github.com/cddr/jdbc-demo As Andrey indicates, what

Re: JDBC Rollbacks and Exceptions

2015-11-12 Thread Andrey Antukh
If I understand it properly, this is a expected behavior in most databases. The common way for solve this, is wrapping the expected to fail code in a sub-transaction (or savepoint in database words). If that code fails, the sub-transaction will be aborted, but the main transaction will continue to

Re: JDBC Rollbacks and Exceptions

2015-11-12 Thread Andy Chambers
On Friday, October 30, 2015 at 5:22:40 PM UTC-7, Sean Corfield wrote: > > Could you provide a bit more context? > > We’re using clojure.java.jdbc very heavily in production and we don’t see > any problems with exceptions. > Hi Sean, I threw up an example repo demonstrating the type of test I'd l

Re: JDBC Rollbacks and Exceptions

2015-10-30 Thread Sean Corfield
Could you provide a bit more context? We’re using clojure.java.jdbc very heavily in production and we don’t see any problems with exceptions. Sean Andy Chambers wrote on Friday, October 30, 2015 at 3:52 PM: Has anyone found a way to "reset" a connection after a rollback? It seems like after an

JDBC Rollbacks and Exceptions

2015-10-30 Thread Andy Chambers
Hey All, Has anyone found a way to "reset" a connection after a rollback? It seems like after an exception is triggered, the connection cannot be used again, even if you just want to rollback and continue with the next insert. This is a problem if you want to both clean the database state by r