Resolution:
Description
=========
 ojdbc6.jar and JRE 1.6 are used in Designer. The JDBC connection over SSL fails with the following error:

java.sql.SQLException: IO Error:Received fatal alert bad_record_mac

Environment
==========
ALL

Resolution
=========
If both Designer and BW use JRE 1.6, you need to use the ojdbc6.jar for the Oracle thin driver. Make sure the JAR is in Designer and the BW classpath. You also need to set the trust store and key store using  the following properties in designer.tra and bwengine.tra:

java.property.javax.net.ssl.trustStore
java.property.javax.net.ssl.trustStoreType
java.property.javax.net.ssl.trustStorePassword
java.property.javax.net.ssl.keyStore
java.property.javax.net.ssl.keyStoreType
java.property.javax.net.ssl.keyStorePassword

Test connection. If the connection fails with the error, "java.sql.SQLException: IO Error:Received fatal alert bad_record_mac", you should change the security vendor to j2se using the property:

java.property.TIBCO_SECURITY_VENDOR=j2se

JDBC connection over SSL fails in Designer. Error:java.sql.SQLException: IO Error:Received fatal alert bad_record_mac