Passing XML Structures

The JDBC Connector allows to pass XML structures. Within an input XML document you can define custom XML structures in addition to the SQL statement structures that are directly output by the adapter. This may simplify the process modeling in many cases by enabling to process those XML structures together with the SQL statement(s)' results.

Input

With the following statement defined as child of the root element in your input XML document, you can pass one or several XML structures:

HTML/XML

<copy resulttag="name of the parent element">
  any XML structure
</copy>

Output

The XML structure defined within the <copy> element will be output by the JDBC Connector without Processing Instructions and comments. Thereby, the XML structure is enclosed by an element specified in the input structure within the attribute resulttag.

HTML/XML

<name of the parent element>
  Input XML structure
</name of the parent element>

Example

Additionally to an SQL statement, an XML structure for the passing is defined in the following input XML document:

HTML/XML

<Root>
  <statement resulttag="result" timezone="UTC" format="dd.MM.yyyy">
    <sql>  <![CDATA[SELECT * FROM JMS_USERS]]>  </sql>
  </statement>
  <copy resulttag="Content">
    <Data>Text</Data>
  </copy>
</Root>

As a result, the JDBC Connector outputs e. g. the following result XML document containing the XML structure with the specified parent elements:

HTML/XML

<Data>
  <result>
    <USERID>user</USERID>
    <PASSWD>password</PASSWD>
    <CLIENTID isNull="true" />
  </result>
  <Content>
    <Data>Text</Data>
  </Content>
</Data>