bpmn2user [http://community.jboss.org/people/bpmn2user] created the discussion "jBPM5 console + Oracle + Tomcat" To view the discussion, visit: http://community.jboss.org/message/582878#582878 -------------------------------------------------------------- Here  are the steps: 1.) Configure the jBPM console with Tomcat ( http://community.jboss.org/thread/160572?tstart=0 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 -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/582878#582878] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]