When deleting an instance which has joined subclasses hibernate throws an exception if running on top of
InformixDB claiming that the database dialect used does not support temporary tables.
InformixDB 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 InformixDB

I am using informix9 and the informixdb dialect.
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.
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)

Thank you for looking into this issue.
lixiaodi
email :lixiaodi@gmail.com