JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2 (H06.25+, J06.14+)

◦ “queryExecuteTime” (page 46)
◦ “reserveDataLocators” (page 47)
◦ “roundingMode” (page 47)
◦ “schema” (page 48)
◦ “serverDataSource” (page 48)
◦ “T4LogFile” (page 49)
◦ “T4LogLevel” (page 49)
◦ “T4QueryExecuteLogFile” (page 50)
◦ “translationVerification” (page 50)
◦ “url” (page 51)
◦ “useArrayBinding” (page 51)
◦ “useExternalTransaction” (page 52)
◦ “user” (page 52)
Overview of the Type 4 Driver Properties
“Client-Side Properties” (page 35)
“Server-Side Properties” (page 37)
Type 4 driver properties that effect client-side operations and server-side are summarized in the
following tables. For the detailed description, click the link provided in the property name.
NOTE: Unless otherwise noted in the brief description, the particular property applies to the
DataSource object, DriverManager object, and ConnectionPoolDataSource object.
Client-Side Properties
Table 3 Connection Control Properties
Default ValueDescriptionProperty Name
NoneSpecifies the registered DataSource or ConnectionPoolDataSource
name. (Can be set only on the DriverManager object.)
dataSourceName
60 (seconds)Sets the time limit that a connection can be attempted before the
connection disconnects.
loginTimeout
0 (No network timeout is
specified.)
Sets a time limit that the driver waits for a reply from the database
server.
networkTimeout
Table 4 Pooling Management Properties
Default ValueDescriptionProperty Name
-1 (Do not create an initial
connection pool.)
Sets the initial connection pool size when connection pooling
is used with the Type 4 driver . (Ignored for connections made
through the ConnectionPoolDataSource object.)
initialPoolSize
0 (Specifies no limit.)Set the number of seconds that a physical connection can
remain unused in the pool before the connection is closed.
maxIdleTime
Overview of the Type 4 Driver Properties 35