You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@camel.apache.org by Christoph Burmeister <ch...@googlemail.com> on 2011/05/13 09:30:11 UTC

documentation of jdbc idempotent repository

Hi,
I got my two camels running with an idempotent repository (based on
jdbc to mysql). I searched the camel-website and the
camel-in-action-book, but didn't found any hint for the
table-definition of this repo, so after several errors in the logs, 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`)
)

Is there any documentation about the jdbc idempotent repository like
changing table-name or further details on table-definitions?

best,
christoph

Re: documentation of jdbc idempotent repository

Posted by Christoph Burmeister <ch...@googlemail.com>.

Hi Claus,

Thanks for fast reply.
I signed up and filed a JIRA : https://issues.apache.org/jira/browse/CAMEL-3969

will have a further look at the sources...

best,
christoph




2011/5/13 Claus Ibsen <cl...@gmail.com>:
> Hi
>
> Yeah that needs to be documented here
> http://camel.apache.org/sql-component.html
>
> Fell free to create a JIRA.
>
> Also we love contributions. To help with docu, read here
> http://camel.apache.org/contributing.html
>
>

Re: documentation of jdbc idempotent repository

Posted by Claus Ibsen <cl...@gmail.com>.

Hi

Yeah that needs to be documented here
http://camel.apache.org/sql-component.html

Fell free to create a JIRA.

Also we love contributions. To help with docu, read here
http://camel.apache.org/contributing.html


On Fri, May 13, 2011 at 9:30 AM, Christoph Burmeister
<ch...@googlemail.com> wrote:
> Hi,
> I got my two camels running with an idempotent repository (based on
> jdbc to mysql). I searched the camel-website and the
> camel-in-action-book, but didn't found any hint for the
> table-definition of this repo, so after several errors in the logs, 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`)
> )
>
> Is there any documentation about the jdbc idempotent repository like
> changing table-name or further details on table-definitions?
>
> best,
> christoph
>



-- 
Claus Ibsen
-----------------
FuseSource
Email: cibsen@fusesource.com
Web: http://fusesource.com
CamelOne 2011: http://fusesource.com/camelone2011/
Twitter: davsclaus
Blog: http://davsclaus.blogspot.com/
Author of Camel in Action: http://www.manning.com/ibsen/