Load Native JDBC Library

[adamretter]

Some JDBC drivers require a native library component, for example MSSQL JDBC Driver when using Integrated Authentication.

This can be done by placing sqljdbc_auth.dll from the MSSQL JDBC zip download into D2RQ's lib\ folder, alongside mssql-jdbc-7.4.1.jre8-shaded.jar.

D2RQ's startup scripts then need a small modification to see the native library. For example, I changed the following line in generate-mapping.bat from:

java -cp %CP% -Xmx1G "-Dlog4j.configuration=%LOGCONFIG%" d2rq.generate_mapping %*

to:

java -cp %CP% -Xmx1G "-Dlog4j.configuration=%LOGCONFIG%" -Djava.library.path="%D2RQ_ROOT%lib" d2rq.generate_mapping %*

After which you can use Integrated Authentication via the JDBC connection string:

jdbc:sqlserver://localhost;databaseName=MyDb;integratedSecurity=true;