Adapter requests and responses for the SQL actor adapter

The SQL adapter requests and responses are action- specific, and the samples and templates for each action are provided in the sub-sections. The action indicated can be entered in the adapter's Action field in the Property panel of the Call Adapter activity in TrueSight Orchestration Development Studio. You can specify the following values in the adapter's Action field when configuring the activity properties for a Call Adapter activity:

• Query: This action reads records for parameterized statements and procedure calls.

• Update: This action updates records for parameterized statements and procedure calls. 

  Note

  In case, you specify a value other than query or update in the adapter's Action field, the adapter takes the value as update and updates records for parameterized statements and procedure calls.

  The samples for the request and response for each option are provided in the following sections. 

  Note

  Starting with the 20.12.02 release, the SQL adapter supports Internet Protocol version 6 (IPv6) for directing internet traffic and for routing for different databases.

  The following table describes the IPv6 specifications for the different databases that the SQL adapter supports:
  The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
  This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.

For details on IPv6, see Support for IPv6. You can specify an IPv6 address with a zone ID for the <host> or <url> elements in the adapter requests—for example, <host>fe80::20c:29ff:fe5d:38f0%eth0</host>. To find the zone ID of the required computer, see Zone ID for an IPv6 address.

Following are the options that you can use to define SQL actor adapter requests:

• Standard: Requests that use a single <action> element that contains an SQL statement. This statement can be wrapped in CDATA to handle XML special characters, but the data values can not contain characters that the target database considers as special characters.
  
  
• Parameterized Statements: Requests that can be used to execute SQL statements against one or more data sets. The statements can contain bind variables as needed. JDBC handles any data values containing characters considered as special characters (by the target database). These statements support transactions.

  The SQL adapter supports the following root tags for an adapter request:

  • <sqlAdapterRequest>
  • <sqladapterRequest>
  • <sql-adapter-request>

  BMC recommends that you use the <sqlAdapterRequest> root tag for the adapter request.