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