Restriction: This topic applies only when the Enterprise Server feature is enabled.
To complete the definition of an Oracle XAR, add the following values to the
Open string field. Enclose values containing spaces in double quotes:
LogDir=path+DbgFl=value+Oracle_XA+SesTm=time+SqlNet=name+Acc=P/user/password
[+LOCALTX={T|F}][+ISOLEVEL={CR|RO|SZ}]
[+ESLOGGING={0001|0002}]
Important: The open string format is defined by Oracle. We strongly recommend that you become familiar with all of the available options
by reviewing the
Oracle Application Developer's Guide - Fundamentals topic in your Oracle documentation. Example settings are shown in this topic for guidance only.
The parameters are:
- LogDir
- Fully-qualified path to the directory where the XA library error and tracing information may be logged.
- DbgFl
- Extent of tracing. Possible values are:
- 0x1, trace the entry and exit to each procedure in the XA interface
- 0x2, trace the entry to and exit from other non-public XA library routines
- 0x4, trace various other calls made by the XA library, such as specific calls to the Oracle Call Interface
- Oracle_XA
- The name of the resource manager.
- SesTm
- The maximum length of time a transaction can be inactive before it is automatically aborted by the system.
- SqlNet
- A string providing the Net8 database link used to log on to the Oracle system.
- Acc
- User access credentials, which must be prefixed by "P/".
- LOCALTX, ISOLEVEL, and ESLOGGING
- See
SQL xa_open string Configuration Options for details.