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 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 > allow me to use the commit keyword. > > Is there a way to force a commit in cayenne? Datacontext.commitchanges won't > work since no objects are modified in the cayenne context. > > Lucas Holt
