I've submitted a JIRA and a patch relating to JdbcMessageIdRepository in the
camel-sql component:

https://issues.apache.org/jira/browse/CAMEL-4822

The existing JdbcMessageIdRepository is not compatible with MS SQL Server
(insert of a Timestamp is not supported by this database) and it was very
difficult to extend this class to change the SQL/table.  I've submitted a
patch that refactors the class to use an abstract base class.  This allows
others to easily extend the class to customize it to a specific environment.  

To implement a custom message ID repository, only three methods need to be
implemented to perform the query, insert and delete operations.

The existing JdbcMessageIdRepository behavior is preserved and the unit test
passes after the change.  I hope this is useful to other users of Apache
Camel.  Happy Holidays!

--
View this message in context: 
http://camel.465427.n5.nabble.com/Enhancement-JdbcMessageIdRepository-should-be-easy-to-extend-so-custom-SQL-and-tables-can-be-used-tp5095987p5095987.html
Sent from the Camel Development mailing list archive at Nabble.com.

Reply via email to