Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-795

getRow() method of the ResultSet is 0 if defaultFetchsize is part of the connection string.

    XMLWordPrintable

    Details

      Description

      To reproduce:

      Install SoapUI.
      copy mariadb JDBC driver into <soapUIfolder>/bin/ext
      Restart Soapui

      Create Empty Project
      Create TestSuite
      Create Test Step
      Add JDBC Request

      JDBC Request:

      Driver: org.mariadb.jdbc.Driver
      jdbc:mariadb://localhost/?user=tos&password=password&defaultFetchsize=10

      SQL Query:
      select * from <random table with content>

      Example:
      Result is

      <Results>
          <ResultSet fetchSize="10">
              <Row rowNumber="0">
                  <C3.A>1</C3.A>
                  <C3.B/>
              </Row>
              <Row rowNumber="0">
                  <C3.A>3</C3.A>
                  <C3.B>1</C3.B>
              </Row>
              <Row rowNumber="0">
                  <C3.A>2</C3.A>
                  <C3.B>2</C3.B>
              </Row>
              <Row rowNumber="0">
                  <C3.A/>
                  <C3.B>1</C3.B>
              </Row>
          </ResultSet>
      </Results>
      
      

      Should be:

      <Results>
          <ResultSet fetchSize="0">
              <Row rowNumber="1">
                  <C3.A>1</C3.A>
                  <C3.B/>
              </Row>
              <Row rowNumber="2">
                  <C3.A>3</C3.A>
                  <C3.B>1</C3.B>
              </Row>
              <Row rowNumber="3">
                  <C3.A>2</C3.A>
                  <C3.B>2</C3.B>
              </Row>
              <Row rowNumber="4">
                  <C3.A/>
                  <C3.B>1</C3.B>
              </Row>
          </ResultSet>
      </Results>
      
      

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: