WAS v8.5 > Administer applications and their environment > Welcome to administering Data access resources > Administer data access applications > Configure a JDBC provider and data source > Configure a data sourceDisable statement pooling
Disable statement pooling when performing some Data Definition Language (DDL) operations, which might not be compatible with statement pooling. DDL operations, such as dropping and recreating tables, are not compatible with statement pooling when using the IBM Informix database. DDL operations invalidate the pooled statements or cause them to produce unexpected results. To use the dmgr console to disable statement pooling. Statement pooling is disabled by specifying a value of zero for the statement cache size setting for the datasource.
- From the dmgr console, select Resources > JDBC > Data sources > datasource_name.
- Under Additional properties, click WAS data source properties.
- Enter a value of zero (0) in the Statement cache size field.
- Click OK, and then click Save.
Related
Configure a data source
Reference:
Connection pool (Version 4) settings