Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Running BIRT reports that connect to MySQL databases in SCTM 17.0 onwards

Running BIRT reports that connect to MySQL databases in SCTM 17.0 onwards

Problem:

When using the BIRT RCP Designer it is possible to design reports that pull data from multiple data sources or databases e.g. SQL Server, Oracle, MySQL and many more.

As long as the relevant JDBC driver for the database is installed on the machine then BIRT is able to access it when you add the JDBC driver jar file via the “New Data Source” Wizard. For further information on this please check the BIRT help files.

However as SCTM only supports SQL Server and Oracle you may get an error message similar to that shown below when you try to run a BIRT report that uses a different database than these from inside SCTM:

“Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
Cannot load JDBC Driver class: com.mysql.jdbc.Driver.”

The reason for this error is because SCTM does not have access to the relevant JDBC driver for the data source or database in use by the report. In this case the error message is referring to the MySQL JDBC driver.

Resolution:

For Silk Central 17.0 and later, copy the JDBC driver (tested with mysql-connector-java-5.1.37-bin.jar) 

to the lib/CS folder of the Silk Central instance,


\Silk\Silk Central 17.5\instance\lib\cs.


For example: C:\Program Files (x86)\Silk\Silk Central 17.5\instance_1_silk\lib\cs. 

You then need to restart the chart servers.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2016-11-25 12:43
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.