Requests

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

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

The adapter listens on the subject on which a client 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.

A request supports the following conditions:
  • DDL and DML SQL statements.
  • The column size of the returned result set cannot exceed 128 characters.
  • Multiple statements or procedures in a single transaction that 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() call is used, the adapter sends a response to the Inbox subject that was set by the client application. If the rv_SendWithReply() or rv_Rpc() call is not used, the adapter sends a 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>