2 Replies Latest reply on Jan 26, 2011 4:23 PM by bpmn2user

    jBPM5 console + Oracle + Tomcat6


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





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