Contributions
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 contequivWHEREcont_id IN ( SELECT cont_id FROM contequivGROUP BYcont_idHAVINGCOUNT(cont_id) > 1 MINUS SELECTtarget_cont_id FROM inactivecontlinkWHERElink_reason_tp_cd = 1)GROUP BYcont_id ), IndividualData AS ( SELECTcont_id AS partyID,admin_client_id AS sourceID FROMcontequivWHERE cont_id IN ( SELECT cont_idFROMcontequiv GROUP BYcont_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.Solved755Views0likes4CommentsSoap 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 version297Views0likes1CommentUnable 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.704Views0likes2Comments