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

    jBPM5 console + Oracle + Tomcat6

    bpmn2user Expert

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