[CONJ-795] getRow() method of the ResultSet is 0 if defaultFetchsize is part of the connection string. Created: 2020-06-05  Updated: 2020-08-25  Resolved: 2020-06-22

Status: Closed
Project: MariaDB Connector/J
Component/s: JDBC compatibility
Affects Version/s: 2.5.4
Fix Version/s: 2.6.1

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 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>


Generated at Thu Feb 08 03:18:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.