<!-- Database Communication Point in Output Mode 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 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. This 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 an SQL statement when the message field does not 
    exist 
    -->
    <!--  <convertNullFields/>  --> 

    <!--  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', 'database', 'test' and 'maxResultRow' 
    attribute can be omitted 
    --> 
    <statement name="" iterate="" database="" test="" maxResultRows="0">

        <!-- SQL or Stored Procedure for the statement, this element is optional --> 
        <sql>enter 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>