JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

DriverManager object. For information about how to set properties, see How to Specify JDBC Type
4 Properties.
Data type: int
Units: number of data locators to be reserved
Default: 100
Range: 1 to 9,223,372,036,854,775,807 (2**63 -1)
Do not set a value much greater than the number of data locators actually needed. If the specified value is
0 (zero) or less, the default value (100) is used.
Base the setting of the value of the reserveDataLocators property on the application profile being
run. If the application inserts a large number of LOB items, a higher value of the
reserveDataLocators property can prevent frequent updating of the ZZ_DATA_LOCATOR value
in the LOB table. However, if the application inserts only a small number of LOB items, a smaller value
is better. If a large value is used, holes (unused data-locator numbers) could occur in the LOB table.
These holes represent unused space.
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