[jira] [Resolved] (CAMEL-17616) JdbcAggregationRepository will not start if it contains too many exchanges

["Claus Ibsen (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CAMEL-17616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Claus Ibsen resolved CAMEL-17616.
---------------------------------
    Resolution: Fixed

> JdbcAggregationRepository will not start if it contains too many exchanges 
> ---------------------------------------------------------------------------
>
>                 Key: CAMEL-17616
>                 URL: https://issues.apache.org/jira/browse/CAMEL-17616
>             Project: Camel
>          Issue Type: Improvement
>          Components: camel-sql
>    Affects Versions: 3.11.2
>            Reporter: Benjamin BONNET
>            Priority: Minor
>             Fix For: 3.16.0
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)