75 ways to demystify DB2: #7 : Tech Tip: How to disable multirowinsert support in DB2 JCC application?
Subbu Prabhu 060001JD9S Visits (7737)
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 Batc
To avoid the exception, JCC datasource property enab
The property can be set to false as below:
In application code: ((co
In application server datasource properties, set enab
you can set the JVM property: -Ddb
Thank you for reading!