Re: Handling transactions with ingres

2011-05-25 Thread Lucas Holt
On May 25, 2011, at 3:46 PM, Andrus Adamchik wrote: > Know nothing about Ingres specifically, but when Cayenne runs a SQLTemplate > (either selecting or updating, doesn't matter), it calls > "Connection.commit()" on JDBC Connection object at the end of the operation. > > Andrus > Interestin

Re: Handling transactions with ingres

2011-05-25 Thread Andrus Adamchik
Know nothing about Ingres specifically, but when Cayenne runs a SQLTemplate (either selecting or updating, doesn't matter), it calls "Connection.commit()" on JDBC Connection object at the end of the operation. Andrus On May 25, 2011, at 12:54 PM, Lucas Holt wrote: > At work, I'm starting a new

Handling transactions with ingres

2011-05-25 Thread Lucas Holt
At work, I'm starting a new application with cayenne 3.0.1. We're using Ingres which has a read lock for tables during select queries. To make matters more complicated, I need to do inserts to a table that is temporary and not in the db. I've worked around that using a sqltemplate, but it wont a