[jboss-user] [jBPM] - Re: JBPM5 - How can I change the database?

[joachyt]

joachyt [http://community.jboss.org/people/joachyt] created the discussion

"Re: JBPM5 - How can I change the database?"

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

--------------------------------------------------------------
I changed the persistence.xml and invoking the workflow from a web app. 
I get the classnotfoundexception for classes [ starting from the audit ones and down ]. 

my persistence.xml is 
<?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.persistence.jpa" transaction-type="JTA">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <jta-data-source>jdbc/testDS1</jta-data-source>
        <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
        <class>org.jbpm.persistence.processinstance.ProcessInstanceEventInfo</class>
        <class>org.drools.persistence.info.SessionInfo</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>*
*        <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.SQLServerDialect"/>
        <property name="hibernate.connection.driver_class" value="net.sourceforge.jtds.jdbc.Driver"/>
            <property name="hibernate.connection.url" value="jdbc:jtds:sqlserver://localhost:1433/abc" />
            <property name="hibernate.connection.username" value="user1"/>
            <property name="hibernate.connection.password" value="user1"/>
            <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="true" />
            <property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup"/>
        </properties>
    </persistence-unit>
</persistence>

my pom file has these dependencies

|     | <dependency> |
|          | <groupId>junit</groupId> |
|          | <artifactId>junit</artifactId> |
|          | <version>4.8.1</version> |
|      | </dependency> |
|      | <dependency> |
|          | <groupId>org.jbpm</groupId> |
|          | <artifactId>jbpm-flow</artifactId> |
|          | <version>${jbpm5.version}</version> |
|      | </dependency> |
|      | <dependency> |
|          | <groupId>org.jbpm</groupId> |
|          | <artifactId>jbpm-bpmn2</artifactId> |
|          | <version>${jbpm5.version}</version> |
|      | </dependency> |
|      | <dependency> |
|          | <groupId>org.jbpm</groupId> |
|          | <artifactId>jbpm-flow-builder</artifactId> |
|          | <version>${jbpm5.version}</version> |
|      | </dependency> |
|       | <dependency> |
|          | <groupId>org.jbpm</groupId> |
|          | <artifactId>jbpm-persistence-jpa</artifactId> |
|          | <version>${jbpm5.version}</version> |
|          | <type>jar</type> |
|          | <exclusions> |
|          | <exclusion> |
|          | <groupId>org.hibernate</groupId> |
|          | <artifactId>hibernate-annotations</artifactId> |
|          | </exclusion> |
|          | </exclusions> |
|      | </dependency> |
|      | <dependency> |
|    |  |  | <groupId>org.codehaus.btm</groupId> |
|    |  |  | <artifactId>btm</artifactId> |
|    |  |  | <version>2.1.0</version> |
|  |  | </dependency> |


I thought the relevant jars should be available to tomcat as the maven dependecies are set. 
What am I missing. 
Greatly appreciate any pointers.
thank you
Joe
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/626979#626979]

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/20110916/d64b93af/attachment-0001.html