Configure these properties on the Caching tab:
Enable Cache-by-Name Access Select this option to allow retrieval of a database connection using the connection cache name instead of requiring a user name and password.
Cache-by-name access allows you to use caches in components without requiring access to the database password from the component source code.
Cache-by-name access is required for JDBC caches that are used in EJB or Web application resource references.
Enable Connection Sanity Check Specifies whether connections should be verified.
Components may release a connection that is not ready for use by another component. For example, there may be unretrieved results on the connection. When the option is enabled, EAServer verifies that the connection is open and accepts commands before making it available for reuse. Disabling the option increases performance, but may complicate debugging.
The default query for testing the connection is “select 1”. If this syntax is invalid for the database, you must configure a valid test query by setting the com.sybase.jaguar.conncache.check property on the Advanced tab. For more information, see com.sybase.jaguar.conncache.check.
Maximum Connections The maximum number of connections that can be allocated before the value of Wait for Connection determines whether to wait for a connection. The value of this property should be greater than or equal to the value of Maximum Connection Pool Size. A value of 0 indicates that new connections should be opened whenever they are required. Excess connections are deallocated and not returned to the cache.
Wait for Connection If the number of connections that have been allocated is equal to the value of Maximum Connections, specifies whether to wait for a connection.
Maximum Connection Pool Size The maximum number of connections in the pool.
After a connection is released, it is returned to the pool. The default value is 10. You can increase this number if performance suffers due to an insufficient number of available connections.
Minimum Connection Pool Size The minimum number of connections in the pool. EAServer preallocates and opens the specified number of connections at start-up time. The default is 0.
If no minimum size is specified, connections are opened to fill the pool up to the maximum size, on an as-needed basis.
Pooled Connection Idle Timeout Specifies the number of seconds an idle connection remains in the pool before it is dropped. The default is 300 seconds (5 minutes).
Pooled Connection Refresh Rate The refresh rate for the cache. The default is 600 seconds (10 minutes).
For information on tuning these settings, see “Tuning the cache size” in the EAServer Performance and Tuning Guide.
