The cache settings described in this section can not be set in the Adaptive Server plug-in. You must edit the underlying configuration file to change them. Use a text editor to edit the cache’s property file located in the $SYBASE/$SYBASE_EJB/Repository/ConnCache subdirectory. The file is CacheName.props, where CacheName represents the cache name as displayed in the Adaptive Server plug-in.
For a JDBC connection cache, these connection properties allow you to specify settings beyond those shown in the Connection Cache Properties dialog box. Different JDBC drivers recognize different sets of properties.
For the Sybase high-speed, shared-memory JDBC driver, define cache properties in this form:
jdbc:sybase:shm:null:0
Any property whose name does not begin with com.sybase.jaguar is passed
to the JDBC driver as a connection property. For example:
PACKETSIZE=2048
If a property setting conflicts with a setting in the Connection Cache Properties dialog box, the dialog box setting takes precedence.
Adaptive Server Enterprise allows a user to assume the identity and privileges of another user. This feature can be used with any database that recognizes the command:
set session authorization “login-name”
When proxy support is enabled, connections retrieved from the cache are set to act as a proxy for the username associated with the EJB Server client. To set-proxy to another user name, use the Java JCMCache.getProxyConnection() method in your component.
Set-proxy support must be enabled in the cache properties file before components can take advantage of it. To enable set-proxy support, add the following line to the cache properties file:
com.sybase.jaguar.conncache.ssa=true
To disable support, delete this line or change true to false.
