Forum Discussion

sclavell's avatar
sclavell
Occasional Contributor
9 years ago

JDBC response changes everything to upper case with 1.9.0

I have many, many tests that get data from JDBC test steps to use as parameters in other test steps or for assertions.  Prior to release 1.9.0 these JDBC results returned column names in the same cas...
  • sclavell's avatar
    sclavell
    9 years ago

    Okay - I looked more closely at what your script is doing and realized there is now a checkbox in the JDBC test step for converting responses to upper case.  I hadn't noticed that was there.  I can go through each test and uncheck that box.  I appreciate your trying to automate that for me.

     

    Thanks,

AV's avatar
AV
SmartBear Alumni (Retired)
9 years ago

Hi, sclavell!

 

If you use Jdbc Request TestStep, please use next sript:

import com.eviware.soapui.impl.wsdl.WsdlTestSuite
import com.eviware.soapui.impl.wsdl.testcase.WsdlTestCase
import com.eviware.soapui.model.testsuite.TestStep
import com.eviware.soapui.support.StringUtils
import com.eviware.soapui.impl.wsdl.teststeps.JdbcRequestTestStep

context.getTestCase().getTestSuite().getProject().getTestSuiteList().each { WsdlTestSuite testSuite ->
    log.info("TestSuite: " + testSuite.getName())
    testSuite.getTestCaseList().each { WsdlTestCase testCase ->
        log.info("    TestCase: " + testCase.getName())
        testCase.getTestStepList().each { TestStep testStep ->
            if (testStep instanceof JdbcRequestTestStep)    {
                log.info("       TestStep: " + testStep.getName())
                JdbcRequestTestStep jdbcTestStep = (JdbcRequestTestStep)testStep
                jdbcTestStep.setConvertColumnNamesToUpperCase(false)
            }
        }
    }    
}

Paste it into Setup script of your project and run it. Afterwards remove it. Now everything should be Ok.

  • sclavell's avatar
    sclavell
    Occasional Contributor
    9 years ago

    Thanks for the response.  I tried what you suggest and got the following error:

     

    groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.panels.support.MockProjectRunContext.getTestCase() is applicable for argument types: () values: [] Possible solutions: getTestRunner(), getMetaClass()

     

    I tried changing it to context.getTestRunner().getTestCase()...  but got the same error.

    • sclavell's avatar
      sclavell
      Occasional Contributor
      9 years ago

      Okay - I looked more closely at what your script is doing and realized there is now a checkbox in the JDBC test step for converting responses to upper case.  I hadn't noticed that was there.  I can go through each test and uncheck that box.  I appreciate your trying to automate that for me.

       

      Thanks,

    • AV's avatar
      AV
      SmartBear Alumni (Retired)
      9 years ago

      sorry, my script was for Groovy TestStep, so context in Setup Script is not the same as for Groovy TestStep

      • AV's avatar
        AV
        SmartBear Alumni (Retired)
        9 years ago

        Hi, 

         

        just in case the correct script for project Setup script is 

         

        import com.eviware.soapui.impl.wsdl.WsdlTestSuite
import com.eviware.soapui.impl.wsdl.testcase.WsdlTestCase
import com.eviware.soapui.model.testsuite.TestStep
import com.eviware.soapui.impl.wsdl.teststeps.JdbcRequestTestStep

context.getProject().getTestSuiteList().each { WsdlTestSuite testSuite ->
    log.info("TestSuite: " + testSuite.getName())
    testSuite.getTestCaseList().each { WsdlTestCase testCase ->
        log.info("    TestCase: " + testCase.getName())
        testCase.getTestStepList().each { TestStep testStep ->
            if (testStep instanceof JdbcRequestTestStep)    {
                log.info("       TestStep: " + testStep.getName())
                JdbcRequestTestStep jdbcTestStep = (JdbcRequestTestStep)testStep
                jdbcTestStep.setConvertColumnNamesToUpperCase(false)
            }
        }
    }    
}

        Works for me well. 

         

        Happy testing!