[jboss-user] [jBPM] - jBPM5 console + Oracle + Tomcat

[bpmn2user]

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&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110124/5e64909d/attachment.html