Croway opened a new pull request, #30044: URL: https://github.com/apache/camel/pull/30044
JIRA: [CAMEL-26991](https://issues.apache.org/jira/browse/CAMEL-26991) - `outputType=StreamList` took a connection from the DataSource itself: in a transacted route the query ran outside the transaction, and the `template.*` options (`maxRows`, `fetchSize`, `queryTimeout`) were ignored. - The producer now gets and releases the connection with `DataSourceUtils` (as `JdbcTemplate` does), so it uses the connection of the transaction without closing it, and applies the template statement settings. The `CamelSqlDataSource` header keeps the template options of the endpoint. - The "Using StreamList" docs say how long the iterator lives, that no `CamelSqlRowCount` is set, and that streaming depends on the driver. Tests: `SqlProducerStreamListJdbcTemplateTest` (transacted route, `template.maxRows`, `CamelSqlDataSource` header). Upgrade guide: camel-sql - outputType=StreamList takes part in the transaction and applies the template options. _Claude Code on behalf of Federico Mariani_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
