[jira] [Commented] (SOLR-2199) DIH JdbcDataSource - Support multiple resultsets

["Thomas Champagne (JIRA)" <ji...@apache.org>]

    [ 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org