This is an automated email from the ASF dual-hosted git repository. acosentino pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/camel.git
The following commit(s) were added to refs/heads/master by this push: new a7016bb Add instruction to create unique constraint for idempotent repository new 09cbffb Merge pull request #2943 from mschnitzler/camel-sql-idempotentrepository-doc a7016bb is described below commit a7016bb94358e08d8ea5eb66ae7c79a5630a7900 Author: mschnitzler <schnitzler.michael+git...@gmail.com> AuthorDate: Wed May 22 22:02:25 2019 +0200 Add instruction to create unique constraint for idempotent repository --- components/camel-sql/src/main/docs/sql-component.adoc | 3 +++ 1 file changed, 3 insertions(+) diff --git a/components/camel-sql/src/main/docs/sql-component.adoc b/components/camel-sql/src/main/docs/sql-component.adoc index 535f069..7a987ae 100644 --- a/components/camel-sql/src/main/docs/sql-component.adoc +++ b/components/camel-sql/src/main/docs/sql-component.adoc @@ -533,6 +533,9 @@ WARNING: The SQL ServerĀ *TIMESTAMP* type is a fixed-length binary-string type. does not map to any of the JDBC time types: *DATE*, *TIME*, or *TIMESTAMP*. +When working with concurrent consumers it is crucial to create a unique constraint on the columns processorName and messageId. +Because the syntax for this constraint differs from database to database, we do not show it here. + ==== Customize the JdbcMessageIdRepository Starting with *Camel 2.9.1* you have a few options to tune the