Is it possible to impl database 'trigger' in java code? (hibernate + jpa + spring + mysql)

Question

I am using mysql 5.5 DB, hibernate.4.0 as jpa provider to spring 3.0.5.

I have a user table and privilege table in my DB. Also I have some triggers in my DB. Those trigger implements some of our application's business logic.

For example, user john insert a record into table table_foo via my web application.

The trigger BeforeInsertTableFoo will check the user's privilege. If user doesn't have the privilege, trigger will abort this operation.
Also, if the operation is permitted, another trigger AfterInsertTableFoo will update some records in Table table_bar.

Is there any way that I can implement this logic as 'trigger' in java code? It seems like Jpa Event Listener and Hibernate Event can only do something like trigger but only in one table.

Surely I can use a java class to do the same thing. But I can't make sure that all the other developer, even myself, will use the correct java class to do db insertion or update, when the amount of business rules increased.

Thx in advance. andrew

hey, have you got any solution?

Scarlett
– Scarlett

2012-04-11 08:30:08 +00:00
Commented Apr 11, 2012 at 8:30 — Scarlett
– Scarlett, Commented Apr 11, 2012 at 8:30

Alex Vaz · Accepted Answer · 2012-06-11 23:48:11Z

2

Check the JPA's listener more carefully. You can make one listener for many entities / tables.

Just set a listener class like this:

public class MyListener {
@PrePersist void onPrePersist(Object entity ) {}
@PostPersist void onPostPersist(Object entity) {}
@PostLoad void onPostLoad(Object entity) {}
@PreUpdate void onPreUpdate(Object entity) {}
@PostUpdate void onPostUpdate(Object entity) {}
@PreRemove void onPreRemove(Object entity) {}
@PostRemove void onPostRemove(Object entity) {}

}

And then, for all the entities for which you want a call back or "trigger" ...

@Entity @EntityListeners(MyListener.class)
   public class Customer {
    }

I hope this helps.

-Alex

answered Jun 11, 2012 at 23:48

Alex Vaz

5165 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yzandrew Over a year ago

Thx Alex. Your answer can help me to implement trigger like action inside one table. But I need to have this done across tables.

Alex Vaz Over a year ago

Ok, maybe I dont understand. I mean you can make one listener class and pass it to ALL entities, them do generic logic or do if( instanceof .. for specific logic, right ?

yzandrew · Accepted Answer · 2012-09-26 00:06:57Z

0

I found some links on google, which talks about Spring managed event listeners with JPA

answered Sep 26, 2012 at 0:06

yzandrew

7851 gold badge11 silver badges25 bronze badges

Collectives™ on Stack Overflow

Is it possible to impl database 'trigger' in java code? (hibernate + jpa + spring + mysql)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related