[
https://issues.apache.org/jira/browse/CAMEL-4151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055161#comment-13055161
]
Julian Cable commented on CAMEL-4151:
-------------------------------------
Hi Christian, that's great. Pity it didn't show up in my Google searches. I
think we really need a link from
http://camel.apache.org/idempotent-consumer.html to
http://camel.apache.org/sql-component.html.
In terms of not showing the key syntax, there is a perfectly good SQL94 syntax
for this. Its much more uniform than your mixed case variable name syntax. But
your docs are good.
Julian
> 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