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

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1197?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-1197.
-------------------------------


Closing stale resolved issues

> 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/content.htm
> 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)

-- 
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