Good time.

I have some problems with using Pre*EventListener and SQLQuery.

Problem 1 :

If in the PreUpdateEventListener create insert into db usage SQLQuery, hibbernate generate exception.

Table nodeproperty_annotation_history don`t have mapping, and using only through JDBC(please see "Code")

1.1 Code

@Transactional
public Oblect createCommand(){

.....
hibernateSupport.saveOrUpdate(command);
.....

}


......

public boolean onPreUpdate(PreUpdateEvent p_event) {

String sql ="INSERT INTO nodeproperty_annotation_history( value, size, command_id) VALUES( 'testValue', 0, 0)";

SQLQuery query = hibernateSupport.getHibernateSession().createSQLQuery(sql);
query.executeUpdate();

return false;
}

1.2 Exception

exception: java.lang.IndexOutOfBoundsException: Index: 1, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.spinbitz.commons.utils.HibernateSupportImpl.find(HibernateSupportImpl.java:63)
at com.spinbitz.commons.utils.HibernateSupportImpl.findSingle(HibernateSupportImpl.java:70)

........


Problem 2.

After hibernate create this exception, hibernate rollback all objects, but all insert that created from SQLQuery does not delete.


I`m use
- himernate 3.2.6
- hibernate-annotation-3.3.1

Maybe who know, how fix this problem

Thank you!

I had the same issue as you mentioned.

I solved it by setting flush mode to MANUAL and resetting it back to the original at the end while executing a call to the stored procedure.

Here is code :





regards.