Resource manager properties represent global properties for all native connection libraries. The properties are stored in the database property files, located in EAServer’s /Repository/ResourceManager directory. The property names begin with com.sybase.jaguar.resourcemanager. Table B-17 lists the database property file names for each connection library type.
Connection library type |
Database property file |
|---|---|
Sybase Client Library 11.0 |
CTLIB_110.props |
Oracle OCI 7.x |
OCI_7.props |
Oracle OCI 8.x |
OCI_8.props |
Oracle OCI 9.x |
OCI_9.props |
Each property file is preconfigured with the connection library and XA-Library names for these operating systems: Solaris, Windows, HP-UX, AIX, and Linux. Table B-18 lists the values for Solaris and Windows.
Connection library type |
XA-Library for Solaris |
XA-Library for Windows |
Connection library for Solaris |
Connection library for Windows |
|---|---|---|---|---|
Sybase Client Library 11.0 |
libjxa.so |
libjxa.dll |
libjct_r.so |
libjct.dll |
Oracle OCI 7.x |
libclntsh.so |
xa73.dll |
libclntsh.so |
ociw32.dll |
Oracle OCI 8.x |
libclntsh.so |
oraclient8.dll |
libclntsh.so |
oci.dll |
Oracle OCI 9.x |
libclntsh.so |
oraclient9.dll |
libclntsh.so |
oci.dll |
In most cases, you should not need to modify the resource
manager properties.
However, to use a shared library or DLL other than the default, you must edit the database property file. For example, for XA resource connections using Oracle OCI 8.x, where 8.x is 8.1.5 or lower, set this property value in the Repository/ResourceManager/OCI_8.props file:
com.sybase.jaguar.resourcemanager.xalib = xa80.dll
Specifies the query to use when testing whether a connection is still usable.
The SQL query text. The default is:
select 1
The default does not work on all databases. For example, for an Oracle database, you must set this property to:
select 1 from dual
com.sybase.jaguar.resourcemanager.checkallowed
Specifies whether the cache manager should test connections before returning them to the cache.
true or false.
The default is true.
The query used to test the cache is specified by the com.sybase.jaguar.resourcemanager.check property.
Specifies the connection library used for this connection type.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies the connection library used for this connection type on AIX.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies the connection library used for this connection type on HP-UX.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies the connection library used for this connection type on Linux.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies the connection library (DLL) used for this connection type on Windows 2000 or Windows XP.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies the connection library used for this connection type on Solaris.
The syntax is the same as the DLL or Class Name field on the Driver tab in the Connection Cache Properties dialog box. See “Driver properties”.
Specifies an optional text description of the XA resource.
desc
Where desc is the descriptive text.
Specifies whether connections for this connection type are enabled.
true or false.
The default is true.
For debugging, you may want to set this property to false,
which disables all connections using this connection type. For example,
to disable all OCI_8 connection caches, set this property
to false in the OCI_8.props file.
Specifies the name of the connection type.
A text string that represents the library type. In each of these database property files, the names are:
Database property file |
Name |
To indicate |
|---|---|---|
CTLIB_110.props |
CTLIB_110 |
Sybase Open Client Client-Library connections |
OCI_7.props |
OCI_7 |
Connections using OCI 7.x |
OCI_8.props |
OCI_8 |
Connections using OCI 8.x |
OCI_9.props |
OCI_9 |
Connections using OCI 9.x |
Enables set-proxy support for connections to databases that support this feature.
true or false.
The default is false, which
disables set-proxy support.
Current versions of Adaptive Server Enterprise allow a user to assume the identity and privileges of another user. You can use this feature only with Sybase Open Client Client-Library connections, using this command:
set session authorization “login-name”
When proxy support is enabled, connections retrieved from the connection cache are set to act as a proxy for the user name associated with the EAServer client. To set proxy to another user name, use the Java JCMCache.getProxyConnection() method or the C JagCmGetProxyConnection() routine in your component.
Specifies the connection library type for this connection.
A text string that represents the library type. In each of these database property files, the types are:
Database property file |
Type |
|---|---|
CTLIB_110.props |
CTLIB_110 |
OCI_7.props |
OCI_7 |
OCI_8.props |
OCI_8 |
OCI_9.props |
OCI_9 |
Specifies whether this connection library type supports XA resource connections.
true or false.
The default is true for the
connection library types listed in Table B-17.
Specifies the XA-Library used for this connection.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
Specifies the XA-Library used for this connection type on AIX.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
Specifies the XA-Library used for this connection type on HP-UX.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
Specifies the XA-Library used for this connection type on Linux.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
Specifies the XA-Library (DLL) used for this connection type on Windows 2000 or Windows XP.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
Specifies the XA-Library used for this connection type on Solaris.
The syntax is the same as the Connection Library XA field on the Driver tab of the Connection Cache Properties dialog box. See Table 4-3.
