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 ...
  • 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