JTDS Driver Install For Connector Appliance 6.1/6.2

JTDS Driver Install For Connector Appliance 6.1/6.2

Connector Appliance 6.1 / 6.2 quick notes for upload of JTDS driver for connection to Microsoft SQLServer database. Quick, dirty and not complete. But some notes nonetheless. Hope they are of some use.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Comments

Typo on page 7:

The jdbc url connection string must start with "jdbc", not "Jdbc".

Oh, another typo on page 5:

The class is "net.sourceforge.jtds.jdbc.Driver" not "net.sourceforce.jtds.jdbc.Driver"

Thanks for documenting this for posterity! Hopefully it does not get lost as did my (much quicker) notes in some forum post some years ago...

Joachim

Thank for the helpful post.  I ended up using jtds v1.2.7 for a MSSQL Flexconnector to a MSSQL 2008 R2 database that required windows authentication and TLS encryption.  A couple things to add:

- For databases requiring encryption, you must add the public certificate from the database server to the NSSDB (via the container certificates wizard), then add ;ssl=request or ;ssl=require to the connection string

- The container would not start up with versions beyond 1.2.7, I'm not sure if there is a way to bypass this

- The BEAST fix in Java causes problems connecting with the JTDS driver on databases requiring encryption (see: jTDS not connecting with SQL Server 2008 R2 SP2... | Oracle Community), this check can be turned off by adding the following to the agent.wrapper.conf file:

wrapper.java.additional.7=-Djsse.enableCBCProtection=false

From my understanding, BEAST is a server side fix.  So assuming that the DBAs have disabled TLS v1.0, the connection should use a non-vulnerable protocol TLS 1.1/1.2.  I'm not positive on this and haven't confirmed so you may want to do your own research.

Top Contributors
Version history
Revision #:
3 of 3
Last update:
‎2017-08-25 08:10
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.