In Hibernate 4 bulk deletes on ID using HT_ tables fails on Oracle

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content