[
https://issues.apache.org/jira/browse/CAMEL-7904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14169599#comment-14169599
]
Camel Guy commented on CAMEL-7904:
----------------------------------
I just went through the Statement JDBC interface and it appears that there is
no way to know how many ResultSets will be returned. You have to process each
ResultSet until there are no more. So my first suggestion won't work.
> JDBC component: Support for multiple resultSets
> -----------------------------------------------
>
> Key: CAMEL-7904
> URL: https://issues.apache.org/jira/browse/CAMEL-7904
> Project: Camel
> Issue Type: New Feature
> Affects Versions: 2.14.0
> Reporter: Camel Guy
>
> For PostgreSQL it is common to run two commands in a single transaction in
> order to set the schema search path:
> set search_path to foo, public;
> select 5;
> Due to connection pooling it is desirable to combine both statements in a
> single operation.
> These types of queries don't work with the jdbc component because it only
> returns the result set for the first command (set search_path), which is
> always empty.
> Easiest solution is to provide a uri option to return the last result set
> instead of the first one. This solution would be preferable to me and would
> be compatible with streaming.
> A more complete solution would be an option to return all of the result sets.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
