[
https://issues.apache.org/jira/browse/CAMEL-4151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055182#comment-13055182
]
Christian Müller commented on CAMEL-4151:
-----------------------------------------
No, we not quote the column names. We use the column names as described on the
wiki page. This should work...
Do you already had issues with the JdbcMessageIdRepository and Postgres?
> documentation for jdbc idempotent repository - use with spring DSL
> ------------------------------------------------------------------
>
> Key: CAMEL-4151
> URL: https://issues.apache.org/jira/browse/CAMEL-4151
> Project: Camel
> Issue Type: Improvement
> Components: camel-sql
> Affects Versions: 2.7.1
> Environment: camels on any
> Reporter: Julian Cable
> Assignee: Christian Müller
> Labels: docuentation, idempotent, jdbc
> Original Estimate: 1h
> Remaining Estimate: 1h
>
> I couldn't find any reference to using this with spring DSL. I came up with
> this which seems to work:
> <bean id="myRepo"
> class="org.apache.camel.processor.idempotent.jdbc.JdbcMessageIdRepository">
> <constructor-arg index="0" ref="myJDBC"/>
> <constructor-arg index="1" value="foobar"/>
> </bean>
> <bean id="myJDBC"
> class="org.springframework.jdbc.datasource.DriverManagerDataSource">
> <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
> <property name="url" value="${myJDBC.uri}" />
> <property name="username" value="${myJDBC.username}" />
> <property name="password" value="${myJDBC.password}" />
> </bean>
> I think it would be better if the class had a default constructor and looked
> for properties.
> Julian
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
