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
vikititor's avatar
vikititor
Contributor

Development of this script will be a nightmare.. 

there is a lot of tables.. I have no idea.. how to acheave this. 
Thanks for help.

nmrao's avatar
nmrao
Champion Level 3
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
      Champion Level 3
      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.