Hi
I was trying to execute a bulk delete operation as below
Query q = em.createQuery("delete from simple s where s.date < :deldate");
This results in the following SQL being generated
DELETE FROM simple t0 WHERE (t0.s_date < ?)
but Informix does not support table aliases on delete statements.
After scratching around in the source i found a variable
public boolean allowsAliasInBulkClause = true;
which is set in org.apache.openjpa.DBDictionary
Could someone please confirm that all I have to do is set
allowsAliasInBulkClause = false; in the constructor of
org.apache.openjpa.jdbc.sql.InformixDictionary
Bruce
