Disabling Pooling

To disable connection pooling, set the Pooling attribute to false. The default is true. You can enable or disable connection pooling in one of the following ways:

• Enter a Pooling value in the Edit Connection Pool Advanced Attributes page in the Administration Console. For more information, click the Help button in the Administration Console.

• Specify the ----pooling option in the asadmin create-jdbc-connection-pool command. For more information, see the Oracle GlassFish Server 3.0.1 Reference Manual.

• Specify the pooling option in the asadmin set command. For example:

  asadmin set domain1.resources.jdbc-connection-pool.DerbyPool.pooling=false

  For more information, see the Oracle GlassFish Server 3.0.1 Reference Manual.

The pooling option and the system property com.sun.enterprise.connectors.SwitchoffACCConnectionPooling, which turns off connection pooling in the Application Client Container, do not affect each other.

An exception is thrown if associate-with-thread is set to true and pooling is disabled. An exception is thrown if you attempt to flush a connection pool when pooling is disabled. A warning is logged if the following attributes are used, because they are useful only in a pooled environment:

• connection-validation

• validate-atmost-once-period

• match-connections

• max-connection-usage

• idle-timeout