TLS error for Microsoft JDBC Driver Type 4 Connection to SQLServer
Issue
server.log
entries similar to
Server chose TLSv1, but that protocol version is not enabled or not supported by the client
Environment
- Red Hat JBoss SOA Platform 5.3.1
local-tx-datasource
similar to
<local-tx-datasource>
<jndi-name>DS</jndi-name>
<use-java-context>true</use-java-context>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<connection-url>jdbc:sqlserver://<host>;databaseName=<db></connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<connection-property name="encrypt">true</connection-property>
<connection-property name="trustServerCertificate">true</connection-property>
<connection-property name="trustStore">/path/to/keystore/XXXXX</connection-property>
<connection-property name="trustStorePassword">ZZZZZ</connection-property>
<min-pool-size>0</min-pool-size>
<max-pool-size>55</max-pool-size>
<idle-timeout-minutes>2</idle-timeout-minutes>
<blocking-timeout-millis>50000</blocking-timeout-millis>
<check-valid-connection-sql>SELECT 1 FROM sysobjects</check-valid-connection-sql>
<security-domain>domain</security-domain>
</local-tx-datasource>
server.xml
has following config for http connector
<Connector protocol="HTTP/1.1" SSLEnabled="true" ciphers="TLS_RSA_WITH_AES_256_CBC_SHA256,TLS_RSA_WITH_AES_256_CBC_SHA,TLS_RSA_WITH_AES_128_CBC_SHA,SSL_RSA_WITH_RC4_128_MD5,TLS_RSA_WITH_RC4_128_MD5,SSL_RSA_WITH_RC4_128_SHA,TLS_RSA_WITH_RC4_128_SHA"
port="8443" address="${jboss.bind.address}"
scheme="https" secure="true" clientAuth="false"
keystoreFile="/path/to/keystore/XXXXX"
keystorePass="YYYYYYY" sslProtocols = "TLSv1.1,TLSv1.2" />
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.