RachelJones
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: PostgresQL select query results giving tablename for each node in respose for ReadyAPI1.4.1
Hi , I tried the proposed solution but it does not work.First part is event listener is not invoked. Second this is a common jdbc step which is working for Oracle .And we are adding the same compatibility in PostgreSql and SQLserver. The assertion is checking for the <value> node from the resultset which is an Alias name in the query.The assertion is getting passed for Oracle and sqlserver but failing for PostgreSql since the value node is appended with tablename <tableName.Value>. If you can throw some light on this.1.9KViews0likes1CommentRe: PostgresQL select query results giving tablename for each node in respose for ReadyAPI1.4.1
Hi , I was just curious to know that this is happening only in PostgreSql . For oracle and SQL it is giving only the alias name. Is this issue related with the ReadyAPI version since i am using 2.2. I will definitely give a try to the proposed solution.1.9KViews0likes2CommentsPostgreSQL not able to remove tableName appended to columnName in ReadyAPI2.2
If my query "Select Tablename.ID AS VALUE, 'ID' AS key From Schema.TableName Where Schema.Tablename.location = '${#TestCase#Doc}' runs in Oracle it gives me resultset as <Results> <ResultSet fetchSize="0"> <Row rowNumber="1"> <.VALUE>5955</.VALUE> <KEY>ID</KEY> </Row> </ResultSet> </Results> but when it runs on PostgreSql it gives me <Results> <ResultSet fetchSize="0"> <Row rowNumber="1"> <Tablename.VALUE>5955</Tablename.VALUE> <KEY>ImageID</KEY> </Row> </ResultSet> </Results>. Can anyone comment on this or the possible solution828Views0likes1Comment