[CAMEL-18157] camel-jdbc - The settings provided by the query parameter "parameters" are ignored when useHeadersAsParameters

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.14.3
• Fix Version/s: 3.14.4, 3.18.0
• Component/s: camel-jdbc
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Andrea Evangelista
• Created: 31/May/22 14:16
• Updated: 01/Jun/22 04:37
• Resolved: 01/Jun/22 04:37

Description

The settings provided by the query parameter "parameters" are ignored when useHeadersAsParameters is true.

Example:

jdbc:xxxxx?useHeadersAsParameters=true&statement.fetchSize=100&outputType=StreamList&resetAutoCommit=false

In this specific case statement.fetchSize=100 will be ignored and all the rows will be fetched in memory for an sql query like this one:

SELECT * from MY-BIG-TABLE

Issue Links

• links to: GitHub Pull Request #7701