Web Service and SOA Testing - the leaders- eviware

Main Menu

Home

Customer Area

Welcome, Guest. Please login or register.
November 22, 2008, 10:02:56 am

Forgot your password?

Setting the query of a JDBC datasource dynamically in TestCase setupScript

	Welcome, Guest. Please login or register. November 22, 2008, 10:02:56 am

News: The Forums are up! Welcome to eviware.

Eviware Forum

soapUI

Setting the query of a JDBC datasource dynamically in TestCase setupScript

« previous next »

Pages: [1]

Author

Topic: Setting the query of a JDBC datasource dynamically in TestCase setupScript (Read 354 times)

Tareque
Newbie

Posts: 17

Setting the query of a JDBC datasource dynamically in TestCase setupScript

« on: January 31, 2008, 08:48:39 pm »

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")


	Logged

omatzura
Administrator
Hero Member

Posts: 1,425

Re: Setting the query of a JDBC datasource dynamically in TestCase setupScript

« Reply #1 on: January 31, 2008, 11:52:41 pm »

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


	Logged

Tareque
Newbie

Posts: 17

Re: Setting the query of a JDBC datasource dynamically in TestCase setupScript

« Reply #2 on: February 01, 2008, 05:30:06 pm »

Thanks Ole. You suggestions as always was spot on.


	Logged

Pages: [1]

« previous next »