Unable to load JDBC driver for BIRT report
![]()
Problem :
I have created sample tables with data in MySQL DB. I have created BIRT report design on this DB as Data source.
I deployed it in the RTC.
I followed steps mentioned in the below link still,
http://www-01.ibm.com/support/docview.wss?uid=swg21586908
I am not able to solve the JDBC error .
The following items have errors:
Table (id = 76):
+ An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver.
Please do provide me solution, suggestions where i could be going wrong , working on it from many days not able to solve it.
|
5 answers
![]()
@donald I have installed MySQL Db locally (local instance) which i keep running.
I tried to add screen shot but it was not possible so please find the below details
when i unzipped the org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127 jar below are the contents
drivers -Folder
META-INF - Folder
schema - Folder
oda-jdbc -jar
plugin -xml
plugin.properties -file
has below jar file
mysql-connector-java-5.0.8-bin
|
![]()
Double check what you have done according to technote #1586908. I have verified that the steps are correct and I only need to do the CCM parts. I set a data source to a nonexistent MySQL database in a report design and uploaded it to my RTC server. Before adding the MySQL JDBC drivers as per technote #1586908, I got the same "cannot load JDBC driver" error when running the report. After adding the driver, I got a "connection refused" error instead (apparently the driver was load and BIRT tried to connect to the database).
Comments @Donald Nong I am interested to know whether possible to use Mongo DB as external data base where I will store some data related to baseline of component. To report over this data base from RTC .Using report template which will be formed from BIRT application and deployed in RTC. Support for Mongo DB was introduced in BIRT 4.3.
@
|
![]()
@ Donald Nong I followed steps in this http://www-01.ibm.com/support/docview.wss?uid=swg21586908
but in step 12 when I do
./repotools-ccm.sh -clean -version
./repotools-jts.sh -clean -version, I am getting below error
2015-09-24 13:23:41,447 CRJAZ0287I Das Paket "file:/D%3a/RTC50~1.2/IBM/JTS/server/conf/ccm/sites/update-site/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127.jar" konnte nicht installiert werden.
org.osgi.framework.BundleException: Fehler beim Konvertieren des Plug-ins bei D:\RTC.5.0.2\IBM\JTS\repotools\ccm\eclipse\configuration\org.eclipse.osgi\bundles\521\1\bundlefile.
at org.eclipse.core.runtime.internal.adaptor.EclipseStorageHook.generateManifest(EclipseStorageHook.java:446)
at org.eclipse.core.runtime.internal.adaptor.EclipseStorageHook.getGeneratedManifest0(EclipseStorageHook.java:423)
at org.eclipse.core.runtime.internal.adaptor.EclipseStorageHook.getGeneratedManifest(EclipseStorageHook.java:393)
Caused by: org.eclipse.osgi.service.pluginconversion.PluginConversionException: META-INF/MANIFEST.MF, plugin.xml oder fragment.xml wurde in D:\RTC.5.0.2\IBM\JTS\repotools\ccm\eclipse\configuration\org.eclipse.osgi\bundles\521\1\bundlefile nicht gefunden.
at org.eclipse.core.runtime.internal.adaptor.PluginConverterImpl.fillPluginInfo(PluginConverterImpl.java:110)
Caused by: java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
2015-09-24 13:23:41,455 CRJAZ0288E Das Profilfeature "com.ibm.team.jazz.foundation.server.jfs.feature" konnte nicht von der Updatesite "file:ccm/sites/update-site" installiert werden, auf die in der Profildatei "D:\RTC.5.0.2\IBM\JTS\server\conf\ccm\provision_profiles\profile.ini" verwiesen wird.
Comments The error is "java.util.zip.ZipException: error in opening zip file". Check file permission and make sure the zip file is valid.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.
Comments
Can you please show the current content of the following file?
server/conf/ccm/sites/update-site/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.2.r262_v20110127.jar