Hello all,

i am having strange problem.

i wrote a trigger on a table which will be fired when some one inserts data on to that table.when i insert a row manually on that table in the db the trigger is getting fired and executing successfully.

so when i am trying to insert data from my application using entity manager.persist() ,i don't know what happens the row is not getting inserted in the table itself.it is showing the following exception...

[JDBCExceptionReporter] SQL Error: 0, SQLState: null
18:22:43,991 ERROR [JDBCExceptionReporter] The statement must be executed before any results can be obtained.
18:22:43,991 ERROR [STDERR] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not insert: [org.impact.entity.ListingDetail]


when i remove the trigger from the database and try to persist the data,the detials are succesfully persisted.

i am passing correct data from the application to the database.

so where i am going wrong.

i want that trigger to be fired when the entity manager persists the data.

Any help on this is greatly appreciated.

Worked on this issue further and figured out that hibernate fails if there is a stored procedure call in the trigger.

I replaced the stored procedure call with inline logic and it worked.