4 Replies Latest reply on Jun 29, 2012 7:01 PM by Marco Rietveld

    JBPM + Oracle integration

    kavinks Newbie

      Please suggest how to  run JBPM 5.2 with oracle DB.

       

      The list of step that i have followed

      1.     changed the connection pool setting in Jboss7 with oracle DB.

      2.     modified the jbpm-gwt-console-server.war\WEB-INF\classes\hibernate.cfg.xml and persistance.xml inside META-INF for oracle DB.

      3.     Started the Jboss server.

       

      Is any other step need to be done?

      Do i need to create tables manully in DB or it will automatically create?

       

       

      Thanks,

      Kavin.

        • 1. Re: JBPM + Oracle integration
          Mauricio Salatino Master

          ??

          do you have any error with that configuration?

          • 2. Re: JBPM + Oracle integration
            kavinks Newbie

            while deployment the below error occurs.

             

             

            [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-1) JNDI bindings for session bean named EjbSynchronizations in deployment unit deployment "jbpm-gwt-console-server.war" are as follows:

              java:global/jbpm-gwt-console-server/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                      java:app/jbpm-gwt-console-server/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                      java:module/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                      java:global/jbpm-gwt-console-server/EjbSynchronizations

                      java:app/jbpm-gwt-console-server/EjbSynchronizations

                      java:module/EjbSynchronizations

            • 3. Re: JBPM + Oracle integration
              kavinks Newbie

              implemented JBPM with oracle DB. The sample JBPM working fine now.

              1.     Modified the persistance.xml like below.

               

              <persistence-unit name="org.jbpm.persistence.jpa" transaction-type="JTA">

              <provider>org.hibernate.ejb.HibernatePersistence</provider>

              <mapping-file>META-INF/JBPMorm.xml</mapping-file>

              <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>

              <class>org.drools.persistence.info.WorkItemInfo</class>

              <class>org.drools.persistence.info.SessionInfo</class>

              <properties>

              <property name="hibernate.connection.url" value="jdbc:oracle:thin:@localhost:1521:test"/>

              <property name="hibernate.connection.driver_class" value="oracle.jdbc.OracleDriver"/>

              <property name="hibernate.connection.username" value=""/>

              <property name="hibernate.connection.password" value=""/>

              <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect"/>

              <property name="hibernate.max_fetch_depth" value="3"/>

              <property name="hibernate.hbm2ddl.auto" value="create" />

              <property name="hibernate.show_sql" value="false" />

              <property name="hibernate.connection.autocommit" value="true" />

              <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup" />

              </properties>

                </persistence-unit>

               

               

              Thanks,

              Kavin

              • 4. Re: JBPM + Oracle integration
                Marco Rietveld Novice

                Kavin,

                 

                I've seen this error before:

                 

                  java:global/jbpm-gwt-console-server/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                          java:app/jbpm-gwt-console-server/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                          java:module/EjbSynchronizations!org.jboss.seam.transaction.LocalEjbSynchronizations

                          java:global/jbpm-gwt-console-server/EjbSynchronizations

                          java:app/jbpm-gwt-console-server/EjbSynchronizations

                          java:module/EjbSynchronizations

                 

                It has to do with incompatibilities -- but can be gotten rid of by uncommenting some lines in your standalone.xml.

                 

                I believe the line even references "ejbsynchronizations", although unfortunately I can't remember exactly what it was.