Database Communication Point in Input Mode

<!--  Database Communication Point in Input Mode Configuration Template  -->
<!--
This XML file is designed to help the user configure the Rhapsody Database 
Communication Point in Input 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>

    <!--  Order Column Configuration  -->
    <key>enter name of key column</key>
    <commPointID>unique id from other database commpoint input mode</commPointID>
    <initialKeyValue>enter initial key value</initialKeyValue>

    <!--  Refresh Rate in ms: default refresh rate 1 minute  -->
    <refreshRate>60000</refreshRate>

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

    <!--  Number of Rows to be used to generate a outgoing xml message  -->
    <!-- <rowsInMessage>1</rowsInMessage> -->

    <!-- 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 while 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/> -->

    <!--  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 'database' attribute: one of the secondary database names, if this
    attribute is omitted main database will be used for the statement.
    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="" database="" 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.
        The 'test' attribute: test condition to decide whether the sql query for 
        the statement is executed. A column value returned from the parent 
        statement can be tested. 
        -->

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

    </statement>

</config>