how to do batch insert/update with Springboot data JPA and Mysql

Question

I'm trying to implement batch insert/update records with SpringBoot Data Jpa with Mysql, here is my yml config:

spring.jpa.properties.hibernate.show_sql=true
spring.jpa.properties.hibernate.order_inserts=true
spring.jpa.properties.hibernate.order_updates=true
spring.jpa.properties.hibernate.jdbc.batch_size=500
spring.jpa.properties.hibernate.jdbc.batch_versioned_data=true
spring.jpa.properties.hibernate.generate_statistics=true

And I use an mysql auto increment column as primary key, here

public class Customer implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
}

I've googled that batch ops will not work with GenerationType.IDENTITY, but also I notice that mysql not support GenerationType.SEQUENCE then how could I accomplish bath insert/update with jpa's saveAll(data) method with mysql DB

Thank you

Jens Schauder · Accepted Answer · 2020-07-17 05:58:12Z

1

I've googled that batch ops will not work with GenerationType.IDENTITY, but also I notice that mysql not support GenerationType.SEQUENCE

Set the id in the application. For example using a UUID

answered Jul 17, 2020 at 5:58

Jens Schauder

82.7k35 gold badges199 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rellocs wood Over a year ago

for some reason I prefer using db auto increment primary key(GenerationType.IDENTITY) and not uuid . is any workaround ?

Collectives™ on Stack Overflow

how to do batch insert/update with Springboot data JPA and Mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related