How to use Prepared Properties inside SQL Query
Hello,
In soapui Pro I am using DataSource JDBC to connect to a Oracla Database.
The connections is working good. I'm also able to get the right data from the Database by using SQL query.
Each time I have to make a connection I also have to change my SQL query to get the latest data and now I am doing that manually. I would like to automate that by using a variable in the SQL query. So I defined a global variable in the testsuite properties, but I dont know how to invoke it in the SQL query. (see my code)
I've search a lot but I cant find a way to do that. In the same winodow of DataSource: JDBC I see prepared Properties but I dontknow how to define that.
Does anybody know how to slove this issue? Thanks in advanced.
Simon
Select inorder.WEGAID, inorderline.WHOLESALEPID
From inorder, inorderline
Where inorder.ID = inorderline.ID And (inorder.CORRELATIONID =
'TestRun9_20-04-11') // this statment I would like to replace it by a variable "$correlationId" which is defined in the testsuite properties
In soapui Pro I am using DataSource JDBC to connect to a Oracla Database.
The connections is working good. I'm also able to get the right data from the Database by using SQL query.
Each time I have to make a connection I also have to change my SQL query to get the latest data and now I am doing that manually. I would like to automate that by using a variable in the SQL query. So I defined a global variable in the testsuite properties, but I dont know how to invoke it in the SQL query. (see my code)
I've search a lot but I cant find a way to do that. In the same winodow of DataSource: JDBC I see prepared Properties but I dontknow how to define that.
Does anybody know how to slove this issue? Thanks in advanced.
Simon
Select inorder.WEGAID, inorderline.WHOLESALEPID
From inorder, inorderline
Where inorder.ID = inorderline.ID And (inorder.CORRELATIONID =
'TestRun9_20-04-11') // this statment I would like to replace it by a variable "$correlationId" which is defined in the testsuite properties
