Configuration Recommendations

The following recommendations and limitations apply when using TIBCO ActiveMatrix Adapter for Database:

•

The wire format for both the publishing and destination tables must be the same, otherwise an error will occur.

•

Publisher and subscriber information can be defined in the same project for all cases. When using parent-child tables or the XML wire format, define the publisher and subscriber in the same repository.

•

For the limitations that apply to parameterized subject names and destination names, see Parameterized Subject and Destination Name Restrictions in Advanced Topics.

•

A subscriber adapter connected to the Microsoft Azure or Oracle database is hung when the network is cut or reconnection is performed. To resolve this issue, take the following measures:

—

Connection to the Microsoft Azure database: Select the locked table by executing the following SQL statement:

select request_session_id as session_id,OBJECT_NAME(resource_associated_entity_id) as tableName from sys.dm_tran_locks where resource_type='OBJECT';

Kill the locked thread and then restart the adapter.

Alternatively, you can do nothing and wait until the database server releases the dead lock.

—

Connection to the Oracle database: In the sqlnet.ora file located in the ORACLE_HOME\NETWORK\ADMIN directory, set the following parameter:

SQLNET.EXPIRE_TIME = 1