BIRT Exchange Forum: Error executing a dataobject - java.lang.ClassNotFoundException: com.mysql.jdbc.Driver - BIRT Exchange Forum

Jump to content


 

BIRT Poll: To best make a table fill a pdf page before breaking (PL=page layout, PBI=page break interval) set:

PL: auto, PBI: 0PL: fixed, PBI: 0PL: auto, PBI: 1000000PL: fixed, PBI: 1000000
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Error executing a dataobject - java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Rate Topic: -----

#1 User is offline   xalperte Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 11
  • Joined: 07-June 12


Posted 08 June 2012 - 03:19 AM

Hi All,

I'm having problems running a data object from a datadesign, it seems that the mysql driver is not found.

The Actuate iServer version is: 11 Service Pack 3 (Build 110E111028)
The Reports Designer Professional version is: Versión: 11.0.4 Id. de compilación: 20120420

Before publish the file into the iServer I need to edit manually the file and change the report version from 3.2.23 to 3.2, because the iServer version do not accept that version of design files.

In the iServer, I already copied the "mysql-connector-java-5.1.20-bin.jar" in the following folders: (i was trying to see if the error was with the folder I was deploying the file)


This comes with the iServer installation:
  • ACSERVER_HOME/jar/BIRT/platform/plugins/com.actuate.data.oda.jdbc.drivers_11.0.3.v20111028/lib/mysql/mysql-comm-5.1.7.jar




These were installed by me:
  • ACSERVER_HOME/jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_2.6.3.v20111028-0207/drivers/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/jar/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/servletcontainer/iportal/WEB-INF/reportengines/engines/ess/lib/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/servletcontainer/iportal/WEB-INF/lib/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/resources/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/reportengines/lib/mysql-connector-java-5.1.20-bin.jar
  • ACSERVER_HOME/reportengines/engines/ess/lib/mysql-connector-java-5.1.20-bin.jar


That is the snippet of the Birt datadesign file where the Datasource is defined:

    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile" name="facileplan local" id="2">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.connectionProperties</name>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.oda.profile.db.provider.id</name>
                    <value>org.eclipse.datatools.enablement.mysql.connectionProfile</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.savePWD</name>
                    <value>true</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.drivers.defnType</name>
                    <value>com.actuate.data.oda.jdbc.dbprofile.mysql.5_1.driverTemplate</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.driverDefinitionID</name>
                    <value>DriverDefn.com.actuate.data.oda.jdbc.dbprofile.mysql.5_1.driverTemplate.Controlador MySQL 5.1 incluido en Actuate Valor predeterminado</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.version</name>
                    <value>5.1</value>
                </ex-property>
                <ex-property>
                    <name>org.eclipse.datatools.connectivity.db.vendor</name>
                    <value>MySql</value>
                </ex-property>
            </list-property>
            <property name="databaseName">invtur</property>
            <property name="username">invtur</property>
            <encrypted-property name="password" encryptionID="jce">bec7e687d9a6e4f7</encrypted-property>
            <property name="URL">jdbc:mysql://10.37.129.2:3306/invtur</property>
            <property name="driverClass">com.mysql.jdbc.Driver</property>
            <property name="jarList">C:\Archivos de programa\Actuate11\BRDPro\eclipse\plugins\com.actuate.data.oda.jdbc.drivers_11.0.4.v20120420\lib\mysql\mysql-comm-5.1.7.jar</property>
        </oda-data-source>
    </data-sources>




The stack-trace of the error is:
[Thread 11, 165] 2012-06-08 12:50:20 UTC+0200 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: An error occurred when executing the task.
Task :TaskID: 102
Task type: Report viewing
Task state: Finished
Task startup time: Fri Jun 08 12:50:20 CEST 2012
User name: advanced
Request type: 
Request ID: 
Volume name: facileplan
authid:cfMOutp7qK+qDyqlaw4yxQzrOsy2qfvATx1fEBRwP1fqE0POk0iPbE4DtAseHpRva5gRRFLUfdXBwZIzpvTlIx34poHAFGJC7aJmz3Q7Jq1n472NXIQrA3Fm4UScArHN
serverURI:http://spock-desktop:11100
MaxDuration:0com.actuate.reportapi.enginemanager.JREMException: Impossível exibir relatório. Causa: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:21)
.
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRenderTask.render(DashboardRenderTask.java:93)
    at com.actuate.reportapi.engine.birt.ViewReportTask.renderReport(Unknown Source)
    at com.actuate.reportapi.engine.birt.ViewReportTask.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.engine.api.EngineException: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:21)
.
    ... 6 more
