• Create Database with triggers. Solving the colon problem in hibernate.

In order to create a database with triggers I made some simple java object (see attachment).

The problem was when I try to execute a pl/sql procedure hibernate thinks the colon ':' represents a parameter of the query.

To solve this I requested a JDBC connection and executed the procedure at JDBC level.

The problem with colon is describe in:

 http://opensource.atlassian.com/projects/hibernate/browse/HHH-1237

• Lifewise datamodel design (see attachement)