Forum Discussion

DummyBear's avatar
DummyBear
Regular Visitor
10 years ago

jcbc test not working

Hi,

 

I am using SOAPUI 5.2.1 (not Pro) and I am trying to create JCBD test step. I get no message at all when pressing TestConnection in teststep window. Nothing. If I press teststep Play, I get message: 'Error getting response; null' in status bar. 

  

In jdbc configuration like in the pic. Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver and jdbc:sqlserver://xxxx:1435;databaseName=xxxx;integratedSecurity=true. I have used some SQL query in the window as well, which works ok in database manager.

jdbc conf

My database is Microsoft SQL Server 2012 (SP3), using Windows authentication. My system is Windows 8.1 Pro, Java version 1.8.0_77-b03.

 

I have downloaded MS JDBC drivers and installed sqljdbc42.jar into 

C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext and 

C:\Program Files\SmartBear\SoapUI-5.1.2\lib.  

Also sqljdbc_auth.dll (v64) is installed in

C:\Program Files\SmartBear\SoapUI-5.1.2\bin\ext\auth
C:\Program Files\SmartBear\SoapUI-5.2.1\bin\auth
C:\Program Files\SmartBear\SoapUI-5.1.2\bin

 

I have created the system CLASSPATH C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext\sqljdbc42.jar.

 

 

If I write OLD jdbc driver (for mssql server 2000): com.microsoft.jdbc.sqlserver.SQLServerDriver, I get an error:

com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.microsoft.jdbc.sqlserver.SQLServerDriver], connectionString [jdbc:sqlserver://xxx:1435;databaseName=xxx;integratedSecurity=true]

 

I don't know anymore, how to proceed. My colleage is using SOAPUi 5.1.2 and similar works for him ok. I have tried both with 5.0.0. version of soap and 5.2.1. No success.

3 Replies

Sort By
    • richie's avatar
      richie
      Community Hero
      8 years ago
      Copy Link

      I don't know if this will help or not, but I just scraped the following out of the default JDBC preferences in SoapUI Pro (ReadyAPI!) for mssqlserver

       

      jdbc:sqlserver://<HOST:127.0.0.1>:<PORT:1433>;databaseName=<DB>;user=<USER>;password=<PASSWORD>

       

      It also looks like your port is 1435 - rather than 1433 - I'm just asking just in case.

       

      I've had a lot of problems with connecting to several different databases in SoapUI cos of the connection string you need to use - there are normally alternatives defined out there, depending on the tool you're using and what variables you want to specify in the string.

       

      Anyway - I don't know if this will help, but if it doesn't google the mssqlserver thin driver connection strings and you'll see several alternatives.

       

      Cheers,

       

      richie