Solr
  1. Solr
  2. SOLR-2199

DIH JdbcDataSource - Support multiple resultsets

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.4.1
    • Fix Version/s: None
    • Labels:
      None

      Description

      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.

        Activity

        Mark Waddle created issue -
        Hide
        Mark Waddle added a comment -

        Patch to support multiple result sets in JdbcDataSource

        Show
        Mark Waddle added a comment - Patch to support multiple result sets in JdbcDataSource
        Mark Waddle made changes -
        Field Original Value New Value
        Attachment SOLR-2199.patch [ 12458074 ]
        Hide
        Thomas Champagne added a comment -

        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 :

        SET join_collapse_limit=1;
        SELECT * FROM library.book b
        LEFT JOIN library.page p ON p.id_book=b.id_book;
        

        In this example, the first resultset is empty but with the patch, the second resultset would be read.

        Show
        Thomas Champagne added a comment - 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 : SET join_collapse_limit=1; SELECT * FROM library.book b LEFT JOIN library.page p ON p.id_book=b.id_book; In this example, the first resultset is empty but with the patch, the second resultset would be read.

          People

          • Assignee:
            Unassigned
            Reporter:
            Mark Waddle
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development