JBoss Community

Re: problems using jbpm5 integrated with oracle and tomcat

created by kishore t in jBPM - View the full discussion

thank you Mauricio for the reply,

 

below are my configuration details,

 

Updated 'persistence.xml' in 'C:\apache-tomcat-7.0.19\webapps\gwt-console-server\WEB-INF\classes\META-INF\' and 'C:\apache-tomcat-7.0.19\webapps\gwt-console-server\WEB-INF\lib\jbpm-human-task-5.1.0.Final.jar\'

 

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

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

    <jta-data-source>java:jdbc/testDummyDS</jta-data-source>

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

 

    <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>

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

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

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

    <class>org.jbpm.process.audit.ProcessInstanceLog</class>

    <class>org.jbpm.process.audit.NodeInstanceLog</class>

    <class>org.jbpm.process.audit.VariableInstanceLog</class>

    <properties>

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

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

 

        <!--  [Due to security constraints I couldn't able to provide conncetion details here, but DB connection is working fine for me] -->

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

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

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

 

        <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>

 

 

hibernate.cfg.xml

  <hibernate-configuration>

    <session-factory>

        <!-- Database connection settings -->

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

 

    <!--  [Due to security constraints I couldn't able to provide conncetion details here, but DB connection is working fine for me] -->

        <property name="connection.url"></property>

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

        <property name="connection.password"></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>

 

        <!-- JTA transaction properties (begin) -->

        <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</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">create</property>

 

        <mapping resource="AuditLog.hbm.xml"/>

 

    </session-factory>

  </hibernate-configuration>

 

 

 

Note: Observed that after updating 'C:\apache-tomcat-7.0.19\conf\server.xml' file with '

               <Listener className="bitronix.tm.integration.tomcat55.BTMLifecycleListener" />' [also added jar 'btm-tomcat55-lifecycle-1.3.3.jar'

               as mentioned in jboss forum], tomcat server is failing to start.

 

 

Please let me know if you need any further information.

 

If any one has idea or faced related issue, pls share your thoughts.

 

 

Thanks,

Reply to this message by going to Community

Start a new discussion in jBPM at Community