skip to main content
Statement Pool Monitor : Enabling Statement Pooling
  
Enabling Statement Pooling
To enable statement pooling, set the driver MaxPooledStatements (or MaxStatements) connection property to a positive integer. For example, the following connection URL enables statement pooling for the SQL Server driver and sets the maximum number of pooled prepared statements for this connection to 20.
jdbc:datadirect:sqlserver://server1:1433;User=test;Password=secret;
MaxPooledStatements=20