You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@camel.apache.org by "Christoph Burmeister (JIRA)" <ji...@apache.org> on 2011/05/13 10:08:47 UTC
[jira] [Created] (CAMEL-3969) documentation for jdbc idempotent
repository
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
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
[jira] [Commented] (CAMEL-3969) documentation for jdbc idempotent
repository
Posted by "Julian Cable (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Assigned] (CAMEL-3969) documentation for jdbc idempotent
repository
Posted by "Christian Müller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Christian Müller reassigned CAMEL-3969:
---------------------------------------
Assignee: Christian Müller
> 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
[jira] [Commented] (CAMEL-3969) documentation for jdbc idempotent
repository
Posted by "Christian Müller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13033263#comment-13033263 ]
Christian Müller commented on CAMEL-3969:
-----------------------------------------
Christoph, you are right. Thanks for reporting this.
I updated the wiki page. The size of the columns can be changed, if your content is larger.
> 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
[jira] [Closed] (CAMEL-3969) documentation for jdbc idempotent
repository
Posted by "Christian Müller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Christian Müller closed CAMEL-3969.
-----------------------------------
Resolution: Fixed
> 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
[jira] [Commented] (CAMEL-3969) documentation for jdbc idempotent
repository
Posted by "Christian Müller (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CAMEL-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055140#comment-13055140 ]
Christian Müller commented on CAMEL-3969:
-----------------------------------------
You can find the documentation [here|https://cwiki.apache.org/confluence/display/CAMEL/SQL+Component].
> 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