[
https://issues.apache.org/jira/browse/CAMEL-4151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055179#comment-13055179
]
Julian Cable commented on CAMEL-4151:
-------------------------------------
That makes sense - its not a big problem, your code seems to work with MySQL,
but it takes a bit of care to get this right. I don't think it would work with
Postgres unless one was very careful with the create statement, and Postgres is
very standards compliant. It might be worth listing the actual insert and
select statements you use on the documentation page to give people a hint - for
example, I presume you don't quote the field names at all?
> 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
