Hibernate子表行批量插入失效求助（100行仅插入6行）

Hey there, let's dig into why your Hibernate batch insert is only persisting 6 out of 100 trial balance rows, especially with the bidirectional associations and REST API setup you mentioned. Here are the most likely fixes to get your batch insert working as expected:

1. Verify Hibernate Batch Configuration #

First, make sure your Hibernate properties are properly set up to enable batch processing—this is a super common pitfall:

• Set hibernate.jdbc.batch_size to a reasonable value (e.g., 20 or 50) in your configuration file:

  hibernate.jdbc.batch_size=20
  hibernate.order_inserts=true
  hibernate.order_updates=true
  

• Avoid GenerationType.IDENTITY for primary keys: This generator forces Hibernate to execute each insert immediately to retrieve the auto-generated ID, which completely disables batch processing. Switch to SEQUENCE or TABLE instead:

  @Id
  @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "trial_balance_seq")
  @SequenceGenerator(name = "trial_balance_seq", sequenceName = "trial_balance_sequence", allocationSize = 20)
  private Long id;
  

2. Fix Bidirectional Association Maintenance #

Since you're using bidirectional associations with JSON managed references, you need to ensure both sides of the relationship are properly synchronized—Hibernate won't persist child entities if their parent reference is missing:

• Add a helper method in your parent entity (e.g., TrialBalance) to automatically set the child's parent reference:

  public class TrialBalance {
      // ... other fields
      @OneToMany(mappedBy = "trialBalance", cascade = CascadeType.PERSIST)
      @JsonManagedReference
      private List<TrialBalanceRow> rows = new ArrayList<>();
  
      public void addRow(TrialBalanceRow row) {
          rows.add(row);
          row.setTrialBalance(this); // Critical: Maintain the reverse association
      }
  }
  

• When processing the REST request, use this helper method instead of directly adding rows to the list:

  TrialBalance trialBalance = new TrialBalance();
  // Populate other trial balance fields
  for (TrialBalanceRow row : request.getTrialBalanceRows()) {
      trialBalance.addRow(row); // Ensures bidirectional link is set
  }
  

3. Optimize Session Management #

Hibernate's Session caches entities, and if you don't flush/clear it periodically, batch processing can break due to excessive memory usage or cached state issues:

• In your service layer, flush and clear the Session after every batch_size inserts:

  @Transactional
  public void saveTrialBalanceRows(List<TrialBalanceRow> rows) {
      int batchSize = 20;
      for (int i = 0; i < rows.size(); i++) {
          entityManager.persist(rows.get(i));
          if (i % batchSize == 0 && i > 0) {
              entityManager.flush();
              entityManager.clear();
          }
      }
      // Flush remaining rows
      entityManager.flush();
  }
  

• Ensure the entire batch operation runs within a single transaction (use @Transactional on your service method to handle this automatically in Spring).

4. Check JSON Deserialization Issues #

@JsonManagedReference and @JsonBackReference can sometimes leave reverse associations unset during deserialization. To fix this:

• After deserializing the JSON payload in your REST controller, explicitly set the parent reference for each child row (using the helper method we created earlier) before persisting.
• Avoid sending circular references in your JSON payload—if needed, use @JsonIgnore on one side instead, but ensure you still maintain the association programmatically.

5. Debug with Hibernate SQL Logs #

Enable SQL logging to confirm if batch inserts are actually being executed:

• Add these logging properties to your configuration:

  logging.level.org.hibernate.SQL=DEBUG
  logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE
  

• Check the logs—you should see a single INSERT statement with multiple value sets (e.g., INSERT INTO trial_balance_rows (...) VALUES (?, ?, ...), (?, ?, ...)) instead of 100 separate INSERT statements. If you see single inserts, your batch configuration is not working.

By addressing these areas, you should be able to get all 100 trial balance rows inserted successfully.

内容的提问来源于stack exchange，提问作者Bhavna Jhunjhunwala