Forum Discussion

Tareque's avatar
Tareque
Occasional Contributor
17 years ago

Setting the query of a JDBC datasource dynamically in TestCase setupScript

Hi,
Is it possible to set the query for a JDBC DataSource dynamically through the SetUp script of a TestCase?

I have to fetch the query from a DB in the SetUp script and set it in the dataSource which has already been created

def dataSource = testRunner.getTestCase().getTestStepByName("DataSource")

2 Replies

  • omatzura's avatar
    omatzura
    Super Contributor
    Hi Tareque,

    sure! Create a property at either the TestCase level or in a Properties-step, initialize that property in your setup-script (or any other way), and then expand it in your query. So if you create a property called "sqlQuery" at the TestCase level, then you can expand it with ${#TestCase#sqlQuery}

    Hope this helps!

    regards,

    /Ole
    eviware.com
  • Tareque's avatar
    Tareque
    Occasional Contributor
    Thanks Ole. You suggestions as always was spot on.