[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-2919) HQL DELETE and map entity mode

HQL DELETE and map entity mode ------------------------------ Key: HHH-2919 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2919 Project: Hibernate3 Issue Type: Bug Components: caching (L2), core, query-hql Affects Versions: 3.2.5 Environment: org.hibernate.transaction.JDBCTransactionFactory as factory_class, postgresql 8.x with postgresql-8.1-407.jdbc3.jar JDBC driver, Linux 2.6.22-gentoo-r8 i686 Pentium III (Coppermine) Reporter: Cédric Chantepie Cache trouble when deleting object mapped in map mode (dynamic-map) with an HQL DELETE query, where as if deleted with session.delete(...) it works. In xxx.hbm.xml : <!-- Entity mapping --> <class entity-name="Test" table="test" lazy="false"> <composite-id> <key-property name="name" column="name" type="string" /> <key-property name="type" column="ptype" type="integer" /> </composite-id> <property name="value" column="value" type="string" /> </class> <!-- endOf Entity mapping --> JUnit test code : Map t = null; try { t = new HashMap(3); t.put("name", "Test1"); t.put("type", new Integer(2)); t.put("value", "---"); session.save("Test", t); } catch (Exception e) { fail(e.getMessage()); } try { t = (Map) session.get("Test", (Serializable) t); assertNotNull(t); } catch (Exception e) { fail(e.getMessage()); } try { Query q = session.createQuery("DELETE FROM Test t " + "WHERE t.name = :name"); q.setString("name", "Test1"); assertTrue(q.executeUpdate() == 1); //WORK:session.delete("Test", (Serializable) t); } catch (Exception e) { fail(e.getMessage()); } try { Map m = (Map) session.get("Test", (Serializable) t); assertNull(m); // fails here, find the deleted object, no ObjectDeletedException } catch (Exception e) { fail(e.getMessage()); } Maybe that due to composite-id and hashCode/equals support in map mode, maybe cache is not notified of objects deleted by HQL in this map mode.