JBoss Community

Here  are the steps:

1.) Configure the jBPM console with Tomcat (http://community.jboss.org/thread/160572?tstart=0) and configure the datasource against the Oracle database.

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

4.) Modify META-INF\persistence.xml in jbpm-human-task-5.0-SNAPSHOT.jar to include Oracle DB details.

e.g

.....

....

   <class>org.jbpm.task.User</class>

    <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:@yourhostname:1521:test" />

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

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

      <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>

  </persistence-unit>

......

.....

5.) Modify hibernate.cfg.xml in jbpm-bam-5.0-SNAPSHOT.jar to include Oracle database connection details