![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
To implement Fail Safe level‑1 processing, you must define an external DBMS table similar to the one shown below.
The sample Oracle table definition below shows Oracle terms, and that terms vary from one DBMS to another. The table in the example below holds a maximum of one record for each combination of a Gateway and Data Object Broker.
During Fail Safe level‑1 processing, the Gateway inserts or replaces this table. If the Gateway is running with Security Level=1, this table is updated under the authorization of the TIBCO Object Service Broker client/session user ID. All users that need to access the external DBMS through the Gateway and run transactions that update both TDS and external data must have read and write access to this table.
• Set FSTABLENAME to the name of the external transaction table you defined in the external DBMS. This name is used “as is”, that is, no qualifier (catalog) and owner (schema) are prepended to it so it can contain those if needed, for instance “pubs.dbo.ostarfs.”
• Set TRXDB to the ODBC data source or Oracle SID denoting the database where you defined the transaction table that you plan to have participate in Fail Safe processing.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |