Service Virtualization

  • 1.  JDBC data set

    Posted Mar 21, 2019 03:55 PM

    Read rows from JDBC data set. I have using a MySQL database to paremterize my API request parameters. Currently, there is no way I could parameterize the password in Read rowd from JDBS data set.

     

    My concern is if the password is changed tomorrow, I would have to change all my test cases in Devtest. Is there a way that this password can be stored and maintained at single place ?



  • 2.  Re: JDBC data set

    Posted Apr 18, 2019 08:22 AM

    Hi Rish,

     

    Not sure I had understand your question fully but I think you can store password in configs-->project that holds global variables in key value pair that can be used in the entire test suite. So for example if you store your key as  "password" and value as "abc" then you can use that in your test using {{password}}.

     

    Please let me know if this answers your query.

     

    Regards,

    Manik



  • 3.  Re: JDBC data set

    Posted Apr 18, 2019 09:48 PM

    Hi Manik,

     

    Read rows from JDBC data set does not allow parameterization as you suggested {{password}. It only takes ***** characters.



  • 4.  Re: JDBC data set

    Broadcom Employee
    Posted Apr 19, 2019 02:33 AM

    No, it should work, have you tried it?

     

    Obviously as your entering {{password}} as text into a password field it substitutes your entry with **** for privacy reasons. The big risk is that you don't see if you are making a typo, that is why I always wrote out the curly-braced enclosed property in a text editor e.g. {{password}}, and then did a copy and pasted that into the password field.

     

    Cheers,

    Danny