DB Event Inbound Endpoint Reference¶
The following configurations allow you to configure DB Event Inbound Endpoint for your scenario.
Parameter | Description | Required | Possible Values | Default Value |
---|---|---|---|---|
sequential | Whether the messages should be polled and injected sequentially. | Yes | true , false | TRUE |
driverName | The class name of the database driver. | Yes | com.mysql.jdbc.Driver | - |
url | The JDBC URL of the database. | Yes | jdbc:mysql://<HOST>/<DATABASE_NAME> | - |
username | The user name to connect to the database. | Yes | - | - |
password | The password to connect to the database. | Required if you have set a password for the database. | - | - |
tableName | The name of the table to capture changes to records. | Yes | - | - |
filteringCriteria | The criteria to poll the database for record changes. Possible criteria are as follows: |
Yes | - | - |
filteringColumnName | The actual name of the column that captures changes. |
Required if the value of the filteringCriteria parameter is specified as byLastUpdatedTimestampColumn or byBooleanColumn | - | - |
primaryKey | The primary key column name. | Yes | ID | - |
connectionValidationQuery | The query to check the availability of the connection. | No | SELECT 1 | SELECT 1 |
registryPath | The registry path of the timestamp. This is used to retrieve records when the value of the filteringCriteria parameter is specified as byLastUpdatedTimestampColumn. | No | - | Name of the Inbound Endpoint |
Rollback the events¶
Once processing of an event fails, it will trigger a specified fault sequence
. It is possible to specify the following property in such a situation.
<property name="SET_DB_ROLLBACK_ONLY" value="true"/>
true
, DB event listener will not do any updates to the database. That is, it will not delete the row associated with the event or it will not update the boolean value being monitored. Also, it will not consider that event as received by the endpoint. Upon the next DB event poll, the same event will be triggered again. You can build a re-try mechanism upon mediation failures using this feature.