TLS error for Microsoft JDBC Driver Type 4 Connection to SQLServer
Issue
server.logentries 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-datasourcesimilar 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.xmlhas 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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
