[jboss-user] [jBPM] - Re: problems using jbpm5 integrated with oracle and tomcat

[kishore t]

kishore t [http://community.jboss.org/people/kishoret] created the discussion

"Re: problems using jbpm5 integrated with oracle and tomcat"

To view the discussion, visit: http://community.jboss.org/message/625961#625961

--------------------------------------------------------------
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
[http://community.jboss.org/message/625961#625961]

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/20110912/501a01ed/attachment-0001.html