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]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
