On 20/07/09 5:18 AM, Karen Harper wrote:
I want to monitor for ADD, DELETE, and MODIFY events in a specific table in my database which will be driven by another application. I have not come up with a straightforward way to do this through searching the docs. Is there a way to set TRIGGERS in the database through Cayenne, for example? Is there some other mechanism that I haven't found?
You are probably better off asking on MySQL forums since Cayenne will have no way to catch database events that don't happen through Cayenne. You might like to read about MySQL triggers [1] although I've never used them myself. You will have to set them directly in the database and not through Cayenne.
Ari Maniatis [1] http://dev.mysql.com/doc/refman/5.0/en/triggers.html -- --------------------------> ish http://www.ish.com.au Level 1, 30 Wilson Street Newtown 2042 Australia phone +61 2 9550 5001 fax +61 2 9550 4001 GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
