Ask a Question

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

SOLVED
milindat28
New Contributor

[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?

1 ACCEPTED SOLUTION

Accepted Solutions
milindat28
New Contributor

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

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>

 

View solution in original post

1 REPLY 1
milindat28
New Contributor

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

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>

 

View solution in original post

cancel
Showing results for 
Search instead for 
Did you mean: