You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@camel.apache.org by "Julian Cable (JIRA)" <ji...@apache.org> on 2011/06/25 00:59:47 UTC
[jira] [Commented] (CAMEL-3969) documentation for jdbc idempotent
repository
[ https://issues.apache.org/jira/browse/CAMEL-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13054732#comment-13054732 ]
Julian Cable commented on CAMEL-3969:
-------------------------------------
Shouldn't the primary key be (processorName,messageId) ?
And the back-ticks are MySql specific - the SQL standard is double quotes.
Julian
> documentation for jdbc idempotent repository
> --------------------------------------------
>
> Key: CAMEL-3969
> URL: https://issues.apache.org/jira/browse/CAMEL-3969
> Project: Camel
> Issue Type: Improvement
> Components: camel-sql
> Affects Versions: 2.7.1
> Environment: camels on win2k3, mysql(5.5.8) on win2k3
> Reporter: Christoph Burmeister
> Assignee: Christian Müller
> Labels: docuentation, idempotent, jdbc
> Fix For: 2.8.0
>
>
> When running several camels with an idempotent repository (based on
> jdbc to mysql) I haven't found any documentation for the table-definition or for changing parameters (like table-name).
> Getting through the sources, I tried out following definition on mysql that works for me:
> CREATE TABLE IF NOT EXISTS `camel_messageprocessed` (
> `messageId` varchar(255) NOT NULL,
> `processorName` varchar(255) NOT NULL,
> PRIMARY KEY (`messageId`)
> )
> Please check this back.
>
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira