[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-1197) Support for HQL delete on MaxDB

Support for HQL delete on MaxDB ------------------------------- Key: HHH-1197 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1197 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.0.5 Environment: Hibernate 3.0.5, MaxDB 7.6, JBoss 4.0.1 Reporter: Randahl Fink Isaksen Assignee: Gavin King Priority: Minor Fix For: 3.1 When deleting an instance which has joined subclasses hibernate throws an exception if running on top of MaxDB claiming that the database dialect used does not support temporary tables. MaxDB does in fact support temporary tables - hibernate just does not know this - so I am requesting that Hibernate and/or the database dialect is improved so that these deletes are made possible. At the following address you will find a description of the SQL needed to create temporary tables with MaxDB http://dev.mysql.com/doc/maxdb/en/6d/117c14d14811d2a97400a0c9449261/conte... I am using MaxDB 7.6 and the SapDB dialect. (Might I also suggest that you rename the SapDB dialect to MaxDB since the database has been renamed?) I have taken the liberty of filing this as a critical bug as it means I cannot carry out certain deletions which are needed in my system. Below you will find the stack trace I encounter. Thank you for looking into this issue. Randahl Here is the stack trace thrown if you try deleting using MaxDB today: org.hibernate.HibernateException: cannot perform multi-table deletes using dialect not supporting temp tables at org.hibernate.hql.ast.exec.MultiTableDeleteExecutor.<init>(MultiTable DeleteExecutor.java:40) at org.hibernate.hql.ast.QueryTranslatorImpl.buildAppropriateStatementEx ecutor(QueryTranslatorImpl.java:423) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorIm pl.java:172) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl .java:103) at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.jav a:473) at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1060) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1041) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)