BatchPerformanceWorkaround
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
The driver uses the native DB2 batch mechanism. This property determines whether restrictions are enforced to facilitate data conversions.
Valid Values
true | false
Behavior
If set to true, restrictions are removed; however, parameter sets may not
be executed in the order that they were specified.
If set to false, the methods that are used to set the parameter values of
a batch operation that is performed using a PreparedStatement must match the database data
type of the column with which the parameter is associated. This is because DB2 servers do
not perform implicit data conversions.
Default
false
Data Type
boolean