RegisterStatementPoolMonitorMBean
- Last Updated: May 18, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
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.
Valid Values
true | false
Behavior
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.
Notes
Registering the MBean exports a reference to the Statement Pool Monitor. The exported reference can prevent garbage collection on connections if the connections are not properly closed. When garbage collection does not take place on these connections, out of memory errors can occur.
Default
false
Data Type
boolean
See also
- Using Statement Pooling
-
Refer to Statement Pool Monitor in the Progress DataDirect for JDBC Drivers Reference for further details.
- MaxPooledStatements