[CAMEL-17616] JdbcAggregationRepository will not start if it contains too many exchanges

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.11.2
• Fix Version/s: 3.11.6, 3.14.2, 3.16.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Benjamin BONNET
• Created: 08/Feb/22 09:13
• Updated: 09/Feb/22 12:15
• Resolved: 09/Feb/22 11:32

Description

Hi,

We are using a JdbcAggregationRepository with a transactional Datasource. When JdbcAggregationRepository is started, if its table contains lots of rows, a transaction timeout may occur and make it fail to start.

Actually, when repo starts, doStart method is invoked, that method calls getKeys() and iterates over every row in order to count them, which may be quite long if repo contains millions of rows. 

In order to avoid that issue, count could be implemented directly in the SQL query.

Issue Links

• links to: GitHub Pull Request #6902