[Thread 11, 165] 2012-06-08 12:50:20 UTC+0200 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: [Ljava.lang.StackTraceElement;@77399e
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Properties)()
WARNING: Unable to open a connection with the database connection profile.org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:118)
    at com.actuate.data.oda.jdbc.sqm.driver.impl.SqmProfileConnection.open(SqmProfileConnection.java:87)
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:62)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeDataSet(DatamartRunTask.java:417)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeSingleDataOjbect(DatamartRunTask.java:246)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.run(DatamartRunTask.java:184)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.generateDataSet(DataSetInterceptor.java:162)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:112)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:211)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:294)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:235)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare(DashboardInteractiveEngine.java:92)
    at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory$GenericJdbcConnection.open(JdbcConnectionFactory.java:181)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory.createConnection(JdbcConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
    at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
    at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
    at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection()
SEVERE: Unable to open connection.org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:118)
    at com.actuate.data.oda.jdbc.sqm.driver.impl.SqmProfileConnection.open(SqmProfileConnection.java:87)
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:62)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeDataSet(DatamartRunTask.java:417)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeSingleDataOjbect(DatamartRunTask.java:246)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.run(DatamartRunTask.java:184)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.generateDataSet(DataSetInterceptor.java:162)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:112)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:211)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:294)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:235)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare(DashboardInteractiveEngine.java:92)
    at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory$GenericJdbcConnection.open(JdbcConnectionFactory.java:181)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory.createConnection(JdbcConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
    at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
    at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
    at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare()
SEVERE: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driverorg.eclipse.birt.report.data.adapter.api.AdapterException: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:640)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeDataSet(DatamartRunTask.java:417)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeSingleDataOjbect(DatamartRunTask.java:246)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.run(DatamartRunTask.java:184)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.generateDataSet(DataSetInterceptor.java:162)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:112)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:211)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:294)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:235)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare(DashboardInteractiveEngine.java:92)
    at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    ... 23 more
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:118)
    at com.actuate.data.oda.jdbc.sqm.driver.impl.SqmProfileConnection.open(SqmProfileConnection.java:87)
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:62)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
    ... 33 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory$GenericJdbcConnection.open(JdbcConnectionFactory.java:181)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory.createConnection(JdbcConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
    at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
    at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
    at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute()
SEVERE: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs".org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs".
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:640)
    at org.eclipse.birt.report.engine.data.dte.DataInteractiveEngine.doExecuteQuery(DataInteractiveEngine.java:350)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
    at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to load Data Object data set "Total Companies Rent Generation - Jobs".
    at com.actuate.birt.data.impl.datamart.PreparedDataMartDataSourceQuery$DataMartQueryExecutor.createOdiQuery(PreparedDataMartDataSourceQuery.java:586)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:325)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at com.actuate.birt.data.impl.datamart.PreparedDataMartDataSourceQuery.produceQueryResults(PreparedDataMartDataSourceQuery.java:327)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    ... 20 more
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.engine.birt.BirtUtil.logBirtEngineError()
SEVERE: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver (Element ID:24) org.eclipse.birt.report.data.adapter.api.AdapterException: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver org.eclipse.birt.report.engine.api.EngineException: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver (Element ID:24)
    at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1214)
    at com.actuate.birt.report.engine.context.ActuateRunContext.addException(ActuateRunContext.java:43)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare(DashboardInteractiveEngine.java:97)
    at com.actuate.birt.report.engine.executor.GadgetReportExecutor.execute(GadgetReportExecutor.java:51)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportEmitterExecutor.execute(ReportEmitterExecutor.java:71)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:234)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:640)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeDataSet(DatamartRunTask.java:417)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.executeSingleDataOjbect(DatamartRunTask.java:246)
    at com.actuate.birt.report.engine.internal.datamart.DatamartRunTask.run(DatamartRunTask.java:184)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.generateDataSet(DataSetInterceptor.java:162)
    at com.actuate.birt.data.interceptors.datamart.DataSetInterceptor.preDefineDataSet(DataSetInterceptor.java:112)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.defineDataSet(DataRequestSessionImpl.java:211)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.doDefineDataSet(ModelDteApiAdapter.java:294)
    at org.eclipse.birt.report.engine.adapter.ModelDteApiAdapter.defineDataSet(ModelDteApiAdapter.java:235)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardInteractiveEngine.prepare(DashboardInteractiveEngine.java:92)
    ... 14 more
Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:54)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:177)
    at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
    at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
    at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:407)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:317)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    ... 23 more
