Resolution:
Description:
============

TIBCO BusinessWorks is not able to connect to an SQL Server after upgrading to JRE 6 Update 29 or later.

Symptoms:
========

TIBCO BusinessWorks fails to establish JDBC connection to SQL Server and throws the following error:

("JDBC error reported: (SQLState = 08S01) - com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset" ) exception when trying to access a database from a BusinessWorks process.  

Cause:
=====

JRE 6 Update 29 introduced a change which resulted in connection issues with SQL Server. Refer to the Microsoft website below for complete details:

http://support.microsoft.com/kb/2653857

Resolution:
==========

This issue is resolved by applying a service pack for Microsoft SQL Server. See the reference section below for downloading and applying the appropriate update. To work around this issue, use one of the following methods:

1). Use a version prior to JRE 6 Update 29.

2). Disable SSL record splitting at the JRE level by adding the following property in the deployed BW application .tra file:

    # When running under Sun/Oracle  (TIBCO_SECURITY_PROVIDER=j2se) or even IBM
    -Djsse.enableCBCProtection=false

Note: This workaround may have security implications.