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

[milindat28]

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?

[milindat28 · Accepted solution]

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>