Spring Boot和Spring Data JPA的批量插入不起作用 [英] Bulk insert with Spring Boot and Spring Data JPA not working

问题描述

我知道对此参数有很多类似的问题，但是我确实需要一个可行的解决方案。

I know that there are many similar questions about this argument, but I really need a working solution.

我正在尝试配置Spring Boot和Spring Data JPA为了批量批量插入。

I'm trying to configure Spring Boot and Spring Data JPA in order to make bulk insert in a batch.

目标是：提交每条N记录，而不是制作<$时的每条记录c $ c> repository.save（）操作。

The target is: commit each N-records, not every single record when making repository.save() action.

我从现在开始在应用程序中尝试过的内容。属性：

spring.jpa.properties.hibernate.jdbc.batch_size=100
spring.jpa.properties.hibernate.order_inserts=true
spring.jpa.properties.hibernate.order_updates=true
spring.jpa.properties.hibernate.generate_statistics=true

但没有成功。我已经监视了数据库，并且记录是一张一张地保存在表中，而不是像我配置的那样一张白一张地保存在100张中。

But with no success. I've monitored the database and records are persisted in tables one-by-one, not 100-by-100 like I've configured.

UPDATE

这里是实现：

@Component
public class BulkInsert {

    @Autowired
    MyRepository repository;

    public void process() {

        PodamFactory podamFactory = new PodamFactoryImpl();

        for(int i=0;i<10000;i++) {
            MyEntity myEntity = podamFactory.manufacturePojo(MyEntity.class);
            repository.save(myEntity);
        }

    }
}

实体：

@Entity
@Table(name="MYTABLE")
@NamedQuery(name="MyEntity.findAll", query="SELECT m FROM MyEntity m")
public class MyEntity implements Serializable {
    private static final long serialVersionUID = 1L;

    @Column(name="DESCRIPTION")
    private String description;

    @Id
    @Column(name="ID")
    private String id;

    public MyEntity() {
    }

    // getters and setters

}

存储库：

public interface MyRepository extends CrudRepository<MyEntity, String> {

}

推荐答案

尝试像这样更改代码：

public void process() {

    PodamFactory podamFactory = new PodamFactoryImpl();
    List<MyEntity> myEntities = new ArrayList<>(10000);

    for(int i = 0; i < 10000; i++) {
        myEntities.add(podamFactory.manufacturePojo(MyEntity.class));
    }

    repository.save(myEntities); // for Spring Boot prior 2.0
    // repository.saveAll(myEntities); - for Spring Boot since 2.0
}

P.S。不要忘记打开 spring.jpa.show-sql 来查看结果

P.S. don't forget to turn on spring.jpa.show-sql to see result

UPDATE

也请检查我有关批量插入的另一个答案：
如何用JpaRepository批量插入（多行）？

Please also check my another answer about bulk insert: How to do bulk (multi row) inserts with JpaRepository?

这篇关于Spring Boot和Spring Data JPA的批量插入不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！