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
[,USERP={T|F}][,BATCHONLY={T|F}][,LOCALTX={T|F}][,ISOLEVEL={CR|RO|SZ}]
[,ESLOGGING=0001]
Important: The open string format is defined by Oracle. We strongly recommend that you become familiar 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/".
- USERP, BATCHONLY,
LOCALTX, ISOLEVEL, and ESLOGGING
- See
SQL xa_open string Configuration Options for details.
