[hibernate-issues] [Hibernate-JIRA] Created: (HHH-4746) executeUpdate (Query object) on entity that have joined-subclass, perform an immediate commit (updates commits before calling transaction.commit() )

[Pierpaolo Moio (JIRA)]

executeUpdate (Query object) on entity that have joined-subclass, perform an immediate commit (updates commits before calling transaction.commit() )
----------------------------------------------------------------------------------------------------------------------------------------------------

                 Key: HHH-4746
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4746
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-hql
    Affects Versions: 3.3.2, 3.2.7, 3.2.3
         Environment: MySql 5.1, hibernate-3.3.2.GA (hibernate-core-3.2.3.ga, hibernate-3.2.7.ga)
            Reporter: Pierpaolo Moio
         Attachments: testCase.rar


I'm using the following statements:


*SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();*
*try {*
   *sessionFactory.getCurrentSession().beginTransaction();*
   *Query q = sessionFactory.getCurrentSession().createQuery("update SceneElement sceneElement set*
   *sceneElement.sequence=(-1)*sceneElement.sequence where sceneElement.scene.id=?").setParameter(0, 144);*
   *q.executeUpdate();*
   *if (true) throw new RuntimeException("I'm forcing exception: I want you rollback!");*
   *// unreacheable statement !!*
   *sessionFactory.getCurrentSession().getTransaction().commit();*
*}catch (Throwable e) {*
   *sessionFactory.getCurrentSession().getTransaction().rollback();*
   *e.printStackTrace();*
*} finally {*
    *sessionFactory.getCurrentSession().close();*
*}*


The Entity *SceneElement* contains two *joined-subclass*.

This is a snippet of hibernate sql output (hibernate use temporary table on mysql):

 *update scene_element set sequence=-1*sequence where ( id ) IN ( select id from HT_scene_element )*

This update *commit outside the transaction*, so I can't rollback in case of exception.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira