Resource environment reference properties  Resource reference properties

Appendix B: Repository Properties Reference

Resource manager properties

Description

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.

Table B-17: Database property files

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.

Table B-18: XA resource libraries and property files

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

NoteIn 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

See also

Chapter 4, “Database Access”




com.sybase.jaguar.resourcemanager.check

Description

Specifies the query to use when testing whether a connection is still usable.

Syntax

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

See also

com.sybase.jaguar.resourcemanager.checkallowed




com.sybase.jaguar.resourcemanager.checkallowed

Description

Specifies whether the cache manager should test connections before returning them to the cache.

Syntax

true or false. The default is true.

Usage

The query used to test the cache is specified by the com.sybase.jaguar.resourcemanager.check property.




com.sybase.jaguar.resourcemanager.conlib

Description

Specifies the connection library used for this connection type.

Syntax

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”.




com.sybase.jaguar.resourcemanager.conlib.aix

Description

Specifies the connection library used for this connection type on AIX.

Syntax

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”.




com.sybase.jaguar.resourcemanager.conlib.hpux

Description

Specifies the connection library used for this connection type on HP-UX.

Syntax

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”.




com.sybase.jaguar.resourcemanager.conlib.linux

Description

Specifies the connection library used for this connection type on Linux.

Syntax

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”.




com.sybase.jaguar.resourcemanager.conlib.nt

Description

Specifies the connection library (DLL) used for this connection type on Windows 2000 or Windows XP.

Syntax

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”.




com.sybase.jaguar.resourcemanager.conlib.solaris

Description

Specifies the connection library used for this connection type on Solaris.

Syntax

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”.




com.sybase.jaguar.resourcemanager.description

Description

Specifies an optional text description of the XA resource.

Syntax

desc

Where desc is the descriptive text.




com.sybase.jaguar.resourcemanager.enabled

Description

Specifies whether connections for this connection type are enabled.

Syntax

true or false. The default is true.

Usage

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.




com.sybase.jaguar.resourcemanager.name

Description

Specifies the name of the connection type.

Syntax

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




com.sybase.jaguar.resourcemanager.ssa

Description

Enables set-proxy support for connections to databases that support this feature.

Syntax

true or false. The default is false, which disables set-proxy support.

Usage

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.




com.sybase.jaguar.resourcemanager.type

Description

Specifies the connection library type for this connection.

Syntax

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




com.sybase.jaguar.resourcemanager.xacompliant

Description

Specifies whether this connection library type supports XA resource connections.

Syntax

true or false. The default is true for the connection library types listed in Table B-17.




com.sybase.jaguar.resourcemanager.xalib

Description

Specifies the XA-Library used for this connection.

Syntax

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.




com.sybase.jaguar.resourcemanager.xalib.aix

Description

Specifies the XA-Library used for this connection type on AIX.

Syntax

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.




com.sybase.jaguar.resourcemanager.xalib.hpux

Description

Specifies the XA-Library used for this connection type on HP-UX.

Syntax

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.




com.sybase.jaguar.resourcemanager.xalib.linux

Description

Specifies the XA-Library used for this connection type on Linux.

Syntax

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.




com.sybase.jaguar.resourcemanager.xalib.nt

Description

Specifies the XA-Library (DLL) used for this connection type on Windows 2000 or Windows XP.

Syntax

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.




com.sybase.jaguar.resourcemanager.xalib.solaris

Description

Specifies the XA-Library used for this connection type on Solaris.

Syntax

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.





Copyright © 2005. Sybase Inc. All rights reserved. Resource reference properties