The following table summarizes statement pooling connection properties.

Table 1. Statement Pooling Properties
Property Characteristic
ImportStatementPool Specifies the path and file name of the file to be used to load the contents of the statement pool. When this property is specified, statements are imported into the statement pool from the specified file.
MaxPooledStatements The maximum number of pooled prepared statements for this connection. If set to 0 (the default), the driver's internal prepared statement pooling is not enabled. If set to a value greater than zero, the driver's internal prepared statement pooling is enabled. Enabling is useful when the driver is not running from within an application server or another application that provides its own prepared statement pooling. By default, the driver's statement pooling is not enabled.

See also

Refer to Statement Pool Monitor in the Progress DataDirect for JDBC Drivers Reference for further details.