Publishing Table

Publishing tables mirror tables that you have identified for monitoring. They contain additional columns, primarily a sequence number and delivery status, which are required by the adapter to detect new rows. You can create a publishing table for each table you want to activate in TIBCO Designer.

The trigger generated at design time automatically populates the values for these additional columns. For better results, do not modify these values.

In addition to a copy of the source table columns, the publishing table has the following additional columns.

Publishing Table: Additional Columns

Column Name

Type

Description

ADB_SUBJECT

VARCHAR2(255)

Used to specify the subject to publish the current row. Length is 255. You can set a message subject in this field which takes precedence over the default service subject. The adapter will publish this row with this new message subject.

In group messaging, the group messages are sent to the subject set for the last row of the group.

ADB_SEQUENCE

INTEGER

Stores the monotonically increasing sequence number that represents new rows in the publishing table. If a column with this name exists, the number is generated automatically.

By default, the schema type is string. The adapter treats this number as a string. This number can be larger than an integer if the database supports it.

ADB_SET_SEQUENCE

INTEGER

Currently not used.

ADB_TIMESTAMP

DATE

Time of row insertion in publishing table that is used to calculate expiration of rows. The timestamp is generated automatically.

ADB_TRACKINGID

VARCHAR2(40)

Tracking ID of the message.

This is automatically added to the publishing table and the publishing schema.

If you do not want to monitor the tracking ID, you can manually remove this field from the project schema and the publishing table.

ADB_OPCODE

INTEGER

Operation code used by an adapter instance:

1 indicates INSERT.

2 indicates UPDATE.

3 indicates DELETE.

4 indicates UPSERT. UPDATE if row exists, otherwise INSERT.

10 indicates BYPASS (See Incremental Parent-Child Operation)

If an incoming TIBCO Rendezvous message does not have an operation code, an INSERT occurs.

Note: When working with a parent-child table, it is good practice to set the ADB_OPCODE columns in the parent and child table to the same value. Or only set the value of the ADB_OPCODE column in the parent table and leave the child table empty.

ADB_UPDATE_ALL

INTEGER

Currently not used.

ADB_REF_OBJECT

VARCHAR2(64)

When publishing by reference object is used, contains the name of the reference object that provides source data.

ADB_L_DELIVERY_STATUS

CHAR

Delivery status of a TIBCO Rendezvous message:

• P indicates pending acknowledgement.
• N indicates that a new message has arrived, but has not yet been published.
• S indicates that one thread has got this record, and will not be taken again when polling other records.
• C indicates complete.
• F indicates failed.

ADB_L_CMSEQUENCE

NUMBER(38, 0)

Certified messaging sequence number associated with this message.

 

Note 

When you use a publishing table, note the following conditions:

• When publishing a parent-child record or using Publish By Reference mode, if the key value is empty (null) in the publishing table, the adapter considers this as an error operation. Meanwhile, the adapter updates the failure status in the publishing table by setting adb_l_delivery_status to F. The data will not be published.
• In an adapter instance, if two or more services of Publication Service with the Rendezvous Certified (RVCM) transport enabled are set to the same message subject, the ADB_L_DELIVERY_Status status in the publishing table cannot be changed from P to C after data transmission.

The publishing table cannot contain any user-created columns where the column name starts with ADB_. These characters are reserved for the adapter use.