Database Message Extraction Filter

<!--  Database Query Filter Configuration Template  -->
<!--
This XML file is designed to help the user configure the Rhapsody Database 
Communication Point in Output mode. 
All element or attribute tags are not case sensitive, i.e., both 'config' 
and 'CONFIG' are valid tags. 
Please refer to the Rhapsody Reference guide and tutorials 
for more information. 
-->

<config>

    <!--  Main Database Standard JDBC Configuration  -->
    <driver>enter driver name here</driver>
    <url>enter database url here</url>
    <username>enter database username here</username>
    <password>enter database password</password>

    <!-- Secondary Database Standard JDBC Configuration
    Zero or more secondary databases can be configured.
    Please remove the database element if it is not required.
    -->
    <database name="enter this database name">
        <driver>enter driver name here</driver>
        <url>enter database url here</url>
        <username>enter database username here</username>
        <password>enter database password</password>
    </database>

    <!-- Database Connections' Auto-Commit Mode Configuration
    By default, auto-commit mode is turned off which means that transactions 
    will be rolled back in case of failure in processing the message.
    The auto-commit mode option will be applied to all the database connections.
    Use the property which is required (if only SELECT statements are used then 
    it may be turned on in order to enhance the performance in processing messages).
    -->
    <!--  <autoCommit/>  -->

    <!-- Convert null fields: an empty string("") is used to generate a sql 
    statement when the message field does not exists. 
    -->
    <!--  <convertNullFields/>  --> 

    <!-- Output Message Format Configuration
    Use the property which is required
    -->
    <!-- <columnNameAsAttribute/>  -->
    <!-- <rowNameAsAttribute/>  -->
    <!-- <valueAsAttribute/>  -->

    <!--  Statements Configuration  -->

    <!-- Root Statement Configuration 
    One root statement can be configured
    The 'name' attribute: name of the statement, the name will be used to 
    refer the statement in the Rhapsody log.
    The 'iterate' attribute: full path of a message element which is repeating 
    so that the statement can be iterated.
    The 'database' attribute: one of the secondary database names, if this 
    attribute is omitted main database will be used for the statement.
    The 'test' attribute: test condition to decide whether the sql query 
    for the statement is executed.
    The 'maxResultRows' attribute: maximum Number of Rows Limit that Result 
    Set can hold for the statements: default 0 means no limit
    The 'name', 'iterate' and 'database' attribute can be omitted
    --> 
    <statement name="" iterate="" database="" test="" maxResultRows="0">

    <!--  SQL or Stored Procedure for the statement, this element can be omitted  -->
        <sql>enter SELECT sql query</sql>
        <!--  <procedure>enter stored procedure</procedure> -->

        <!-- Child Statements Configuration
        One or more child statements can be configured.
        A child statement can have one or more child statements.
        Attribute details are the same as the root statement.
        -->

        <statement name="" iterate="" database="" test="" maxResultRows="0">
                <sql>enter sql query</sql>
                <!--  <procedure>enter stored procedure</procedure>  -->
        </statement>

    </statement>

</config>