Problem connecting to MySQL from Tibco BW 5.11.
Article ID: KB0089016
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Description:
MySQL connection fails with BW 5.11. With BW 5.11 it throws "JDBC Connection Login TImed Out". The same worked fine with the previous version of Tibco Active Matrix BW 5.7. The following URL format works with BW 5.7 but fails with BW 5.11 .
jdbc:tibcosoftwareinc:sqlserver://<server>:51401;databaseName=<dbname>
Test connection throws the following error.
"BW-JDBC-100034 "Configuration Test Failed. Exception [java.sql.SQLNonTransientConnectionException] occurred.
java.sql.SQLNonTransientConnectionException:
[tibcosoftwareinc][SQLServer JDBC Driver]Conflicting connection
information.
Symptoms:
JDBC Connection Login TImed Out error is thrown during the test connection. The same works with previous version of BW products.
Cause:
The issue was caused by an invalid MYSQL URL.
Resolution
When the instance name is specified, do not specify the port number. Remove the port number from the URL.
Issue/Introduction
Problem connecting to MySQL from Tibco BW 5.11.
Feedback
Yes
No
Powered by
