Forum Discussion

Prabaharan's avatar
Prabaharan
Contributor
5 years ago

Unable to save the JDBC test step request through groovy

Hi All,   I have created a JDBC test step and grrovy script test step to save the jdbc request and response automatically. I was able to save the jdbc response as per expectation but not the re...
JHunt's avatar
JHunt
Community Hero

Try this:

def request = context.testCase.testSteps['JDBCQuery'].query

 

JHunt's avatar
JHunt
Community Hero
5 years ago

Or this:

def request = context.testCase.testSteps['JDBCQuery'].jdbcRequest.requestContent
  • Prabaharan's avatar
    Prabaharan
    Contributor
    5 years ago

    Hi JHunt,

     

    Thanks for your quick reply. Both your script works fine for saving the JDBC request to a file.

     

    But I have implemented this project as a data driven for which few the values are fetched from an external file. The dynamic values are stored as a jdbc parameters.

     

    Your scipt works fine for saving the jdbc request but saving the query without dynamic values.

    Kindly refer the attachments.

     

    • JHunt's avatar
      JHunt
      Community Hero
      5 years ago

      I checked the source code, and there is no available method you can call to get the query including the values. The values are added to a PreparedStatement in the middle of a protected method.

       

      PreparedStatement is used to protect your database. Since they are designed to get around the limitations, and especially the risks, of using only Strings to send data to your database, it's not possible to convert them to String form.

      • Prabaharan's avatar
        Prabaharan
        Contributor
        5 years ago

        JHunt, Appreciate your help and timely response. 

        Let me know if there are any work around for this.