Requests

A request contains one or more SQL statements, stored procedures, functions, or packages to be performed as a transaction.

The text of the SQL statement follows the conventions for JDBC SQL syntax. All SQL statements supported by the DBMS are allowed and placeholders (represented by a question mark, ‘?’) are permitted in the SQL statement, conforming to the JDBC rules. For performance reasons, use a SQL statement. The ‘?’convention should only be used to bind binary data or call stored procedures.

The adapter listens on the subject on which the application sends requests. The application uses TIBCO Rendezvous or TIBCO Adapter SDK to send a self-describing message containing a request on the agreed subject to the adapter configuration.

The following conditions are supported:

DDL and DML SQL statements.
The column size of the return resultset cannot exceed 128 characters.
Multiple statements or procedures in a single transaction send a nested TIBCO Rendezvous message.
rv_Send(), rv_SendWithReply(), and rv_Rpc() calls.
TIBCO Rendezvous Java APIs.

Note: If the rv_SendWithReply() or rv_Rpc() calls are used, the adapter sends the response to the Inbox subject that was set by the application for the response. Otherwise, the adapter sends the response on the response subject that was set at configuration time.

TIBCO ActiveEnterprise or XML Message Request Format

In TIBCO ActiveEnterprise or XML Message Request format, the input class is SQL_REQUEST. Also see "SQL_STATEMENT Class" in Standard RPC Operation.

The SQL_REQUEST class is described as follows.

<object name="SQL_REQUEST" lastModified="1036435805361" id="503">
<assoc name="attribute">
<string name="name" value="STATEMENTS"/>
<ref name="attributeType"
value="/tibco/public/sequence/ae/class/ae/ADB/adbmetadata/sequence
[SQL_STATEMENT]"/>
<string name="isKey" value="false"/>
<string name="isReadable" value="true"/>
<string name="isWriteable" value="true"/>
</assoc>
<assoc name="attribute">
<string name="name" value="CLOSURE"/>
<ref name="attributeType" value="/tibco/public/scalar/ae/any"/>
<string name="isKey" value="false"/>
<string name="isReadable" value="true"/>
<string name="isWriteable" value="true"/>
</assoc>
<string name="family" value="ae"/>
<string name="objectType" value="class"/>
</object>