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
Hi there,
I'm going with the '#set($hash = '#') ${hash}' solution that avoids
cayenne's parsing and works like a charm. Thank you all for your
suggestions, you've been very helpful as always !
Laurent.
Le 05/18/2011 07:00 PM, Andrus Adamchik a écrit :
Not commenting on the overall solut
Hi Tony,
Calling:
event.removeFromEventmenuArray(obj); context.commitChanges();
unlinks the record (which you are seeing with the null FK), but does
not delete it (after all, you may be adding the object to a different
relationship).
Try doing a context.deleteObject(obj) before committing.
What you are doing only alters a relationship.
You want to use this:
http://cayenne.apache.org/doc/api/org/apache/cayenne/ObjectContext.html#deleteObject%28java.lang.Object%29
On Wed, May 25, 2011 at 3:54 PM, Tony Dahbura wrote:
> I have an object called event that contains eventMenu as an ar
I have an object called event that contains eventMenu as an array of objects.
event is a table in my database and eventMenu is a table. Each of the objects
are working fine for inserts and queries...
However if I want to delete an eventitem I tried calling
event.removeFromEventmenuArray(obj).
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
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
Thanks - I will stick with SQLTemplate/IndirectQuery then
Cheers
Christian
On Tue, May 24, 2011 at 3:06 PM, Andrus Adamchik wrote:
> EJBQLQuery supports those.
>
> On May 24, 2011, at 5:53 AM, Christian Grobmeier wrote:
>
>> Hey all,
>>
>> how do I do create "group by" or "sum" queries with Caye
