* '''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)