0 Replies Latest reply on Jul 10, 2012 7:50 PM by ravichandrankg

    Reg Birt Report Setup in JBPM5.3

    ravichandrankg

      Hi All,

       

      I am very newbie to JBPM5. In my application, I am trying to connect mySQL db (which installed in local m/c) as the persistence unit and Birt reporting (included in Jbpm-console by default) for reports. I have installed the JBPM5.3 in Jboss5.1, as instructed in the docs.

       

      I have changed the following files for MySQL DB use.

       

      1) db\jBPM-ds.xml :

       

      <local-tx-datasource>

          <jndi-name>jboss/datasources/jbpmDS</jndi-name>

          <connection-url>jdbc:mysql://localhost:3306/jbpm_try</connection-url>

          <driver-class>com.mysql.jdbc.Driver</driver-class>

          <user-name>admin</user-name>

          <password>mysql</password>

        </local-tx-datasource>

       

      2) db\persistence.xml and db\persistence-as5.xml

       

      ...

      <properties>

            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

            <property name="hibernate.max_fetch_depth" value="3"/>

            <!-- hbm2ddl.auto MUST BE update! The console will otherwise overwrite the schema with each new thread -->

            <property name="hibernate.hbm2ddl.auto" value="update" />

            <property name="hibernate.show_sql" value="false" />

       

       

            <!-- for AS7 -->

            <!--<property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" />-->

            <!-- for AS5 -->

            <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />

          </properties>       

      ...

       

      3) task-service\resources\META-INF\persistence.xml

       

      ...

      <persistence-unit name="org.jbpm.task">

          <provider>org.hibernate.ejb.HibernatePersistence</provider>

          <mapping-file>META-INF/Taskorm.xml</mapping-file>

      ...

      <properties>

            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

            <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>

            <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/jbpm_try" />

            <property name="hibernate.connection.username" value="root"/>

            <property name="hibernate.connection.password" value="mysql"/>

            <property name="hibernate.connection.autocommit" value="false" />

            <property name="hibernate.max_fetch_depth" value="3"/>

            <property name="hibernate.hbm2ddl.auto" value="create" />

            <property name="hibernate.show_sql" value="false" />

          </properties>

      ...

       

      4) Report file in reprt\overall_activity.rptdesign

       

          <data-sources>

              <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="ProcessInstanceLog" id="25">

                  <property name="odaDriverClass">com.mysql.jdbc.Driver</property>

                  <property name="odaURL">jdbc:mysql://localhost:3306/jbpm5</property>

                  <property name="odaUser">root</property>

                                    <property name="odaPassword">mysql</property>

              </oda-data-source>

          </data-sources>

       

      5) Run the command : ant install.demo.db

       

      6) changed the jboss-5.1.0.GA\server\default\conf\bootstrap\profile.xml to include the class parameter "java.io.File" in attachmentStore properties (Seems, Jboss start up issue)

       

      7) updated the jboss-5.1.0.GA\server\default\deploy\jbpm-human-task-war.war\WEB-INF\classes\META-INF\persistence.xml to have MYSQL DB Dialect.

       

      8) Run the command ant start.demo.db

       

       

      Now the server is coming up with few exceptions (Which given at the end of this post). And in jbpm-console, i am trying to create the Reports from reporting tab. There i am getting following exception.

       

      2012-07-10 11:51:57,263 SEVERE [org.eclipse.birt.report.engine.api.impl.ReportEngine] (http-localhost%2F127.0.0.1-8080-3) 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.

      There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).

      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.

      There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).

                at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:493)

                at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)

                at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)

                at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)

                at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:204)

                at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)

                at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61)

                at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)

                at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)

                at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)

                at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)

                at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)

                at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)

                at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)

                at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)

                at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)

                at org.jboss.bpm.report.BirtService.render(BirtService.java:275)

                at org.jboss.bpm.report.ReportFacade.renderReportHtml(ReportFacade.java:217)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                at java.lang.reflect.Method.invoke(Method.java:601)

                at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)

                at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                at java.lang.Thread.run(Thread.java:722)

      Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.

      There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).

                at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:169)

                at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)

                at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)

                at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)

                at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)

                at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)

                at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)

                at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)

                at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)

                at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)

                at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)

       

      Can you please help me to get rid of this issue, in which i got stucked for long.

       

       

      Also i am getting few exceptions while starting the server, those i have attached.

       

      Your help on my issues will be very thankful and great.

       

      Thanks in advance,

       

      Ravichandran