JDBC Request/Query for value located within data BLOB
I am attempting to execute the following query within a ReadyAPI JDBC request SELECT * FROM consumer WHERE consumer.payload LIKE '%name%' The issue is that ReadyAPI treats the '%' as part of the literal string which from what I understand is a sort of wildcard and used to match the given name exactly so instead of just using name it uses %name% and then returns null Within Oracle SQL Developer the query executes just fine and returns the expected corresponding row(s) but when attempting to execute it within ReadyAPI JDBC request i get null. How exactly do I go about writing the query in ReadyAPI to treat the '%' as a sort of wildcard and not actually part of the string/value?
Assertion error log
Hi All, I need suggestion please on how to approach the following: I created a script to compare 2 very large tables before and after deployment. in the beginning I was looping thru each row and column to compare values and I was able to see the exact field that has a mismatch in the assertion log but the issue is the script was taking way too long. So I decided to to compare the whole resultSet received from both tables but and now I am facing a different issue, when there is a mismatch the assertion error log doesn't show where the exact discrepancy is but rather it shows the error mismatch between the full resultSet. is there a way to capture few lines in the error log around the mismatched string in the resultSet from the assertion instead of the whole thing ERROR: Assertion failed: assert beforeTable == afterTable | | | | | '<ResultSet ..... </ResultSet>' | false '<ResultSet ..... </ResultSet>'Multi Thread Groovy test step
Hello, I would really appreciate help with this. I create a test that compares data between 2 tables with large data return. the script does the job perfectly but it takes very long time to execute as it loops thru hundreds of thousands of records and verify value to value from each column. I was wondering if there is a way to run the test step groovy script in multi thread instead of doing one value at a time. thanks in advance!using groovy script in readyapi
I have maven project for my readyapi, have java and groovy script in it, and placed jar into C:\Program Files\SmartBear\ReadyAPI-3.51.0\lib my groovy script directory is in src/main/groovy directory. So I am able to use java classes but when I try to use groovy script in readyapi step it doesn't work, not able to find groovy class. I can add my groovy script to C:\Program Files\SmartBear\ReadyAPI-3.51.0\bin\scripts and that works as expected, but how can I use groovy script in my maven project from jar file I added it to C:\Program Files\SmartBear\ReadyAPI-3.51.0\lib ? Here is the groovy script I use in my readyapi to call groovy script in maven project: import src.main.groovy.Utilities def utilities = new Utilities(context, context.testCase.testSuite, log) utilities.loadConfigurations() Thanks in advance,
String.replaceAll not working in Groovy script
I am using a file as a template in order to create new files. The template file contains "placeholders" in the form of[plc]placeholderName[plc]. I want to replace the placeholder at runtime with values as shown in the groovy script. However the String.replaceAll() method seems not to work (placeholders don't get replaced) Am I missing something? The contents of the Template.xml are: My groovy script is: Thanks
