1.) Configure the jBPM console with Tomcat (http://community.jboss.org/people/bpmn2user/blog/2011/01/21/test) and configure the datasource against the Oracle database.
a.) Add transaction and Resource information after 'WatchedResource' line in TOMCAT_HOME/conf/context.xml as shown below.
.........
..........
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory" />
<Resource name="jdbc/testDS1" auth="Container" type="javax.sql.DataSource"
maxActive="15" maxIdle="2" maxWait="10000"
logAbandoned="true"
username="username" password="password"
driverClassName=" oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@youroraclehpost:port:dbs"/>
..........
.........
b.) Create 'resource.properties' in TOMCAT_HOME/conf as shown below.
resource.ds1.className=bitronix.tm.resource.jdbc.lrc.LrcXADataSource
resource.ds1.uniqueName=jdbc/testDS1
resource.ds1.minPoolSize=0
resource.ds1.maxPoolSize=5
resource.ds1.driverProperties.driverClassName=oracle.jdbc.OracleDriver
c.) Create 'btm-config.properties' in TOMCAT_HOME/conf as shown below.
bitronix.tm.serverId=tomcat-btm-node0
bitronix.tm.journal.disk.logPart1Filename=${btm.root}/work/btm1.tlog
bitronix.tm.journal.disk.logPart2Filename=${btm.root}/work/btm2.tlog
#bitronix.tm.resource.configuration=${btm.root}/conf/resources.properties
2.) Copy Oracle driver (e.g. oracle-11.1.0.6.jar) into into TOMCAT_HOME/lib
3.) Modify hibernate.cfg.xml in TOMCAT_HOME\webapps\gwt-console-server\WEB-INF\classes\META-INF to include Oracle connection details.
e.g
......
......
<!-- Database connection settings -->
<property name="connection.driver_class">oracle.jdbc.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@yourhostname:1521:test</property>
<property name="connection.username">dbuser</property>
<property name="connection.password">dbpw</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>
<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
.......
.......
Following two steps requires repackaging the jar files as the default embedded configuration files use h2. Also, do not use CR1 jar files as a lot of fixes for Oracle were done after CR1 release. Use latest SNAPSHOT jar files.
4.) Download and copy jbpm-human-task-5.0-SNAPSHOT.jar to TOMCAT_HOME/webapps/gwt-console-server/WEB-INF/lib
5.) Download and copy jbpm-bam-5.0-SNAPSHOT.jar to TOMCAT_HOME/webapps/gwt-console-server/WEB-INF/lib
6.) The BAM reports files (process_summary.rptdesign,overall_activity.rptdesign) need to be modified (using Eclispe BIRT plugin) to inlcude Oracle connection details.
7.) Also the Oracle driver needs to be included from BIRT ReportEngine.
Its location is TOMCAT_HOMEbirt\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212\drivers
Step6 is mainly required as the h2 database connection details are included and these should be replace with your Oracle database information.
Also,it should be noted that the design files do not have the latest table information. One of the columns for the table NodeInstanceLog (DATE has been replaced with LOG_DATE) has been changed (http://community.jboss.org/message/571322).
Attached please find the example reports. You need to provide the hostname and connection details.
You can not open these design files with the latest BIRT plugin as these reports use 2.3.1.
Download the BIRT designer from http://archive.eclipse.org/birt/downloads/build.php?build=R-R1-2_3_1-200809221151http://archive.eclipse.org/birt/downloads/build.php?build=R-R1-2_3_1-200809221151 and modify the report files process_summary.rptdesign,overall_activity.rptdesign in TOMCAT_HOME/BIRT directory.
Note: It is also required to change the database connection details in jbpm-human-task-5.0.0.jar for the human task if this service is started seperately or embedded as a startup servlet (http://community.jboss.org/message/581372#581372)
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>
<property name="hibernate.connection.driver_class" value="oracle.jdbc.OracleDriver"/>
<property name="hibernate.connection.url" value="jdbc:oracle:thin:@yourOraclehostname:port:dbs" />
<property name="hibernate.connection.username" value="username"/>
<property name="hibernate.connection.password" value="password"/>
<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>