Request-Response Service

Request-Response Service in TIBCO ActiveMatrix Adapter for Database allows an application to submit one or more SQL statements, stored procedures, or both for the adapter to execute. After execution, the adapter returns one or more result sets and a result code. The requests and responses are formulated using nested self-describing messages. See the figure: Typical Request-Response Service Flow.

Figure 38: Typical Request-Response Service Flow

The adapter can also be configured to manage requests using load balancing among a set of adapters that participate in the same named queue. Additionally, the adapter has been designed to allow multiple threads to process application requests.