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
This archive was generated by hypermail 2.0.0 : Mon Jul 20 2009 - 00:07:16 EDT