In Hibernate 4 bulk deletes on ID using HT_ tables fails on Oracle
Issue
- Hibernate throws the following because it needs temporary tables to perform bulk operations and those tables were not created before by ORA-02089. Hibernate tries create them but it can't complete this task:
DEBUG [org.hibernate.hql.internal.ast.exec.AbstractStatementExecutor] (http-iptv-redhat-10.121.130.37-38082-2) unable to create temporary id table [ORA-02089: COMMIT is not allowed in a subordinate session
]
...
[org.hibernate.exception.SQLGrammarException: ORA-00942: table or view does not exist"
- Entities using inheritance needs ht tables to perform bulk operations which are not supported in oracle xa drivers (do not support DDL operations like "create" in already bounded sessions
Environment
- JBoss Enterprise Application Platform (EAP) 6.0
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.