[CAMEL-16770] Add support for caching JDBC Idempotent Repository

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.11.0
• Fix Version/s: 3.12.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Michael Genereux
• Created: 30/Jun/21 00:40
• Updated: 06/Jul/21 11:35
• Resolved: 05/Jul/21 16:29

Description

The JDBC Idempotent Repository does a full transactional query on every check by the Idempotent Consumer.  On SQL Server implementations that have a high overhead per query, each query can take two seconds. For a 1000 checks, this can take a half hour.  My proposal is to cache the repository list in a single query and then reference that list in memory.

Issue Links

• links to: GitHub Pull Request #5767