How to set default values or use triggers for a column?

From: Török Péte (torok..llround.net)
Date: Thu Feb 22 2007 - 11:43:16 EST

Next message: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"

Previous message: Andrus Adamchik: "Re: Using Cayenne as a JPA provider in a Web Server"
Next in thread: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"
Reply: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"
Reply: Mike Kienenberger: "Re: Must class qualifier be an entire field?"
Reply: Michael Gentry: "Re: Must class qualifier be an entire field?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I have an attribute in some of my tables which are supposed to store the date&time of the record's last modification. The idea (coming from our DB expert) is that we set the default value (SYSDATE) in the DB and update the value via a trigger whenever the record is modified. Is there a way to tell Cayenne to leave that column in peace?
I guess if I leave it out from the model completely, that would do... but then the DB schema and the Cayenne model would not be in sync :-(
Any hints?
Thanks in advance,
Péter

Next message: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"
Previous message: Andrus Adamchik: "Re: Using Cayenne as a JPA provider in a Web Server"
Next in thread: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"
Reply: Mike Kienenberger: "Re: How to set default values or use triggers for a column?"
Reply: Mike Kienenberger: "Re: Must class qualifier be an entire field?"
Reply: Michael Gentry: "Re: Must class qualifier be an entire field?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Feb 22 2007 - 11:43:52 EST