D.38 HS_TRANSACTION_MODEL
HS_TRANSACTION_MODEL
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default Value |
|
Range of Values |
|
Specifies the type of transaction model that is used when the non-Oracle database is updated by a transaction.
The following values are possible:
COMMIT_CONFIRM
provides read and write access to the non-Oracle database and allows the gateway to be part of a distributed update. To use the commit-confirm model, the following items must be created in the non-Oracle database:- Transaction log table. The default table name is
HS_TRANSACTION_LOG
. A different name can be set using theHS_FDS_TRANSACTION_LOG
parameter. The transaction log table must be grantedSELECT
,DELETE
, andINSERT
privileges set to public. - Recovery account. The account name is assigned with the
HS_FDS_RECOVERY_ACCOUNT
parameter. - Recovery account password. The password is assigned with the
HS_FDS_RECOVERY_PWD
parameter.
- Transaction log table. The default table name is
READ_ONLY
provides read access to the non-Oracle database.SINGLE_SITE
provides read and write access to the non-Oracle database. However, the gateway cannot participate in distributed updates.READ_ONLY_AUTOCOMMIT
provides read only access to the non-Oracle database that does not use logging.SINGLE_SITE_AUTOCOMMIT
provides read and write access to the non-Oracle database without logging. The gateway cannot participate in distributed updates. Moreover, any update to the non-Oracle database is committed immediately.
Parent topic: Initialization Parameters