Forum Discussion

vikititor's avatar
vikititor
Contributor
3 years ago

JDBC responses including the table names - remove them

I have a big project to test my app using MySQL.. now there in JDBC the table names with dot and column name in the response..  OK.. accepted.. whole project build based on this "unclear" behavior. ...
Assertions
Function Tests
Test Setup
nmrao's avatar
nmrao
Community Hero
3 years ago
Should be simple find and replace the table name.
In fact a common script can be created and called wherever needed and pass the table name as parameter.
vikititor's avatar
vikititor
Contributor
3 years ago

1. I must create explicit list of patterns (table names to replace)
2. is not systematical solution.

 

Is there no other way? So MySQL always will send me table names and ORACLE not?
I can not remember now - how it was 10 years ago in Free SoapUI - but I was testing both DB using the same test cases usually every day.. no issue. 

 

Any sugesstions? Why it is behaving like this?

  • nmrao's avatar
    nmrao
    Community Hero
    3 years ago
    Please check the jdbc test step options/congratulations to see if the table name can be omitted.
    • vikititor's avatar
      vikititor
      Contributor
      3 years ago

      there is nothing.

      BTW: the script is not easy.. I have no idea, how to make it.. there is no helper.. how to modify the JDBC response.. 
      I found it for requestFilter.afterRequest.. but it is not working.. 

      Maybe there is no request object..

      I have no idea..

       

      Output: ReadyAPI is not good for DB combinations testing.. Once created tests.. are frosen.. incompatible.