1

Hibernate creates global temporary tables names staring with HT_ for bulk update and delete.

We are not supposed/allowed to create any table from application.

How do we switch off table global temporary creation for hibernate?

Neil Stockton
  • 11,383
  • 3
  • 34
  • 29
Mahesh Biradar
  • 351
  • 2
  • 9
  • 1
    Possible duplicate of [Hibernate HT\_ Temporary Tables ON JOINED inheritance, Migration from Hibernate 3.4.0.GA To 5.1](http://stackoverflow.com/questions/36172996/hibernate-ht-temporary-tables-on-joined-inheritance-migration-from-hibernate-3) – Thierry Jan 10 '17 at 10:04

1 Answers1

1

hibernate defined several options which you can choose depending on your database capabilities
1-InlineIdsInClauseBulkIdStrategy
2-InlineIdsSubSelectValueListBulkIdStrategy
3-InlineIdsOrClauseBulkIdStrategy
4-CteValuesListBulkIdStrategy

example to use these strategies

<property name="hibernate.hql.bulk_id_strategy"
          value="org.hibernate.hql.spi.id.inline.InlineIdsInClauseBulkIdStrategy"
/>

helpful link:
https://docs.jboss.org/hibernate/orm/5.4/userguide/html_single/Hibernate_User_Guide.html#batch

mohammad ehsan shishehbor
  • 11
  • 5
  • This is true for hibernate 5.2 onwards, but sadly this doesn't work with version 5.1, so you'll need to upgrade to a newer version. – JoanF Sep 18 '19 at 07:38