> I'm new to OpenJPA and can't find anything about batch insert support. > > I know about the batchLimit option, but it only seems to batch several > insert operations and executes them together, but I'm actually looking for > a single SQL insert statement inserting multiple rows/entities into the > database. > > Can anyone provide some info about this?
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=20000" /> is what you want. It equivevalents to Statement.addBatch(); and Statement.executeBatch(); in JDBC. I.e. it applicable to PreparedStatements. -1 instead number gives us unlimited batch. -- WBR Turtle//BAZON Group
signature.asc
Description: This is a digitally signed message part.
