Neither JPA nor Hibernate do provide particular support for batch inserts and the idiom for batch inserts with JPA would be the same as with Hibernate: EntityManager em = …; EntityTransaction tx = em.getTransaction(); tx.begin(); for ( int i=0; i<100000; i++ ) { Customer customer = new Customer(…..); em.persist(customer); if ( i % 20 == … Read more
Here’s what I’ve come up with which appears to work well (but please comment if there’s a way to improve this): # build rows for each date and add to a list of rows we’ll use to insert as a batch rows = [] numberOfYears = endYear – startYear + 1 for i in range(numberOfYears): … Read more
You can create a batch by PreparedStatement#addBatch() and execute it by PreparedStatement#executeBatch(). Here’s a kickoff example: public void save(List<Entity> entities) throws SQLException { try ( Connection connection = database.getConnection(); PreparedStatement statement = connection.prepareStatement(SQL_INSERT); ) { int i = 0; for (Entity entity : entities) { statement.setString(1, entity.getSomeProperty()); // … statement.addBatch(); i++; if (i % 1000 … Read more