Select the Advanced tab on the Connection Cache Properties window to set the cache options described in Table 10-4
Property |
Description |
Comments/Example |
|---|---|---|
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. |
By default, a cache cannot be retrieved by its name. You must be logged in as sa to update the cache’s properties to allow the cache to be retrieved by name. Cache-by-name is less secure than requiring a user name and password. |
Enable connection sanity check |
Whether connections should be verified before releasing them into the cache. |
Components may release a connection that is not ready for use by another component. For example, there may be unretrieved results on the connection. Enabling this option causes EJB Server to test whether the connection is usable before replacing it in the cache. Disabling the option increases performance, but may complicate debugging. |
Number of Connections in Cache |
The 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. |
Service Name |
The name of the Adaptive Server to which the Sybase shared-memory JDBC driver connects. |
Service name is ignored for caches that use JDBC drivers other than jConnect.™ |
