RE: JdbcMessageIdRepository and SQL Server: schema

2018-06-18 Thread Mark Harris - ICT
. Mark -Original Message- From: Claus Ibsen [mailto:claus.ib...@gmail.com] Sent: Monday, 18 June 2018 23:12 To: users@camel.apache.org Subject: Re: JdbcMessageIdRepository and SQL Server: schema Hi You can either create the table before-hand yourself in the right schema. Or you can try

Re: JdbcMessageIdRepository and SQL Server: schema

2018-06-18 Thread Claus Ibsen
Hi You can either create the table before-hand yourself in the right schema. Or you can try to configure the createString option on the JdbcMessageIdRepository, where you can specify the SQL statement it uses. The default one is: CREATE TABLE CAMEL_MESSAGEPROCESSED (processorName VARCHAR(255),

JdbcMessageIdRepository and SQL Server: schema

2018-06-17 Thread Mark Harris - ICT
Hello. I'm using Camel version 2.16.2 and am trying to create a JDBC message id repository within a Microsoft SQL Server database. I have created the appropriate JdbcMessageIdRepository bean and populated it with my SQL Server data source but I am finding that the "CAMEL_MESSAGEPROCESSED"