Appendix B Repository Properties Reference
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 15-4 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 15-5 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 do need to 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 1The 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 NT or Windows 2000.
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 would disable 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 15-4.
Specifies the XA-Library used for this connection.
The syntax is the same as the DLL or Class Name field on the Driver tab in the XA Resource Properties dialog box. See Table 4-5.
Specifies the XA-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 XA Resource Properties dialog box. See Table 4-5.
Specifies the XA-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 XA Resource Properties dialog box. See Table 4-5.
Specifies the XA-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 XA Resource Properties dialog box. See Table 4-5.
Specifies the XA-Library (DLL) used for this connection type on Windows NT or Windows 2000.
The syntax is the same as the DLL or Class Name field on the Driver tab in the XA Resource Properties dialog box. See Table 4-5.
Specifies the XA-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 XA Resource Properties dialog box. See Table 4-5.
| Copyright © 2002 Sybase, Inc. All rights reserved. |
| |