Caused by: org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:118)
    at com.actuate.data.oda.jdbc.sqm.driver.impl.SqmProfileConnection.open(SqmProfileConnection.java:87)
    at org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:62)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
    ... 33 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
    at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:627)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory$GenericJdbcConnection.open(JdbcConnectionFactory.java:181)
    at com.actuate.data.oda.jdbc.dbprofile.impl.JdbcConnectionFactory.createConnection(JdbcConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:360)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
    at org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
    at org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
    at org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
    at org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
[Thread 11, 169] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.engine.birt.BirtUtil.logBirtEngineError()
SEVERE: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25) org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:70)
    at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
    at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
    at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
    at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
    at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
    at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
    at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:258)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.doRun(DashboardRunTask.java:553)
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRunTask.run(DashboardRunTask.java:280)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(Unknown Source)
    at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(Unknown Source)
    at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs".
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:640)
    at org.eclipse.birt.report.engine.data.dte.DataInteractiveEngine.doExecuteQuery(DataInteractiveEngine.java:350)
    at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
    at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
    ... 16 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to load Data Object data set "Total Companies Rent Generation - Jobs".
    at com.actuate.birt.data.impl.datamart.PreparedDataMartDataSourceQuery$DataMartQueryExecutor.createOdiQuery(PreparedDataMartDataSourceQuery.java:586)
    at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:325)
    at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
    at com.actuate.birt.data.impl.datamart.PreparedDataMartDataSourceQuery.produceQueryResults(PreparedDataMartDataSourceQuery.java:327)
    at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
    at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:620)
    ... 20 more
[Thread 11, 170] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.engine.birt.ViewReportTask.doTask()
WARNING: ViewReportTask: class org.eclipse.birt.report.engine.api.EngineExceptionorg.eclipse.birt.report.engine.api.EngineException: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRenderTask.render(DashboardRenderTask.java:93)
    at com.actuate.reportapi.engine.birt.ViewReportTask.renderReport(Unknown Source)
    at com.actuate.reportapi.engine.birt.ViewReportTask.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
[Thread 11, 170] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: Impossível exibir relatório. Causa: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.com.actuate.reportapi.enginemanager.JREMException: Impossível exibir relatório. Causa: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRenderTask.render(DashboardRenderTask.java:93)
    at com.actuate.reportapi.engine.birt.ViewReportTask.renderReport(Unknown Source)
    at com.actuate.reportapi.engine.birt.ViewReportTask.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.engine.api.EngineException: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.
    ... 6 more
[Thread 11, 170] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: An error occurred when executing the task.
Task :TaskID: 112
Task type: Report viewing
Task state: Finished
Task startup time: Fri Jun 08 12:51:41 CEST 2012
User name: advanced
Request type: 
Request ID: 
Volume name: facileplan
authid:cfMOutp7qK+qDyqlaw4yxQzrOsy2qfvATx1fEBRwP1fqE0POk0iPbE4DtAseHpRva5gRRFLUfdXBwZIzpvTlIx34poHAFGJC7aJmz3Q7Jq1n472NXIQrA3Fm4UScArHN
serverURI:http://spock-desktop:11100
MaxDuration:0com.actuate.reportapi.enginemanager.JREMException: Impossível exibir relatório. Causa: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.
    at com.actuate.birt.report.engine.internal.dashboard.DashboardRenderTask.render(DashboardRenderTask.java:93)
    at com.actuate.reportapi.engine.birt.ViewReportTask.renderReport(Unknown Source)
    at com.actuate.reportapi.engine.birt.ViewReportTask.doTask(Unknown Source)
    at com.actuate.reportapi.engine.Task.execute(Unknown Source)
    at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.report.engine.api.EngineException: There are errors in the document: 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.dbprofile.
    org.eclipse.datatools.connectivity.oda.OdaException ;
    java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
An exception occurred during processing. Please see the following message for details:
Failed to load Data Object data set "Total Companies Rent Generation - Jobs". (Element ID:25)
.
    ... 6 more
[Thread 11, 170] 2012-06-08 12:51:41 UTC+0200 com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run()
WARNING: [Ljava.lang.StackTraceElement;@11ae567]


0

#2 User is offline   averma Icon

  • Senior Member
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 713
  • Joined: 08-August 07


Posted 11 June 2012 - 09:52 AM

Hi xalperte,
I am not sure about manually changing the version information but your jdbc driver needs to go in the following directory location:
[iServer Install Dir]\Jar\BIRT\platform\plugins\org.eclipse.birt.report.data.oda.jdbc_[version]\drivers
Give it a go and let me know if that resolves the errors.
Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users