Disabling statement pooling

Disable statement pooling performing Data Definition Language (DDL) operations, which might not be compatible with statement pooling.

About this task

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.

Complete the following steps to use the administrative console to disable statement pooling. Statement pooling is disabled by specifying a value of zero for the statement cache size setting for your datasource.

Procedure

  1. From the administrative console, select Resources > JDBC > Data sources > datasource_name .
  2. Under Additional properties, click WebSphere Application Server data source properties.
  3. Enter a value of zero (0) in the Statement cache size field.
  4. Click OK, and then click Save.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 7:21:45 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-dist&topic=tdat_distatepool
File name: tdat_distatepool.html