Specify the use of batch writing to optimize transactions with multiple writes, by default batch writing is not used. Batch writing allows multiple heterogeneous dynamic SQL statements to be sent to the database as a single execution, or multiple homogeneous parameterized SQL statements to be executed as a single batch execution.

Note that not all JDBC drivers, or databases support batch writing.

JPA persistence property Usage:

properties.add(PersistenceUnitProperties.BATCH_WRITING, BatchWriting.JDBC);

Property values are case-insensitive

• JDBC - JDBC batch API's are used (dynamic, or parameterized).
• Bufferred - dynamic SQL is concatenated into a batch SQL string.
• Oracle-JDBC - Oracle JDBC batch API's are used (allows row count to be returned for optimistic locking).
• <custom-class> - A custom class that extends the BatchWritingMechanism class.