Kris Verlaenen [http://community.jboss.org/people/KrisVerlaenen] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/572323#572323 -------------------------------------------------------------- jBPM5 uses JPA (with Hibernate as default persistence provider) to persist process runtime data.  The tests use H2 in memory database simply because it is easy to set up and test.  But the persistence configuration can be updated to a lot of different databases.  I've just updated the documentation (it should show up in a few hours on the URL you mention) with a separate chapter on persistence, and that contains some information.  In general, you should just update your persistence.xml and the datasource you are using. If you still have questions after reading the updated documentation, or problems when changing the configuration, just let me know. It would be great if you could also document what changes you are making exactly to get it to run on oracle, as we could then extend the documentation with information like this ;) -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/572323#572323] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Wilman Chamba [http://community.jboss.org/people/wilmanchamba] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/589323#589323 -------------------------------------------------------------- JBPM5 installer default for the BD H2, I would like to convey a different configurationfor BD (in this case postgres) it and work with you on thisproject for review and thus help other developers. Whether the changes are: In the db directory of jbmp-installer add the following files: *File: jbpm-human-task-persistence.xml* *+++++++++++++++++++++++++++++++++++++ * <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <persistence version="1.0"              xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence                                  http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd                                  http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"              xmlns:orm=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm"              xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"              xmlns=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence">   <persistence-unit name="org.jbpm.task">     <provider>org.hibernate.ejb.HibernatePersistence</provider>     <class>org.jbpm.task.Attachment</class>     <class>org.jbpm.task.Content</class>     <class>org.jbpm.task.BooleanExpression</class>     <class>org.jbpm.task.Comment</class>     <class>org.jbpm.task.Deadline</class>     <class>org.jbpm.task.Comment</class>     <class>org.jbpm.task.Deadline</class>     <class>org.jbpm.task.Delegation</class>     <class>org.jbpm.task.Escalation</class>     <class>org.jbpm.task.Group</class>     <class>org.jbpm.task.I18NText</class>     <class>org.jbpm.task.Notification</class>     <class>org.jbpm.task.EmailNotification</class>     <class>org.jbpm.task.EmailNotificationHeader</class>     <class>org.jbpm.task.PeopleAssignments</class>     <class>org.jbpm.task.Reassignment</class>     <class>org.jbpm.task.Status</class>     <class>org.jbpm.task.Task</class>     <class>org.jbpm.task.TaskData</class>     <class>org.jbpm.task.SubTasksStrategy</class>     <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>     <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>     <class>org.jbpm.task.User</class> <properties>       <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>       <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/>       <property name="hibernate.connection.url" value="jdbc:postgresql://localhost/jbpm5" />       <property name="hibernate.connection.username" value="postgres"/>       <property name="hibernate.connection.password" value="adminadmin"/>       <property name="hibernate.connection.autocommit" value="false" />       <property name="hibernate.max_fetch_depth" value="3"/>       <property name="hibernate.hbm2ddl.auto" value="update" />       <property name="hibernate.show_sql" value="false" />     </properties>   </persistence-unit> </persistence> *+++++++++++++++++++++++++++++++++++++* *File: jbpm-bam-hibernate.cfg.xml* *+++++++++++++++++++++++++++++++++++++* <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"         " http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">   <hibernate-configuration>       <session-factory>           <!-- Database connection settings -->         <property name="connection.driver_class">org.postgresql.Driver</property>         <property name="connection.url">jdbc:postgresql://localhost/jbpm5</property>         <!--property name="connection.url">jdbc:h2:file:/NotBackedUp/data/mydb</property-->         <property name="connection.username">postgres</property>         <property name="connection.password">adminadmin</property>         <!-- JDBC connection pool (use the built-in) -->         <property name="connection.pool_size">5</property>         <!-- SQL dialect -->         <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>         <!-- Enable Hibernate's automatic session context management -->         <property name="current_session_context_class">thread</property>         <!-- Disable the second-level cache  -->         <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>         <!-- Echo all executed SQL to stdout -->         <property name="show_sql">false</property>         <!-- Drop and re-create the database schema on startup -->         <property name="hbm2ddl.auto">update</property>         <mapping resource="AuditLog.hbm.xml"/>       </session-factory>   </hibernate-configuration> **+++++++++++++++++++++++++++++++++++++** These files will help us to modify the respective jar jbpm Rename datasource file by jbpmDS-ds.xml *File: jbpmDS-ds.xml* <?xml version="1.0" encoding="UTF-8"?> <datasources>   <local-tx-datasource>     <jndi-name>jdbc/jbpmDS</jndi-name>     <connection-url>jdbc:postgresql:jbpm5</connection-url>     <!--connection-url>jdbc:h2:mem:mydb</connection-url-->     <driver-class>org.postgresql.Driver</driver-class>     <user-name>postgres</user-name>     <password>adminadmin</password>   </local-tx-datasource> </datasources> *+++++++++++++++++++++++++++++++++++++++++++++* Persistences.xml and hibernate.cfg.xml files should be set according to the database specified, in this case Postgres as has been shown in previous settings files. *File: persistence.xml* <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <persistence version="1.0"              xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence                                  http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd                                  http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm                                  http://java.sun.com/xml/ns/persistence/orm_1_0.xsd http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"              xmlns:orm=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm"              xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance http://www.w3.org/2001/XMLSchema-instance"              xmlns=" http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence">   <persistence-unit name="org.drools.persistence.jpa" transaction-type="JTA">     <provider>org.hibernate.ejb.HibernatePersistence</provider>     <jta-data-source>java:jdbc/jbpmDS</jta-data-source>           <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>     <class>org.drools.persistence.info.SessionInfo</class>     <class>org.drools.persistence.info.WorkItemInfo</class>     <properties>       <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>                       <property name="hibernate.max_fetch_depth" value="3"/>       <property name="hibernate.hbm2ddl.auto" value="update" />       <property name="hibernate.show_sql" value="false" />       <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.JBossTransactionManagerLookup" />     </properties>         </persistence-unit> </persistence> *+++++++++++++++++++++++++++++++++++++++* *File: hibernate.cfg.xml* <?xml version='1.0' encoding='utf-8'?> <!DOCTYPE hibernate-configuration PUBLIC         "-//Hibernate/Hibernate Configuration DTD 3.0//EN"         " http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration>     <session-factory>         <!-- Database connection settings -->         <property name="connection.driver_class">org.postgresql.Driver</property>         <property name="connection.url">jdbc:postgresql://localhost/jbpm5</property>         <!--property name="connection.url">jdbc:h2:file:/NotBackedUp/data/mydb</property-->         <property name="connection.username">postgres</property>         <property name="connection.password">adminadmin</property>         <!-- JDBC connection pool (use the built-in) -->         <property name="connection.pool_size">5</property>         <!-- SQL dialect -->         <property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>         <!-- Enable Hibernate's automatic session context management -->         <property name="current_session_context_class">thread</property>         <!-- Disable the second-level cache  -->         <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>         <!-- Echo all executed SQL to stdout -->         <property name="show_sql">false</property>         <!-- Drop and re-create the database schema on startup? -->         <property name="hbm2ddl.auto">update</property>           <mapping resource="AuditLog.hbm.xml"/>      </session-factory> </hibernate-configuration> *++++++++++++++++++++++++++++++++++++++++++++++++* Add the following properties in build.properties file *File: build.properties* ..... # Wilman # define the jar file to conecction bd driver.connection=postgresql.jar # define name file DataSource file.datasource=jbpmDS-ds.xml ++++++++++++++++++++++++ And in the build.xml file *File: build.xml* <?xml version="1.0" encoding="UTF-8"?> <project name="jBPM.install">   <property file="build.properties" />   <property name="install.home" value="./" />   <property name="jboss.server.conf.dir" value="${jboss.home}/server/${jboss.server.configuration}/conf" />   <property name="jboss.server.data.dir" value="${jboss.home}/server/${jboss.server.configuration}/data" />   <property name="jboss.server.deploy.dir" value="${jboss.home}/server/${jboss.server.configuration}/deploy" />   <property name="jboss.server.lib.dir" value="${jboss.home}/server/${jboss.server.configuration}/lib" />   <property name="jboss.server.birt.dir" value="${jboss.server.data.dir}/birt"/>   <property name="jboss.bind.address" value="localhost" />   <property name="eclipse.workspace.dir" value="${install.home}/workspace"/>   <property name="jboss.download.url" value=" http://downloads.sourceforge.net/jboss/jboss-$ http://downloads.sourceforge.net/jboss/jboss-${jboss.server.version}.zip&...   <property name="h2.download.url" value=" http://repository.jboss.org/maven2/com/h2database/h2/1.2.124/h2-1.2.124.jar http://repository.jboss.org/maven2/com/h2database/h2/1.2.124/h2-1.2.124.j...   <property name="slf4j.download.url" value=" http://repo1.maven.org/maven2/org/slf4j/slf4j-jdk14/1.5.11/slf4j-jdk14-1.... http://repo1.maven.org/maven2/org/slf4j/slf4j-jdk14/1.5.11/slf4j-jdk14-1....   <property name="birt.download.url" value=" http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/... http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/...   <!-- ############ DOWNLOAD ############ -->   <!-- Download H2 -->   <target name="download.h2.check">     <echo message="Checking h2 download ..." />     <condition property="h2.not.available">       <not>         <available file="${install.home}/db/driver/h2.jar" />       </not>     </condition>   </target>   <target name="download.h2" depends="download.h2.check" if="h2.not.available">     <echo message="Getting h2 ..." />     <mkdir dir="${install.home}/db/driver"/>     <get src="${h2.download.url}" dest="${install.home}/db/driver/h2.jar"  />   </target>   <!-- Download BIRT engine (gwt-console) -->   <target name="check.birt">     <condition property="birt.download">       <equals arg1="${jBPM.birt.download}" arg2="true" />     </condition>   </target>   <target name="download.birt.check" depends="check.birt" if="birt.download">     <echo message="Checking birt reporting engine download ..." />     <condition property="birt.not.available">       <not>         <available file="${install.home}/lib/birt-runtime-2_3_2_2.zip" />       </not>     </condition>   </target>   <target name="download.birt" depends="download.birt.check" if="birt.not.available">     <echo message="Getting birt reporting engine ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${birt.download.url}" dest="${install.home}/lib/birt-runtime-2_3_2_2.zip" />   </target>   <!-- Download JBoss AS -->   <target name="download.jboss.check">     <echo message="Checking JBoss AS download ..." />     <condition property="jboss.not.available">       <not>         <available file="${install.home}/lib/jboss-${jboss.server.version}.zip" />       </not>     </condition>   </target>   <target name="download.jboss" depends="download.jboss.check" if="jboss.not.available">     <echo message="Getting JBoss AS ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${jboss.download.url}" dest="${install.home}/lib/jboss-${jboss.server.version}.zip"  />   </target>   <!-- Download Eclipse -->   <condition property="download.type" value="win32">     <os family="windows" />   </condition>   <condition property="download.type" value="macosx-carbon">     <and>       <os family="mac" />       <os family="unix" />     </and>   </condition>   <condition property="download.type" value="linux-gtk">     <and>       <not>         <os family="mac" />       </not>       <os family="unix" />       <not>         <or>           <os arch="x86_64" />           <os arch="amd64" />         </or>       </not>     </and>   </condition>   <condition property="download.type" value="linux-gtk-x86_64">     <and>       <not>         <os family="mac" />       </not>       <os family="unix" />       <or>         <os arch="x86_64" />         <os arch="amd64" />       </or>     </and>   </condition>   <condition property="download.extension" value="zip">     <os family="windows" />   </condition>   <condition property="download.extension" value="tar.gz">     <or>       <os family="mac" />       <os family="unix" />     </or>   </condition>   <condition property="expandTypeZip" value="true">     <equals arg1="${download.extension}" arg2="zip" />   </condition>    <condition property="expandTypeTarGz" value="true">     <equals arg1="${download.extension}" arg2="tar.gz" />   </condition>    <target name="download.eclipse.check">     <echo message="Checking Eclipse download ..." />     <condition property="eclipse.not.available">       <not>         <available file="${install.home}/lib/eclipse-java-helios-${download.type}.${download.extension}" />       </not>     </condition>   </target>   <target name="download.eclipse" depends="download.eclipse.check" if="eclipse.not.available">     <echo message="Getting Eclipse ..." />     <mkdir dir="${install.home}/lib"/>     <get src=" http://download.eclipse.org/technology/epp/downloads/release/helios/R/ecl... http://download.eclipse.org/technology/epp/downloads/release/helios/R/ecl...          dest="${install.home}/lib/eclipse-java-helios-${download.type}.${download.extension}"  />   </target>   <target name="download.eclipse.gef.check">     <echo message="Checking Eclipse GEF download ..." />     <condition property="eclipse.gef.not.available">       <not>         <available file="${install.home}/lib/GEF-SDK-3.6.1.zip" />       </not>     </condition>   </target>   <target name="download.eclipse.gef" depends="download.eclipse.gef.check" if="eclipse.gef.not.available">     <echo message="Getting Eclipse GEF ..." />     <mkdir dir="${install.home}/lib"/>     <get src=" http://download.eclipse.org/tools/gef/downloads/drops/3.6.1/R201009132020... http://download.eclipse.org/tools/gef/downloads/drops/3.6.1/R201009132020...          dest="${install.home}/lib/GEF-SDK-3.6.1.zip"  />   </target>   <!-- Download jBPM binaries -->   <target name="download.jBPM.bin.check">     <echo message="Checking jBPM binaries download ..." />     <condition property="jBPM.bin.not.available">       <not>         <available file="${install.home}/lib/jbpm-${jBPM.version}-bin.zip" />       </not>     </condition>   </target>   <target name="download.jBPM.bin" depends="download.jBPM.bin.check" if="jBPM.bin.not.available">     <echo message="Getting jBPM binaries ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${jBPM.url}/jbpm-${jBPM.version}-bin.zip" dest="${install.home}/lib/jbpm-${jBPM.version}-bin.zip"  />   </target>   <!-- Download Drools Guvnor -->   <target name="download.drools.guvnor.check">     <echo message="Checking Drools Guvnor download ..." />     <condition property="drools.guvnor.not.available">       <not>         <available file="${install.home}/lib/drools-${drools.version}-guvnor.war" />       </not>     </condition>   </target>   <target name="download.drools.guvnor" depends="download.drools.guvnor.check" if="drools.guvnor.not.available">     <echo message="Getting Drools Guvnor ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${drools.url}/drools-${drools.version}-guvnor.war" dest="${install.home}/lib/drools-${drools.version}-guvnor.war"  />   </target>   <!-- Download Designer -->   <target name="download.designer.check">     <echo message="Checking Designer download ..." />     <condition property="designer.not.available">       <not>         <available file="${install.home}/lib/designer-${designer.version}.war" />       </not>     </condition>   </target>   <target name="download.designer" depends="download.designer.check" if="designer.not.available">     <echo message="Getting Designer ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${designer.url}/designer-${designer.version}.war" dest="${install.home}/lib/designer-${designer.version}.war"  />   </target>   <!-- Download jBPM Eclipse plugins -->   <target name="download.jBPM.eclipse.check">     <echo message="Checking jBPM Eclipse download ..." />     <condition property="jBPM.eclipse.not.available">       <not>         <available file="${install.home}/lib/jbpm-${jBPM.version}-eclipse-all.zip" />       </not>     </condition>   </target>   <target name="download.jBPM.eclipse" depends="download.jBPM.eclipse.check" if="jBPM.eclipse.not.available">     <echo message="Getting jBPM Eclipse ..." />     <mkdir dir="${install.home}/lib"/>     <get src=" http://community.jboss.org/servlet/JiveServlet/download/15922-7-25925/jbp... http://community.jboss.org/servlet/JiveServlet/download/15922-6-25925/jbp... dest="${install.home}/lib/jbpm-${jBPM.version}-eclipse-all.zip"  />   </target>   <!-- Download Drools Eclipse plugins -->   <target name="download.drools.eclipse.check">     <echo message="Checking Drools Eclipse download ..." />     <condition property="drools.eclipse.not.available">       <not>         <available file="${install.home}/lib/drools-${drools.version}-eclipse-all.zip" />       </not>     </condition>   </target>   <target name="download.drools.eclipse" depends="download.drools.eclipse.check" if="drools.eclipse.not.available">     <echo message="Getting Drools Eclipse ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${drools.url}/drools-${drools.version}-eclipse-all.zip" dest="${install.home}/lib/drools-${drools.version}-eclipse-all.zip"  />   </target>   <!-- Download jBPM gwt-console -->   <target name="download.jBPM.gwt-console.check">     <echo message="Checking jBPM gwt-console download ..." />     <condition property="jBPM.gwt-console.not.available">       <not>         <available file="${install.home}/lib/jbpm-${jBPM.version}-gwt-console.zip" />       </not>     </condition>   </target>   <target name="download.jBPM.gwt-console" depends="download.jBPM.gwt-console.check" if="jBPM.gwt-console.not.available">     <echo message="Getting jBPM gwt-console ..." />     <mkdir dir="${install.home}/lib"/>     <get src="${jBPM.url}/jbpm-${jBPM.version}-gwt-console.zip" dest="${install.home}/lib/jbpm-${jBPM.version}-gwt-console.zip"  />   </target>   <!-- ############ INSTALL ############ -->   <!-- Install JBoss AS -->   <target name="install.jboss" depends="download.jboss">     <unzip src="${install.home}/lib/jboss-${jboss.server.version}.zip" dest="${install.home}" />     <chmod perm="a+x" file="${install.home}/jboss-${jboss.server.version}/bin/run.sh" />     <chmod perm="a+x" file="${install.home}/jboss-${jboss.server.version}/bin/shutdown.sh" />   </target>   <!-- Install guvnor -->   <target name="check.jboss.version">     <condition property="jboss.version.is.5">       <equals arg1="${jboss.server.version}" arg2="5.1.0.GA" />     </condition>   </target>   <target name="install.guvnor.into.jboss" depends="download.drools.guvnor">     <antcall target="install.guvnor.into.jboss.5" />     <antcall target="install.guvnor.into.jboss.other" />   </target>   <target name="install.guvnor.into.jboss.5" depends="check.jboss.version" if="jboss.version.is.5">     <mkdir dir="${install.home}/target/drools-guvnor"/>     <unzip src="${install.home}/lib/drools-${drools.version}-guvnor.war" dest="${install.home}/target/drools-guvnor" />     <delete>       <fileset dir="${install.home}/target/drools-guvnor/WEB-INF/lib" includes="xml-apis-*.jar"/>     </delete>     <zip basedir="${install.home}/target/drools-guvnor"          destfile="${install.home}/target/drools-guvnor.war"/>     <copy file="${install.home}/target/drools-guvnor.war"           tofile="${jboss.server.deploy.dir}/drools-guvnor.war"           overwrite="true" />     <delete dir="${install.home}/target"/>   </target>    <target name="install.guvnor.into.jboss.other" depends="check.jboss.version" unless="jboss.version.is.5">     <copy file="${install.home}/lib/drools-${drools.version}-guvnor.war"           tofile="${jboss.server.deploy.dir}/drools-guvnor.war"           overwrite="true" />   </target>   <!-- Install designer -->   <target name="install.designer.into.jboss" depends="download.designer">     <copy file="${install.home}/lib/designer-${designer.version}.war"           tofile="${jboss.server.deploy.dir}/designer.war"           overwrite="true" />   </target>   <!-- Install configuration db file into jars -->   <target name="install.config.connectionDB.into.jars">     <mkdir dir="${install.home}/runtime/target"/>     <!-- Wilman: re build jbpm-human-task-5.X.X.jar -->     <mkdir dir="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}-jar"/>     <unzip src="${install.home}/runtime/jbpm-human-task-${jBPM.version}.jar" dest="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}-jar" />     <!-- Wilman: Fix for conflicting connection bd in configuration files in jars jbpm-->     <!-- Wilman: copy file jbpm-human-task-persistence.xml in jbpm-human-task-5.X.X.jar-->     <copy file="${install.home}/db/jbpm-human-task-persistence.xml"           tofile="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}-jar/META-INF/persistence.xml"           overwrite="true"/>     <!-- Wilman: build jbpm-human-task-5.X.X.jar -->     <zip basedir="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}-jar"          destfile="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}.jar"/>     <copy file="${install.home}/runtime/target/jbpm-human-task-${jBPM.version}.jar"           tofile="${install.home}/runtime/jbpm-human-task-${jBPM.version}.jar"           overwrite="true" />     <!-- Wilman: re build jbpm-bam-5.X.X.jar -->     <mkdir dir="${install.home}/runtime/target/jbpm-bam-${jBPM.version}-jar"/>     <unzip src="${install.home}/runtime/jbpm-bam-${jBPM.version}.jar" dest="${install.home}/runtime/target/jbpm-bam-${jBPM.version}-jar" />     <!-- Wilman: copy file jbpm-bam-hibernate.cfg.xml in jbpm-bam-5.X.X.jar-->     <copy file="${install.home}/db/jbpm-bam-hibernate.cfg.xml"           tofile="${install.home}/runtime/target/jbpm-bam-${jBPM.version}-jar/hibernate.cfg.xml"           overwrite="true"/>     <!-- Wilman: build jbpm-bam-5.X.X.jar -->     <zip basedir="${install.home}/runtime/target/jbpm-bam-${jBPM.version}-jar"          destfile="${install.home}/runtime/target/jbpm-bam-${jBPM.version}.jar"/>     <copy file="${install.home}/runtime/target/jbpm-bam-${jBPM.version}.jar"           tofile="${install.home}/runtime/jbpm-bam-${jBPM.version}.jar"           overwrite="true" />    <delete dir="${install.home}/runtime/target"/>   </target>   <!-- Install gwt-console -->   <target name="install.jBPM-gwt-console.into.jboss" depends="download.birt,download.jBPM.gwt-console,install.jBPM.runtime">     <!-- gwt-console -->     <mkdir dir="${install.home}/target"/>     <unzip src="${install.home}/lib/jbpm-${jBPM.version}-gwt-console.zip" dest="${install.home}/target" />     <mkdir dir="${install.home}/target/jbpm-gwt-console-server-war"/>     <unzip src="${install.home}/target/jbpm-gwt-console-server-${jBPM.version}.war"            dest="${install.home}/target/jbpm-gwt-console-server-war"/>     <copy file="${install.home}/db/hibernate.cfg.xml"           tofile="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/classes/hibernate.cfg.xml"           overwrite="true" />     <copy file="${install.home}/db/persistence.xml"           tofile="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/classes/META-INF/persistence.xml"           overwrite="true" />     <!--     <antcall target="install.config.connectionDB.into.jars"/>           -->     <!-- Wilman: copy file jbpm-human-task-5.X.X.jar into jbpm-gwt-console-server-war -->     <copy file="${install.home}/runtime/jbpm-human-task-${jBPM.version}.jar"           tofile="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/lib/jbpm-human-task-${jBPM.version}.jar"           overwrite="true"/>     <!-- Wilman: copy file jbpm-bam-5.X.X.jar into jbpm-gwt-console-server-war -->     <copy file="${install.home}/runtime/jbpm-bam-${jBPM.version}.jar"           tofile="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/lib/jbpm-bam-${jBPM.version}.jar"           overwrite="true"/>     <!-- Fix for conflicting javassist jar -->     <delete file="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/lib/javassist-3.6.0.GA.jar"/>     <!-- Other configuration like work item handlers -->     <copy todir="${install.home}/target/jbpm-gwt-console-server-war/WEB-INF/classes" overwrite="true">       <fileset dir="${install.home}/conf"/>     </copy>     <zip basedir="${install.home}/target/jbpm-gwt-console-server-war"          destfile="${install.home}/target/jbpm-gwt-console-server-${jBPM.version}.war"/>     <copy file="${install.home}/target/jbpm-gwt-console-server-${jBPM.version}.war"           tofile="${jboss.server.deploy.dir}/jbpm-gwt-console-server.war"           overwrite="true" />     <copy file="${install.home}/target/jbpm-gwt-console-${jBPM.version}.war"           tofile="${jboss.server.deploy.dir}/jbpm-gwt-console.war"           overwrite="true" />     <delete dir="${install.home}/target"/>     <!-- db configuration -->     <copy file="${install.home}/db/${file.datasource}"           tofile="${jboss.server.deploy.dir}/${file.datasource}"           overwrite="true" />     <!-- wilman: copy driver -->     <copy file="${install.home}/db/driver/${driver.connection}"           todir="${jboss.server.lib.dir}"           overwrite="true" />     <!--     <copy todir="${jboss.server.lib.dir}" overwrite="true">       <fileset dir="${install.home}/db/driver/*"/>     </copy>     -->     <!-- authentication configuration -->     <copy file="${install.home}/auth/users.properties"           tofile="${jboss.server.conf.dir}/users.properties"           overwrite="true" />     <copy file="${install.home}/auth/roles.properties"           tofile="${jboss.server.conf.dir}/roles.properties"           overwrite="true" />     <!-- reporting -->     <antcall target="install.reporting.into.jboss" />   </target>   <target name="install.reporting.into.jboss" depends="check.birt" if="birt.download" >     <mkdir dir="${install.home}/target"/>     <unzip src="${install.home}/lib/birt-runtime-2_3_2_2.zip"            dest="${install.home}/target"/>     <mkdir dir="${jboss.server.birt.dir}"/>     <mkdir dir="${jboss.server.birt.dir}/ReportEngine"/>     <copy todir="${jboss.server.birt.dir}/ReportEngine" overwrite="true">       <fileset dir="${install.home}/target/birt-runtime-2_3_2/ReportEngine"/>     </copy>     <delete dir="${install.home}/target"/>     <copy file="${install.home}/report/overall_activity.rptdesign"           tofile="${jboss.server.birt.dir}/overall_activity.rptdesign"           overwrite="true"/>     <copy file="${install.home}/report/process_summary.rptdesign"           tofile="${jboss.server.birt.dir}/process_summary.rptdesign"           overwrite="true"/>     <copy todir="${jboss.server.birt.dir}/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212/drivers" overwrite="true">       <fileset dir="${install.home}/db/driver"/>     </copy>   </target>   <!-- Install Eclipse -->   <target name="install.eclipse" depends="download.eclipse,download.eclipse.gef">      <antcall target="unzipEclipse" />     <antcall target="untarEclipse" />     <unzip dest="${install.home}" overwrite="true"            src="${install.home}/lib/GEF-SDK-3.6.1.zip" />                                                  </target>   <target name="unzipEclipse" if="expandTypeZip">     <unzip dest="${install.home}" overwrite="true"            src="${install.home}/lib/eclipse-java-helios-${download.type}.zip" />   </target>   <target name="untarEclipse" if="expandTypeTarGz">     <gunzip src="${install.home}/lib/eclipse-java-helios-${download.type}.tar.gz"/>     <untar dest="${install.home}" src="${install.home}/lib/eclipse-java-helios-${download.type}.tar" />     <chmod perm="a+x" file="${install.home}/eclipse/eclipse" os="Linux"/>     <chmod perm="a+x" file="${install.home}/eclipse/Eclipse.app/Contents/MacOS/eclipse" os="Mac OS X"/>   </target>   <!-- Install Eclipse plugins -->   <target name="install.jBPM.runtime" depends="download.jBPM.bin">     <!-- create runtime -->     <mkdir dir="${install.home}/runtime"/>     <unzip src="${install.home}/lib/jbpm-${jBPM.version}-bin.zip" dest="${install.home}/runtime" />     <!-- Wilman set new configuration databases-->     <antcall target="install.config.connectionDB.into.jars"/>   </target>   <!-- Install Eclipse plugins -->   <target name="install.jBPM-eclipse.into.eclipse" depends="download.jBPM.eclipse">     <!-- install plugins -->     <unzip src="${install.home}/lib/jbpm-${jBPM.version}-eclipse-all.zip" dest="${eclipse.home}" />   </target>   <!-- Install Eclipse plugins -->   <target name="install.drools-eclipse.into.eclipse" depends="download.drools.eclipse">     <!-- install plugins -->     <unzip src="${install.home}/lib/drools-${drools.version}-eclipse-all.zip" dest="${eclipse.home}" />     <copy todir="${eclipse.home}/features" overwrite="true">       <fileset dir="${eclipse.home}/drools-update-site/features"/>     </copy>     <copy todir="${eclipse.home}/plugins" overwrite="true">       <fileset dir="${eclipse.home}/drools-update-site/plugins"/>     </copy>     <delete dir="${eclipse.home}/drools-update-site"/>   </target>   <!-- Install Demo -->   <target name="install.demo" depends="install.jboss,install.guvnor.into.jboss,install.designer.into.jboss,install.jBPM-gwt-console.into.jboss,install.eclipse,install.jBPM-eclipse.into.eclipse,install.jBPM.runtime,install.drools-eclipse.into.eclipse,start.human.task" />   <!-- WILMAN -->   <!-- Install jbpm5 -->   <target name="install.jbpm5" depends="install.guvnor.into.jboss,install.designer.into.jboss,install.jBPM-gwt-console.into.jboss,install.jBPM.runtime,start.human.task"/> <!--install.eclipse,install.jBPM-eclipse.into.eclipse,install.jBPM.runtime,install.drools-eclipse.into.eclipse" -->   <!-- ############ START/STOP ############ -->   <!-- Start H2 server -->   <target name="start.h2" depends="download.h2">     <java classname="org.h2.tools.Server" fork="true" spawn="true">       <arg value="-tcp" />       <classpath location="${install.home}/db/driver/h2.jar" />     </java>   </target>   <!-- Stop H2 server -->   <target name="stop.h2" depends="download.h2">     <java classname="org.h2.tools.Server" fork="true">       <classpath location="${install.home}/db/driver/h2.jar" />       <arg value="-tcpShutdown" />       <arg value="tcp://localhost:9092" />     </java>   </target>   <!-- Start JBoss AS -->   <target name="start.jboss">     <property name="jboss.full.path.win" location="${jboss.home}/bin/run.bat" />     <exec executable="${jboss.full.path.win}" spawn="yes"           os="Windows 7,Windows Vista,Windows XP,Windows 2000,Windows 2003">       <env key="JAVA_OPTS" value="-XX:MaxPermSize=256m -Xms256m -Xmx512m" />       <arg value="-b" />       <arg value="${jboss.bind.address}" />       <arg value="-Djbpm.console.directory=${install.home}/sample/evaluation/src/main/resources" />     </exec>     <property name="jboss.full.path.linux" location="${jboss.home}/bin/run.sh" />     <exec executable="${jboss.full.path.linux}" spawn="yes" os="Linux,Mac OS X">       <env key="JAVA_OPTS" value="-XX:MaxPermSize=256m -Xms256m -Xmx512m" />       <arg value="-b" />       <arg value="${jboss.bind.address}" />       <arg value="-Djbpm.console.directory=${install.home}/sample/evaluation/src/main/resources" />     </exec>     <waitfor maxwait="5" maxwaitunit="minute" checkevery="30"              checkeveryunit="second" timeoutproperty="jboss.timeout">       <socket server="${jboss.bind.address}" port="8180" />     </waitfor>     <fail if="jboss.timeout" message="jboss did not start within 5 minutes"/>   </target>   <!-- Stop JBoss AS -->   <target name="stop.jboss">     <exec executable="${jboss.home}/bin/shutdown.bat"           os="Windows 7,Windows Vista,Windows XP,Windows 2000,Windows 2003">       <arg value="-s" />       <arg value="jnp://${jboss.bind.address}:1099" />       <arg value="-S" />     </exec>     <exec executable="${jboss.home}/bin/shutdown.sh" os="Linux,Mac OS X">       <arg value="-s" />       <arg value="jnp://${jboss.bind.address}:1099" />       <arg value="-S" />     </exec>   </target>   <!-- Start Eclipse -->   <target name="start.eclipse">     <exec executable="${eclipse.home}/eclipse.exe"           spawn="yes"           os="Windows 7,Windows Vista,Windows XP,Windows 2000,Windows 2003">       <arg value="-data" />       <arg value="${eclipse.workspace.dir}" />       <arg value="-plugincustomization" />       <arg value="./eclipse.preferences.ini" />     </exec>     <exec executable="${eclipse.home}/eclipse" spawn="yes" os="Linux">       <arg value="-data" />       <arg value="${eclipse.workspace.dir}" />       <arg value="-plugincustomization" />       <arg value="./eclipse.preferences.ini" />     </exec>             <chmod perm="a+x" file="./generate.mac.eclipse.preferences.sh" />     <exec executable="./generate.mac.eclipse.preferences.sh" os="Mac OS X"/>     <exec executable="${eclipse.home}/Eclipse.app/Contents/MacOS/eclipse" spawn="yes" os="Mac OS X">       <arg value="-data" />       <arg value="../../../../${eclipse.workspace.dir}" />       <arg value="-plugincustomization" />       <arg value="../../../../mac.eclipse.preferences.ini" />     </exec>   </target>   <!-- Start Human Task Service -->   <path id="classpath.human.task">     <fileset dir="${install.home}/runtime" includes="**/*.jar"/>     <fileset dir="${install.home}/db/driver" includes="**/*.jar"/>   </path>   <target name="start.human.task">     <mkdir dir="${install.home}/task-service/target"/>     <javac srcdir="${install.home}/task-service/src" destdir="${install.home}/task-service/target" classpathref="classpath.human.task">       <compilerarg value="-Xlint:unchecked"/>     </javac>     <copy todir="${install.home}/task-service/target">       <fileset dir="${install.home}/task-service/resources"/>     </copy>     <java classname="org.jbpm.DemoTaskService" fork="true">       <classpath>         <pathelement path="${install.home}/task-service/target"/>         <path refid="classpath.human.task" />       </classpath>     </java>   </target>   <!-- Start Demo -->   <target name="start.demo" depends="start.jboss,start.human.task" />   <!-- Stop Demo -->   <target name="stop.demo" depends="stop.jboss" />   <!-- ############ CLEAN ############ -->   <!-- Clean jboss -->   <target name="clean.jboss">     <delete dir="${install.home}/jboss-${jboss.server.version}"/>     <delete dir="${install.home}/repository"/>     <delete file="${install.home}/repository.xml"/>   </target>   <!-- Clean eclipse -->   <target name="clean.eclipse">     <delete dir="${install.home}/eclipse"/>     <delete dir="${install.home}/runtime"/>     <delete dir="${eclipse.workspace.dir}"/>   </target>   <!-- Stop Demo -->   <target name="clean.demo" depends="clean.jboss,clean.eclipse" /> </project> I hope to help with that. Wilman -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/589323#589323] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Wilman Chamba [http://community.jboss.org/people/wilmanchamba] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/590678#590678 -------------------------------------------------------------- Hi, Mauricio Indeed, with the loxageek company, has opened a wiki at: h1. Personalización de JBPM5 Instaler para Base de Datos http://www.loxageek.com/web/guest/base-de-conocimiento/-/wiki/JBPM/Person... (http://www.loxageek.com/web/guest/base-de-conocimiento/-/wiki/JBPM/Person...) -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/590678#590678] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Wilman Chamba [http://community.jboss.org/people/wilmanchamba] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/590681#590681 -------------------------------------------------------------- Hi Arun, Try the start.demo target to complete the tables' creation, at this point you should have 27 tables and the tables regarding human task must be populated. You must remove the dependency start.human.task from the start.demo target, it raises start.human.task service, this target also runs a class located in {jbpm-installer}/task-service/src/org/jbpm/DemoTaskService.java, in which you have to comment out the lines of adding users and groups and not have problems with creating users and groups, and has already created theinstall.jbpm5. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/590681#590681] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Anand Prakash [http://community.jboss.org/people/anandintouch] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/590752#590752 -------------------------------------------------------------- Hi Arun, For Oracle integration,you need to change Oracle dialect,username,password,url in respective persistence.xml  files. For example- *  <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>* *      <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver"/>* *      <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:xe" />* *      <property name="hibernate.connection.username" value="jbpm"/>* *      <property name="hibernate.connection.password" value="password"/>* And also *make sure that oracle jdbc jar(e.g. oracleJDBC-10.jar ) is in class path* which can also be configured in ant script as I had mentioned in my old post date  Dec 1, 2010 7:07 PM under section "Installer build file change is given below" -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/590752#590752] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Arun Prasath siva thanu pillai [http://community.jboss.org/people/arunsprasath] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/591424#591424 -------------------------------------------------------------- Hi, After the changes as mentioned before, now tables are getting populted but I m anot able to start the jboss server. When i m trying "ant start.demo", jboss time out occurs. I have already shared the jboss log in my previous post. Please help me to resolve this issue. Thanks, Arun -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/591424#591424] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Arun Prasath siva thanu pillai [http://community.jboss.org/people/arunsprasath] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/591480#591480 -------------------------------------------------------------- Hi William, I have already tried to remove the dependancy "start.human.task" from target "start.demo" in build.xml. When I start the "start.demo", the jboss log shows the server started at 3 min 45 sec . But in the terminal window , the build is failed  the reason saying the "jboss start timed out within 5 min time out period". Even I changed the timeout parameter in "build.xml" in theat "waitfor" tag, now also jboss server started at some 4 min as per the log. But again I am getting that same "Jboss start timed out within that <timeout>value specified in that build.xml". Do I need to do any code change in /src/org/jbpm/DemoTaskService.java file ?? As you mentioned, Do I need to comment those lines of adding users and groups. ? Plese help me to solve this issue. I have been troubling with this issue quite some time. If you have the exact updated configuration files, can you plz share with me. I am really dont know what could be the reason for this build failure. As you mentioned in your previous post, once start.demo completes, will that create 27 tables in the database? Thanks, Arun -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/591480#591480] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Arun Prasath siva thanu pillai [http://community.jboss.org/people/arunsprasath] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/591795#591795 -------------------------------------------------------------- Hi, Now jboss has started. The issue is because of the port number in jboss server in build.xml. Previously it was 8180 which was blocked by firewall, so modified to 8080.its working now. But i am getting the following error.  Though I copied the oracle driver "ojdbc6_11.2.0.1.jar" in jbpm runtime folder and set the classpath for this jar file. I am still getting this error. Please help me to solve this issue. Here I havent commented out the dependancy of "start.human.task" in "start.demo" target. --------------------- D:\jbpm-5.0.0-installer-full_old\jbpm-installer>ant start.demo Buildfile: D:\jbpm-5.0.0-installer-full_old\jbpm-installer\build.xml start.jboss: start.human.task:     [javac] D:\jbpm-5.0.0-installer-full_old\jbpm-installer\build.xml:523: warning: 'includeantruntime' was not set, def aulting to build.sysclasspath=last; set to false for repeatable builds      [java] SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".      [java] SLF4J: Defaulting to no-operation (NOP) logger implementation      [java] SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.      [java] Exception in thread "main" javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.task] Unable t o build EntityManagerFactory      [java]     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)      [java]     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)      [java]     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)      [java]     at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)      [java]     at org.jbpm.DemoTaskService.main(Unknown Source)      [java] Caused by: org.hibernate.HibernateException: JDBC Driver class not found: oracle.jdbc.OracleDrive      [java]     at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.ja va:89)      [java]     at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.ja va:137)      [java]     at org.hibernate.ejb.InjectionSettingsFactory.createConnectionProvider(InjectionSettingsFactory.java:29)      [java]     at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:89)      [java]     at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101)      [java]     at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325)      [java]     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)      [java]     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)      [java]     ... 4 more      [java] Caused by: java.lang.ClassNotFoundException: oracle.jdbc.OracleDrive      [java]     at java.net.URLClassLoader$1.run(URLClassLoader.java:202)      [java]     at java.security.AccessController.doPrivileged(Native Method)      [java]     at java.net.URLClassLoader.findClass(URLClassLoader.java:190)      [java]     at java.lang.ClassLoader.loadClass(ClassLoader.java:307)      [java]     at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)      [java]     at java.lang.ClassLoader.loadClass(ClassLoader.java:248)      [java]     at java.lang.Class.forName0(Native Method)      [java]     at java.lang.Class.forName(Class.java:169)      [java]     at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:123)      [java]     at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.ja va:84)      [java]     ... 11 more      [java] Java Result: 1 start.demo: -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/591795#591795] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Wilman Chamba [http://community.jboss.org/people/wilmanchamba] created the discussion "Re: JBPM5 integration with oracle" To view the discussion, visit: http://community.jboss.org/message/592207#592207 -------------------------------------------------------------- Hi Arun, review the port: 8080 of jboss, I use the 8180 default in jboss server, and so should be in the build.xml *<waitfor maxwait="5" maxwaitunit="minute" checkevery="30"* *             checkeveryunit="second" timeoutproperty="jboss.timeout">* *      <socket server="${jboss.bind.address}" port="8180" />* *    </waitfor>* Wilman -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/592207#592207] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]