<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Reg Birt Report Setup in JBPM5.3
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/ravichandrankg">ravichandrankg</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/747329#747329">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi All,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>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.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I have changed the following files for MySQL DB use.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>1) db\jBPM-ds.xml :</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><table border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;"><p> <local-tx-datasource></p><p>    <jndi-name>jboss/datasources/jbpmDS</jndi-name></p><p>    <connection-url>jdbc:mysql://localhost:3306/jbpm_try</connection-url></p><p>    <driver-class>com.mysql.jdbc.Driver</driver-class></p><p>    <user-name>admin</user-name></p><p>    <password>mysql</password></p><p>  </local-tx-datasource></p></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>2) db\persistence.xml and db\persistence-as5.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><table border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;"><p>...</p><p> <properties></p><p>      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/></p><p>      <property name="hibernate.max_fetch_depth" value="3"/></p><p>      <!-- hbm2ddl.auto MUST BE update! The console will otherwise overwrite the schema with each new thread --></p><p>      <property name="hibernate.hbm2ddl.auto" value="update" /></p><p>      <property name="hibernate.show_sql" value="false" /></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>      <!-- for AS7 --></p><p>      <!--<property name="hibernate.transaction.manager_lookup_class" value="org.jbpm.integration.console.JBPMTransactionManager" />--></p><p>      <!-- for AS5 --></p><p>      <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" /></p><p>    </properties>        </p><p>...</p></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>3) task-service\resources\META-INF\persistence.xml</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><table border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;"><p>...</p><p> <persistence-unit name="org.jbpm.task"></p><p>    <provider>org.hibernate.ejb.HibernatePersistence</provider></p><p>    <mapping-file>META-INF/Taskorm.xml</mapping-file></p><p>...</p><p><properties></p><p>      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/></p><p>      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/></p><p>      <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/jbpm_try" /></p><p>      <property name="hibernate.connection.username" value="root"/></p><p>      <property name="hibernate.connection.password" value="mysql"/></p><p>      <property name="hibernate.connection.autocommit" value="false" /></p><p>      <property name="hibernate.max_fetch_depth" value="3"/></p><p>      <property name="hibernate.hbm2ddl.auto" value="create" /></p><p>      <property name="hibernate.show_sql" value="false" /></p><p>    </properties></p><p>...</p></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>4) Report file in reprt\overall_activity.rptdesign</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><table border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;"><p>    <data-sources></p><p>        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="ProcessInstanceLog" id="25"></p><p>            <property name="odaDriverClass">com.mysql.jdbc.Driver</property></p><p>            <property name="odaURL">jdbc:mysql://localhost:3306/jbpm5</property></p><p>            <property name="odaUser">root</property></p><p>                              <property name="odaPassword">mysql</property></p><p>        </oda-data-source></p><p>    </data-sources></p></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>5) Run the command : ant install.demo.db</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>6) changed the <span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"> jboss-5.1.0.GA\server\default\conf\bootstrap\profile.xml </span><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">to include the class parameter "java.io.File" in attachmentStore properties (Seems, Jboss start up issue)</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">7) updated the <span style="font-family: Calibri, sans-serif; font-size: 15px;">jboss-5.1.0.GA\server\default\</span>deploy\jbpm-human-task-war.war\WEB-INF\classes\META-INF\persistence.xml to have MYSQL DB Dialect.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">8) Run the command ant start.demo.db</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">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.</span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><table border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;"><p>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:</p><p>Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.</p><p>There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).</p><p>org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:</p><p>Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.</p><p>There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).</p><p>          at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:493)</p><p>          at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:115)</p><p>          at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:79)</p><p>          at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:253)</p><p>          at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:204)</p><p>          at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)</p><p>          at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:61)</p><p>          at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:45)</p><p>          at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:45)</p><p>          at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:42)</p><p>          at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:63)</p><p>          at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)</p><p>          at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101)</p><p>          at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:211)</p><p>          at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:237)</p><p>          at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:90)</p><p>          at org.jboss.bpm.report.BirtService.render(BirtService.java:275)</p><p>          at org.jboss.bpm.report.ReportFacade.renderReportHtml(ReportFacade.java:217)</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)</p><p>          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</p><p>          at java.lang.reflect.Method.invoke(Method.java:601)</p><p>          at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)</p><p>          at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)</p><p>          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)</p><p>          at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)</p><p>          at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)</p><p>          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)</p><p>          at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)</p><p>          at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)</p><p>          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)</p><p>          at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)</p><p>          at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</p><p>          at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</p><p>          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</p><p>          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</p><p>          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)</p><p>          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</p><p>          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)</p><p>          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)</p><p>          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)</p><p>          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)</p><p>          at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)</p><p>          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</p><p>          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</p><p>          at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)</p><p>          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</p><p>          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)</p><p>          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)</p><p>          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)</p><p>          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)</p><p>          at java.lang.Thread.run(Thread.java:722)</p><p>Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.</p><p>There is an error in get connection, Access denied for user 'root'@'localhost' (using password: YES).</p><p>          at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:169)</p><p>          at org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:236)</p><p>          at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:223)</p><p>          at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:209)</p><p>          at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:390)</p><p>          at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:309)</p><p>          at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:498)</p><p>          at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:189)</p><p>          at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:177)</p><p>          at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:143)</p><p>          at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:482)</p></td></tr></tbody></table><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p><span style="font-size: 12pt; color: #ff0000;"><strong>Can you please help me to get rid of this issue, in which i got stucked for long. </strong></span></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Also i am getting few exceptions while starting the server, those i have attached.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Your help on my issues will be very thankful and great.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks in advance,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Ravichandran</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/747329#747329">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>