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