Re: difficult object relational mapping
Joshua Paine <[email protected]> Wed, 05 Mar 2008 13:23:43 -0500
| Newsgroups | gmane.comp.java.helma.general |
|---|---|
| Message-ID | <[email protected]> |
Anton, AFAIK, this isn't possible with Helma's ORM. Either add another column to your entries table with the most recent update date (a small denormalization that you might well end up making anyway for performance reasons) or create and use a view that simulates a table like the above with all the necessary triggers to make Helma's belief that it's a genuine table not lead to disaster. If you go the first route and add a column, you could keep it updated either with a trigger pretty easily, I'd think. And you can mark it read-only for Helma to ensure nothing tries to set it directly. -Joshua