JDBC Type 4 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

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_HALF_UP.
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_HALF_UP
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 the java.math.BigDecimal documentation
in http://download.oracle.com/javase/1.5.0/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_HALF_UP 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 is ROUND_HALF_UP.●