JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

LOB items, a higher value of the 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_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.
schema Property
The schema property sets the database schema that accesses SQL objects referenced in SQL statements if the SQL objects are not fully
qualified.
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: none
For example,
schema=sales
serverDataSource Property
The serverDataSource property sets the name of the data source on the MXCS server side (resides on the HP NonStop server).
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.
The
serverDataSource allows the application to set SQL/MX properties (such as resource governing) for server-side data sources. For more
information about server-side data sources, see "Server Data Sources" in the SQL/MX Connectivity Service Manual.
If not specified, the default server data source is used.
If the data source named in serverDataSource is not available on the MXCS server, the default server data source is used.
If the data source named in serverDataSource is not started on the MXCS server, an SQLException is thrown.
Data type: String
Default: None (This value is treated as the default server data source.)
For example, the MXCS server default
serverDataSource value is: