SQL Server connection hang or timeout with jTDS driver

• Louis Lam-391748

  Ten Centuries

  Points: 1083

  More actions

  August 27, 2015 at 4:04 pm

  #303809

  Hi All,

  Have anyone experience this problem with connecting to SQL Server using jTDS driver before? When SSL is enable on SQL Server (Force Encryption = Yes). Connecting to SQL Server via JDBC using the open source driver jTDS driver take a while and eventually hang or timeout. I tried using jtds-1.2.8-dist and jtds-1.3.1-dist. In the connection property, I added "ss=request". I also tried with "ssl=require".

  I am using SQL Server 2012 SP2 and SQL Server 2014 SP1. Samething happen in SQL Server 2005 as well.

  I am using this JAVA version "ibm-java-x86_64-sdk-7.0-9.10"

  I am wondering if anyone has experience this problem before and if there is any work around in the Driver connection property or JAVA setting, etc.

  I know this used to work for me when we where using "ibm-java-x86_64-sdk-7.0-8.0"

  This is my connection string:

  net.sourceforge.jtds.jdbc.Driver

  jdbc:jtds:sqlserver://fqdn:1433/master;USENTLMV2=true;SSL=request;

  Regards,

  Louis