shreyaskn - 2014-01-02

Hi All,

Is there a way to pass the our own implementation of sslsocketFactory while trying to connect to MSSQL using net.sourceforge.jtds.jdbc.Driver driver using {ssl:request} as the argument.

Due to security constraints our product can only talk TLSv1.2 but the MSSQL seems to use only TLSv1.

So the handshake is always failing and we are unable to connect to MSSQL, we can make a excuse if the MSSQL is talking only TLSv1, but for this we need to create an isolated socketFactory which can talk any TLS version only to connect to MSSQL.

I wrote a sample program to print ssl handshake (-Djavax.net.debug=ssl) from which i could conclude that MSSQL was talking only TLSv1.

Any help would be of great help.

There is a way to do it in mysql buy passing class name of our implementation of sslSocketFactory to connection properties, is there anything similar in JTDS driver.
propertyName: socketFactory
Description: The name of the class that the driver should use for creating socket connections to the server. This class must implement the interface 'com.mysql.jdbc.SocketFactory' and have public no-args constructor.
Default Value: com.mysql.jdbc.StandardSocketFactory
Since version: 3.0.3

-THanks in advance

Shreyas