camel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Cable (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAMEL-4151) documentation for jdbc idempotent repository - use with spring DSL
Date Sun, 26 Jun 2011 21:07:47 GMT

    [ 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

       

Mime
View raw message