[CONJ-795] getRow() method of the ResultSet is 0 if defaultFetchsize is part of the connection string. - Jira

XML

Word

Printable

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>

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.