75 ways to demystify DB2: #7 : Tech Tip: How to disable multirowinsert support in DB2 JCC application?
Subbu Prabhu 060001JD9S Visits (7730)
In DB2 JDBC applications, when you execute INSERT or MERGE statements that use parameter markers in a batch, if the data server supports multi-row INSERT, the IBM Data Server Driver for JDBC and SQLJ can transform the batch INSERT or MERGE operations into multi-row INSERT statements by default. If INSERT FROM SELECT statements are executed in a batch, the driver will throw a BatchUpdateException , by default and its a restriction. To avoid the exception, JCC datasource property enableMultiRowInsertSupport must be set to false . The property can... [More]