[
https://issues.apache.org/jira/browse/SOLR-2199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14082073#comment-14082073
]
Thomas Champagne commented on SOLR-2199:
----------------------------------------
I don't understand why this patch have not been applied. It is very small and
uncomplicated. It's a good idea to read multiple resultset from a single
statement.
But in my case, i would like set SQL session parameters before executing the
query.
For example with a Postgresql example :
{code:sql}
SET join_collapse_limit=1;
SELECT * FROM library.book b
LEFT JOIN library.page p ON p.id_book=b.id_book;
{code}
In this example, the first resultset is empty but with the patch, the second
resultset would be read.
> DIH JdbcDataSource - Support multiple resultsets
> ------------------------------------------------
>
> Key: SOLR-2199
> URL: https://issues.apache.org/jira/browse/SOLR-2199
> Project: Solr
> Issue Type: Improvement
> Components: contrib - DataImportHandler
> Affects Versions: 1.4.1
> Reporter: Mark Waddle
> Attachments: SOLR-2199.patch
>
>
> Database servers can return multiple result sets from a single statement.
> This can be beneficial for indexing because it reduces the number of
> connections and statements being executed against a database, therefore
> reducing overhead. The JDBC Statement object supports reading multiple
> ResultSets. Support should be added to the JdbcDataSource to take advantage
> of this.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
