skip to main content
Using the Driver : Using Connection Properties : Statement Pooling Properties
  

Try DataDirect Drivers Now

Statement Pooling Properties

The following table summarizes statement pooling connection properties.
Table 10. Statement Pooling Properties
Property
Characteristic
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.
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.
Registers the Statement Pool Monitor as a JMX MBean when statement pooling has been enabled with MaxPooledStatements. This allows you to manage statement pooling with standard JMX API calls and to use JMX-compliant tools, such as JConsole.
If set to true, the driver registers an MBean for the statement pool monitor for each statement pool. This gives applications access to the Statement Pool Monitor through JMX when statement pooling is enabled.
If set to false, the driver does not register an MBean for the statement pool monitor for any statement pool.

See also

*Connection Property Descriptions
*Statement Pool Monitor
*Performance Considerations