[CAMEL-16798] JdbcCachedMessageIdempotentRepository broken on case changing SQL implementations

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.12.0
• Fix Version/s: 3.12.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Michael Genereux
• Created: 09/Jul/21 00:05
• Updated: 09/Jul/21 04:21
• Resolved: 09/Jul/21 04:21

Description

On case-sensitive SQL implementations that also manipulate the case of unquoted SQL names, the `JdbcCachedIdempotentMessageIdRepository` uses column names to retrieve SQL results and fails.  While this is a failure on the part of the SQL implementation, there's no reason that using column index methods can't be used and fix the problem.

 

Issue Links

• links to: GitHub Pull Request #5817