Forum Discussion

poojas's avatar
poojas
Occasional Contributor
8 years ago

JDBC Request returning " Error getting response; null" in SOAPUI 5.3

I am trying to use JDBC Request in SOAPUI. But i am getting " Error getting response; null" error.

 

I Installed driver,copied required .jar and auth.dll to required location of SOAP but still its failing for me.

 

But if i try the same JDBC request in ReadyAPI(Trial Version) its working.

  • PaulMS's avatar
    PaulMS
    8 years ago

    I'm using Windows 7 but the driver might work with Windows 10.

     

    Remove any other JDBC versions from Program Files\SmartBear\SoapUI-5.3.0\bin\ext because there could be a conflict.

    Close and reopen SoapUI.

    If error still occurs maybe run SoapUI in compatibility mode for Windows 7.

    • poojas's avatar
      poojas
      Occasional Contributor
      8 years ago

      Thanks..

       

      I have downloaded sqljdbc4.jar as you mentioned but still its giving me same issue.

       

      I can see System requirement for Microsoft JDBC Driver 4.0 for SQL Server as below: 

       

      Supported Operating System

      Linux, Unix, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Vista Service Pack 1

       

       

      And i am using Windows 10.So JDBC request is failing due to unsupported OS ?  Do we have any other solution to work this on Windows 10 and required .jar for SOAP UI 5.3?

       

      Thanks for your help.

       

      • PaulMS's avatar
        PaulMS
        Super Contributor
        8 years ago

        I'm using Windows 7 but the driver might work with Windows 10.

         

        Remove any other JDBC versions from Program Files\SmartBear\SoapUI-5.3.0\bin\ext because there could be a conflict.

        Close and reopen SoapUI.

        If error still occurs maybe run SoapUI in compatibility mode for Windows 7.

    • poojas's avatar
      poojas
      Occasional Contributor
      8 years ago

      Hi Paul,

       

      It now working with your solution. Even thought Windows 10 not mentioned under supported OS for JDBC Driver 4 but still its working for me with fresh install of SOAP 5.3

       

      Initially it gave me error : S Error getting response; java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

       

      As i copied both .jar filed (sqljdbc.jar and sqljdbc4.jar) under C:\Program Files\SmartBear\SoapUI-5.3.0\bin\ext.By removing sqljdbc.jar file and keeping only sqljdbc4.jar finally my JDBC Request runs successfully :)

      Thank You for your help.

      PaulMS wrote:

      Soap UI 5.3 doesn't seem to work with sqljdbc42.jar version that is installed by ReadyAPI.

       

      sqljdbc4.jar should work - download https://www.microsoft.com/en-us/download/details.aspx?id=54629