Forum Discussion

rad's avatar
rad
Occasional Contributor
8 years ago

Hello , I recently upgraded to soap15.3 version and some of my JDBC test cases are failing

I have some test cases with JDBC test steps. Some of the JDBC tests are suddenly failing

 

select * from tblAssignedExternalAccounts where FKAccountNumber=17
select * from tblExternalProducts  where ExternalProductsKeyId=15

 

If I remove the second line it returns the response fine, but with this, I keep getting  java.sql.SQLException: ResultSet is closed.

 

I have lot of tests with this type of queries . Please suggest!. I am using ODBC driver for connections

 

Driver: sun.jdbc.odbc.JdbcOdbcDriver

Connection string: jdbc:odbc:{Driver name configured}

 

I use SqlServer database

3 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    Can you retry with older version of soapui when you it is not working after upgrade? That at least helps to confirm the same.

    Also look at other perspective such any environment changes happened to application and its dependencies at the same time.
    • rad's avatar
      rad
      Occasional Contributor
      8 years ago

      Thanks for your reply! I do not have an older version of soapui. I could not find it in the website too. I cant think of any environmental change . Any idea what I should be looking for?

    • rad's avatar
      rad
      Occasional Contributor
      8 years ago

      I managed to find an older version (15.2.1) and installed in my Virtual machine  and I can confirm that it worked in there.