JDBC Type 4 Driver Programmer's Reference

connections by physically closing them—not by adding them to the free pool.
0 means the connections are not physically closed; the connections are always added to the free pool when the connection is
closed.
●
maxPoolSize Property
Sets the maximum number of physical connections that the pool can contain. These connections include both free connections and
connections in use. When the maximum number of physical connections is reached, the Type 4 driver throws an SQLException with
the message, "Maximum pool size is reached." Specify the maxPoolSize property as:
int
The integer can be -1, 0 through 2147483647, but greater than minPoolSize. The default is 0. Any negative value is treated like -1.
Any positive value less than minPoolSize is changed to the minPoolSize value. The value determines connection pool use as
follows:
0 means no maximum pool size.●
-1 for the basic DataSource object means connection pooling is disabled. -1 is invalid for the
ConnectionPoolDatasource object.
●
T4LogLevel
Sets the logging levels that control logging output for the Type 4 driver. The Java package java.util.logging is used for logging error
messages and trace messages in the driver.
To enable tracing, use the t4sqlmx.T4LogLevel property specified in the command line:
-Dt4sqlmx.T4LogLevel=log_level_string
T4LogLevel Considerations
If a security manager is defined by your application using an AppServer, LoggingPermission must be must be granted in the
java.policy file as follows:
permission java.util.logging.LoggingPermission "control","";
●
The Type 4 driver is not designed to inherit the java.util.logging.FileHandler.level settings at program startup.●
Logging Levels
If the property value is not set, the default for T4LogLevel is java.util.logging.Level.OFF. Allowed logging levels are:
SEVERE (highest value; logs the fewest messages)●
WARNING●
INFO●
CONFIG●
FINE●
FINER●
FINEST (lowest value)●
OFF (logging is turned off; default setting)●
ALL (log all messages)●
Server-side tracing and logging through MXCS is managed by NSM/web. For more information about server side-tracing (logging), see
the NSM/web online help.
T4LogFile
Sets the name of the logging file for the Type 4 driver.
To set the logging file name, use the t4sqlmx.T4LogFile property specified in the command line:
-Dt4sqlmx.T4LogFile=t4log_file_name