D.38 HS_TRANSACTION_MODEL

HS_TRANSACTION_MODEL initialization parameter for Oracle Database Gateway for SQL Server.

Property	Description
Default Value	COMMIT_CONFIRM
Range of Values	COMMIT_CONFIRM, READ_ONLY, SINGLE_SITE, READ_ONLY_AUTOCOMMIT, SINGLE_SITE_AUTOCOMMIT

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 the HS_FDS_TRANSACTION_LOG parameter. The transaction log table must be granted SELECT, DELETE, and INSERT 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.
• 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.