Forum Discussion

milindat28's avatar
milindat28
New Contributor
9 years ago

[Solved]JDBC XML response inconsistent between UI and maven plugin

Ready API v 1.7.0 (UI)

Ready API maven plugin: 

<groupId>com.smartbear</groupId>
<artifactId>ready-api-maven-plugin</artifactId>
<version>1.7.0</version>

 

JDBC response from UI - using joins in sql cmd (includes table name):

 

<Results>
   <ResultSet fetchSize="0">
      <Row rowNumber="1">
         <CUSTOMER.ID>xxxxxx</CUSTOMER.ID>
         <ORGANIZATION.ID>xxxxxx</ORGANIZATION.ID>
      </Row>
   </ResultSet>
</Results>

  

JDBC Response from maven:

<Results>
   <ResultSet fetchSize="0">
      <Row rowNumber="1">
         <ID>xxxxxx</ID>
         <ID>xxxxxx</ID>
      </Row>
   </ResultSet>
</Results>

I need to use the xPath match assertion which is common for UI and maven run to be able to assert of two different IDs.

 

Saw an old post but there was no progress on this:

Old JDBC issue

 

Can I please have an update on this?

  • Resolved the issue:

     

    I updated the postgres sql maven dependency and all is working well.

     

    <dependency>
    	<groupId>org.postgresql</groupId>
    	<artifactId>postgresql</artifactId>
    	<version>9.4.1208</version>
    </dependency>

     

  • milindat28's avatar
    milindat28
    New Contributor

    Resolved the issue:

     

    I updated the postgres sql maven dependency and all is working well.

     

    <dependency>
    	<groupId>org.postgresql</groupId>
    	<artifactId>postgresql</artifactId>
    	<version>9.4.1208</version>
    </dependency>