ContributionsMost RecentMost LikesSolutionsRe: SOAPUI JDBC error while creating a table view Hi Todd, Tried removing ';' and it worked in Soapui. Regards, Prabaharan Re: SOAPUI JDBC error while creating a table view Hi nmrao , I tried the same query in DBVisualizer and able to see the result. Below snippet for your reference. Same when tried from SOAP UI getting below error Can you help me on this? Thanks SOAPUI JDBC error while creating a table view Hi, I'm doing a database automation using JDBC request in soapui open source. I'm able to connect to DB2, but getting error while running the below query. WITH AggregatedData AS ( SELECT cont_id AS partyID, COUNT(DISTINCT admin_client_id) AS count_admin_client_id FROM contequiv WHERE cont_id IN ( SELECT cont_id FROM contequiv GROUP BY cont_id HAVING COUNT(cont_id) > 1 MINUS SELECT target_cont_id FROM inactivecontlink WHERE link_reason_tp_cd = 1 ) GROUP BY cont_id ), IndividualData AS ( SELECT cont_id AS partyID, admin_client_id AS sourceID FROM contequiv WHERE cont_id IN ( SELECT cont_id FROM contequiv GROUP BY cont_id HAVING COUNT(cont_id) > 1 MINUS SELECT target_cont_id FROM inactivecontlink WHERE link_reason_tp_cd = 1 ) ) SELECT AggregatedData.partyID, AggregatedData.count_admin_client_id, LISTAGG(IndividualData.sourceID, ', ') WITHIN GROUP (ORDER BY IndividualData.sourceID) AS sourceIDs FROM AggregatedData JOIN IndividualData ON AggregatedData.partyID = IndividualData.partyID GROUP BY AggregatedData.partyID, AggregatedData.count_admin_client_id; The above query is working when tried from different DB client but not in soapui JDBC request. Getting below error "Error getting response; com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;ount_admin_client_id;END-OF-STATEMENT, DRIVER=4.25.13" Appreciate if anyone can help me in resolving the issue. Thanks in advance. SolvedRe: Soap UI rest project - Unable to fetch dynamic response value when multiple nested filters are given Hi All, Anyone's solution to this will of much helpful. Soap UI rest project - Unable to fetch dynamic response value when multiple nested filters are given Hi All, I'm trying to pull dynamically generated ID value from my response through Property transfer and trying to substitute in another request. I'm using nested filters in my jsonpath and not the position of the attributes since those are dynamic. Below is my response { "TCRMService": { "@schemaLocation": "http://www.ibm.com/mdm/schema MDMDomains.xsd", "TxResponse": { "RequestType": "createCustomer", "TxResult": { "ResultCode": "SUCCESS" }, "ResponseObject": { "TCRMContractBObj": { "ContractIdPK": "167368519964531257", "TCRMContractComponentBObj": { "ContractComponentIdPK": "162868519964531919", "TCRMContractPartyRoleBObj": [ { "ContractRoleIdPK": "161168519964532379", "RoleValue": "Owner", "TCRMContractRoleLocationBObj": [ { "TCRMExtension": { "ExtendedObject": "XContractRoleLocationBObjExt", "XContractRoleLocationBObjExt": { "XCustomerSiteId": "400000009088793" } }, "TCRMPartyAddressBObj": [ { "TCRMAddressBObj": { "AddressIdPK": "794168518374167884", "AddressLineOne": "Ap #819-8439 Nonummy Rd.", "City": "Rothes" } } ] }, { "TCRMExtension": { "ExtendedObject": "XContractRoleLocationBObjExt", "XContractRoleLocationBObjExt": { "XCustomerSiteId": "400000009088794" } }, "TCRMPartyAddressBObj": [ { "TCRMAddressBObj": { "AddressIdPK": "796168518374180269", "AddressLineOne": "3290 LakeView Ave.", "City": "Miami" } } ] } ] } ] } } } } } } My jsonpath is : $.TCRMService.TxResponse.ResponseObject.TCRMContractBObj.TCRMContractComponentBObj.TCRMContractPartyRoleBObj[?(@.RoleValue=="Owner")].TCRMContractRoleLocationBObj[?(@.TCRMPartyAddressBObj[?(@.TCRMAddressBObj[?(@.AddressLineOne=="Ap #819-8439 Nonummy Rd.")])])].TCRMExtension.XContractRoleLocationBObjExt.XCustomerSiteId As a result Im expecting [400000009088793] but I'm getting [400000009088793, 400000009088794]. Appreciate if anyone can help me on this. BTW I'm using soapui 5.7.0 version Re: Unable to capture all test metrics in Junit HML report for Data driven test from Launch testrunner Hi, I not able to resolve this issue. Can anyone help me in resolving this? Thanks in advance. Re: Unable to capture all test metrics in Junit HML report for Data driven test from Launch testrunner Hi, Can anyone help me in resolving this? Thanks in advance. Unable to capture all test metrics in Junit HML report for Data driven test from Launch testrunner Hi, I have created a data driven test project in Soapui open source and I'm able to generate Junit style HTML report by integrating with Apache Ant and tried running the project from Launch Test runner. But the generated report has only status of the last test case and the previous case status are overridden. Note : This happens only for data driven project whereas HTML report looks fine for normal project. Appreciate if anyone can help me in resolving this and I wanted to capture all test metrics in my report file for the data driven project. Thanks in advance. Re: Generate HTML report for Data driven testing in Soap UI open source Hi, Thanks for the note. Interesting approach. But I wonder how this can be achieved in Soapui free version. Appreciate if you can elaborate in detail with steps, so that I can follow the same. Re: Generate HTML report for Data driven testing in Soap UI open source Hi ChrisA, Yes you right.