Forum Discussion

jkrolczy's avatar
jkrolczy
Regular Contributor
2 years ago

SoapUI 5.7.0: What latest Microsoft JDBC Driver for SQL Server to use for DB connection And Auth ?

All,

I would like to upgrade to the latest SoapUI 5.7.# … But I need to know from what I use below 

if there are newer files for JDBC DB connection And Auth.

 

I am currently using Open Source SoapUI 5.5.0 32-bit along with Microsoft JDBC Driver 6.0 for SQL Server
I am on a Win10 64-bit OS with java version 1.8.0_333

 

C:\Program Files (x86)\SmartBear\
SoapUI-5.5.0/jre/lib/sqljdbc42.jar
SoapUI-5.5.0/lib/sqljdbc42.jar
SoapUI-5.5.0/jre/bin/sqljdbc_auth.dll


I can currently do my needed SQL through my Groovy scripts and my REST request with Bearer authentication work fine as well.

 

I would like to upgrade to Open Source SoapUI 5.7.0 (which only 64-bit w/java seems to exists).

 

In doing so and I put my sqljdbc42.jar and sqljdbc_auth.dll (x64 version) in the same locations as SoapUI 5.5.0

everything does work correctly still except for this one line which I do not think is important ?

 

OpenJDK 64-Bit Server VM warning: Option --illegal-access is deprecated and will be removed in a future release.

 

If I move up in Microsoft JDBC Driver for SQL Server version:

 

https://docs.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-...

 

example: 10.2 version files: mssql-jdbc-10.2.1.jre8.jar / mssql-jdbc_auth-10.2.1.x64.dll

 

Placement of these 10.2 version files in the folder locations like I did with sqljdbc42.jar and sqljdbc_auth.dll

does not allow SoapUI 5.7.0 to work as I expect to should.

Database connection cannot be established.

 

Is there a change on how to define the groovy script DB_connection = Sql.newInstance("jdbc:sqlserver .... ?

Should the files be placed in different folder locations?

 

Anyone setup OS SoapUI 5.7.0 in a manner I am trying - but that works for SQL through Groovy scripts ?

 

Thanks

No RepliesBe the first to reply