Hi Dragica,
I have downloaded the latest nightly build “Build soapui-pro-daily-2010-07-02-[1], Build Date 2010/07/02 06:09”, but still I am facing the same issue. Detailed explanation of the issue is as follows:
Step 1: Import “TestJdbcRequest-soapui-project.xml” soapUI project [Please find it in the attachment].
Step 2: Under Project-> JDBC Connections, you will find a jdbc connection named as TestConnection. Do not delete it. Double Click on it and you will find out Database as “TestJdbcReqDb”.
Create a database named as “TestJdbcReqDb” in Sql Server 2005 and execute the script present inside “TestJdbcReqDb_Person_Table.txt” [Please find this script in the attachment].
You can change Host, Port, User, and Password according to your convenience.
Step 3: Till now, please do not click on test case as well as “JDBC Request” present inside it. Under Project -> TestSuites, you can run the test suite. It will pass.
Step 4: Delete the database “TestJdbcReqDb” from sql server and create a database named as “NewTestJdbcReqDb” in Sql Server 2005 and execute the script present inside “NewTestJdbcReqDb_Person_Table.txt” [Please find this script in the attachment].
Step 5: Till now, please do not click on test case as well as “JDBC Request” present inside it. Go to Project-> JDBC Connections and double Click on TestConnection and change the database name from “TestJdbcReqDb” to “NewTestJdbcReqDb”. Execute the test connection and click Ok on success.
Step 6: Under Project -> TestSuites, you can run the test suite. It will fail. Now you can just click on test case as well as “JDBC Request” present inside it. After clicking JDBC Request, do not click anywhere. You will find Connection as “TestConnection”. Now you can run the test suite and it will pass.
Right now it is something like, you change the database name under Project-> JDBC Connections and after that you need to click on each “JDBC Request” present inside a TestCase across the different TestSuites for its successful execution inside a soapUI project. Can you help me out regarding this issue?
Regards,
Tony
