JDBC Type 4 Driver 1.1 Programmer's Reference

Also, the administrator should avoid setting high values for the reserveDataLocators
(for example in the range of trillions or so). Setting high values prevents other Type 4
applications that use LOB table from reserving data locators.
For additional information about data locator use, see Reserving Data Locators.
To change this value for a JDBC application, specify this property from the command line. For
example, the following command reserves 150 data locators for program class
myProgramClass.
java –Dt4sqlmx.reserveDataLocators=150 myProgramClass
roundingMode Property
The roundingMode property specifies the rounding behavior of the Type 4 driver. For
example, if the data is 1234.127 and column definition is numeric(6, 2) and the application does
setDouble() and getDouble(), the value returned is 1234.12, which is truncated as
specified by the default rounding mode, ROUND_DOWN.
Set this property on a DataSource object, ConnectionPoolDataSource object, or
DriverManager object. For information about how to set properties, see How to Specify
JDBC Type 4 Properties.
Data type: String
Default: ROUND_DOWN
Values for roundingMode are:
ROUND_CEILING
ROUND_DOWN
ROUND_FLOOR
ROUND_HALF_DOWN
ROUND_HALF_EVEN
ROUND_HALF_UP
ROUND_UNNECESSARY
ROUND_UP
For the definition of rounding mode values, see to the java.math.BigDecimal
documentation in http://java.sun.com/j2se/1.4.2/docs/api/index.html pages.
●
If the application sets erroneous values for the roundingMode property, no error is
thrown by the Type 4 driver. The driver uses ROUND_DOWN value instead.
●
To have the application get the DataTruncation exception when data is truncated, set the
roundingMode property to ROUND_UNNECESSARY.
●
The default rounding mode, ROUND_DOWN, is compatible with the JDBC/MX Type 2●