JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

roundingMode
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.
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
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.
Data type: String
Default: none
For example, schema=sales
serverDataSource
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.
Type 4 Driver Property Descriptions 47