Forum Discussion

Tony_Sheng's avatar
Tony_Sheng
Occasional Contributor
16 years ago

Is configuration of JDBC Request is cached by SoapUI Pro3.5.1?

Hi,
      I have created a TestDB Connection under Project -> JDBC Connections. The same connection is been used by all the JDBC requests. If i try to change the database name under Project -> JDBC Connections, it does not get reflected back at JDBC request under different tests cases.
      But if you go to independent JDBC request, and click on Configure button, then changes get applied for the request.
    I am having no idea that what is happening? I am using [soapUI Pro 3.5.1, Build dist-97-2010-04-12, Build Date 2010/04/12 09:51].

regards,
  Tony

7 Replies

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi,

    This definitely shouldn't be the case.
    Could you please double check if on particular JDBC Request TestStep you have the same connection name set or if just the settings are same.
    Please try downloading the latest nightly-build from http://www.eviware.com/nightly-builds/soapui-pro/3.5/ and let us know if there is any difference?

    Regards,
    Dragica
    /eviware.com
  • Tony_Sheng's avatar
    Tony_Sheng
    Occasional Contributor
    15 years ago
    Hi Dragica,
    Still I am facing the same issue. I mailed you regarding this but still no reply. I have given the detailed explanation on this but its been removed from the forum. I don't know why?

    regards,
    Tony
  • Tony_Sheng's avatar
    Tony_Sheng
    Occasional Contributor
    15 years ago
    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
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    15 years ago
    Hi,

    sorry to keep you waiting on this, I'll be on to it over the weekend, hopefully fixed until monday. I'll let you know.

    regards!

    /Ole
    eviware.com
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    15 years ago
    Hi,

    I'm very sorry for keeping you waiting for so long. Upcoming nightly build should contain fix for this.
    Please try it and let us know if it worked for you.

    Rergards,
    Dragica
    /eviware.com
  • Tony_Sheng's avatar
    Tony_Sheng
    Occasional Contributor
    15 years ago
    Hi Dragica,
    I tried Build soapui-pro-daily-2010-07-08-[1], Build Date 2010/07/08 06:21 and now it's working fine for me.

    Thanks & regards,
    Tony