Karthik Anantharaju (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=633ef75...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmYyMGM3MDJk...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-15583?atlOrigin=eyJpIjoiNmYyMG...
) HHH-15583 (
https://hibernate.atlassian.net/browse/HHH-15583?atlOrigin=eyJpIjoiNmYyMG...
) Trying to accomplish Insert bulk query with hibernate (
https://hibernate.atlassian.net/browse/HHH-15583?atlOrigin=eyJpIjoiNmYyMG...
)
Issue Type: Bug Assignee: Unassigned Created: 06/Oct/2022 10:51 AM Priority: Major
Reporter: Karthik Anantharaju (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=633ef75...
)
We are working on a spring boot api which uses hibernate to insert into database. We are
trying to insert multiple items in bulk to database as follows:
insert into table (col1, col2) values (x1, y1), (x2, y2), (x3, y3);
We tried using existing hibernate api parameters such as jdbc.batch_size , but it shows
individual insert statement to database in sql logs with show-sql: true as below.
insert into table (col1, col2) values (x1, y1);
insert into table (col1, col2) values (x2, y2);
Is there an hibernate api or configuration that we can use to achieve bulk insert as
below?
insert into table (col1, col2) values (x1, y1), (x2, y2), (x3, y3);
(
https://hibernate.atlassian.net/browse/HHH-15583#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-15583#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:b857cee )