milindat28
9 years agoNew 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:
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>