Message Title

Thomas B. created an issue

Issue Type:	Bug
Affects Versions:	6.1.7
Assignee:	Unassigned
Components:	hibernate-core
Created:	24/May/2023 01:04 AM
Environment:	Hibernate 6.1.7.Final Spring Boot 3.0.6
Priority:	Major
Reporter:	Thomas B.

Hibernate creates temporary tables for bulk operations.

We're using Oracle (v19.0.0.0.0) and our user won't have the privilege to create temporary table.

I've tried a lot of different configurations, but HTE_ tables are still created at startup :

                              09:07:43.658 INFO  [com.zaxxer.hikari.HikariDataSource      ] HikariPool-1 - Starting...
09:07:44.285 INFO  [com.zaxxer.hikari.pool.HikariPool       ] HikariPool-1 - Added connection oracle.jdbc.driver.T4CConnection@6dc5e857
09:07:44.286 INFO  [com.zaxxer.hikari.HikariDataSource      ] HikariPool-1 - Start completed.
09:07:44.596 INFO  [SQL dialect                             ] HHH000400: Using dialect: org.hibernate.dialect.Oracle12cDialect
Hibernate: create global temporary table HTE_xxxxx(...) on commit delete rows
Hibernate: create global temporary table HTE_yyyyy(...) on commit delete rows
09:07:45.551 INFO  [j.LocalContainerEntityManagerFactoryBean] Initialized JPA EntityManagerFactory for persistence unit 'default'
                              

Here is the properties I’ve tried :

                              spring.jpa.properties.hibernate.query.mutation_strategy=org.hibernate.query.sqm.mutation.internal.inline.InlineMutationStrategy

spring.jpa.properties.hibernate.hql.bulk_id_strategy.persistent.create_tables=false
spring.jpa.properties.hibernate.hql.bulk_id_strategy.persistent.drop_tables=false
spring.jpa.properties.hibernate.hql.bulk_id_strategy.global_temporary.create_tables=false
spring.jpa.properties.hibernate.hql.bulk_id_strategy.global_temporary.drop_tables=false
                              

I can’t find a spring.jpa.properties.hibernate.query.insert_strategy that is working because it gives me an exception :

                              Cannot instantiate the class [org.hibernate.query.sqm.mutation.internal.temptable.LocalTemporaryTableMutationStrategy] because it does not have a constructor that accepts a dialect or an empty constructor
                              

I didn’t find anything more to try, according to the documentation : https://docs.jboss.org/hibernate/orm/6.1/userguide/html_single/Hibernate_User_Guide.html#batch-bulk-hql-strategies-non-temporary-table

I also tried to find some help on StackOverflow, without succcess.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira