openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Baptiste BRIAUD -- Novlog <>
Subject Re: JPA for portable database management (and wishes for JPA 3.0)
Date Sat, 05 Jun 2010 07:21:18 GMT
I know what do you mean but I really need to do that from Java like the =
DBA would do in your scenario.

I would love to do that using annotation with OpenJPA mappingtool.
In fact native query are not portable by nature and also, trigger is =
more static than dynamic like database schema is.
That's why annotation would be more convenient to define triggers in a =
portable manner it should be couple with query to specify what to do =
when trigger is fired.

Are you aware of a portable way to do that in raw Java before JPA =
integrate that cool idea to do it with mappingtool ?

On 4 juin 2010, at 13:27, No1UNo wrote:

> Security teams are, in my experience, much more comfortable with database triggers for
auditing purposes.  If you are writing records into a audit_log on each operation, this will
not interfere with JPA.  That you require it to be operational from any method of data access
would seem to confirm implementation on the DB side.
> Generally, I would expect the triggers to be installed and locked down from a secure
database account (i.e. not the one used by the JPA application).  As such, I would expect
the table creation and trigger installation to be performed by the DBA prior to executing
the JPA application.  In the unlikely event that it is acceptable to install the triggers
from the JPA side, you could do this using native queries.
> -=- Jerry

View raw message