August 27, 2015 at 4:04 pm
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
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy