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