[jboss-user] [jBPM] - Re: error running ksession.startProcess with Persistence
Odelya Holiday
do-not-reply at jboss.com
Mon Feb 28 06:39:59 EST 2011
Odelya Holiday [http://community.jboss.org/people/odelyaholiday] created the discussion
"Re: error running ksession.startProcess with Persistence"
To view the discussion, visit: http://community.jboss.org/message/590029#590029
--------------------------------------------------------------
My 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:comp/env/jdbc/testDS1</jta-data-source>
> <mapping-file>persistenceorm.xml</mapping-file>
> <class>org.drools.persistence.info.SessionInfo</class>
> <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
> <class>org.drools.persistence.info.WorkItemInfo</class>
> <exclude-unlisted-classes>true</exclude-unlisted-classes>
> <properties>
> <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
> <property name="hibernate.connection.autocommit" value="false" />
> <property name="hibernate.max_fetch_depth" value="3" />
> <property name="hibernate.show_sql" value="true" />
> <property name="hibernate.connection.driver_class" value="oracle.jdbc.driver.OracleDriver" />
> <property name="hibernate.transaction.manager_lookup_class"
> value="org.hibernate.transaction.BTMTransactionManagerLookup" />
> </properties>
> </persistence-unit>
>
>
> <persistence-unit name="org.sintec.task">
>
> <provider>org.hibernate.ejb.HibernatePersistence</provider>
> <mapping-file>orm.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>
> <exclude-unlisted-classes>true</exclude-unlisted-classes>
>
>
> <properties>
> <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:@myserver:1523:mydb" />
> <property name="hibernate.connection.username" value="workflow_cust" />
> <property name="hibernate.connection.password" value="workflow_cust" />
> <property name="hibernate.connection.autocommit" value="false" />
> <property name="hibernate.max_fetch_depth" value="3" />
> <property name="hibernate.show_sql" value="false" />
> </properties>
> </persistence-unit>
> </persistence>
>
my orm.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <entity-mappings xmlns=" 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"
> xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd"
> version="1.0">
> <named-query name="ProcessInstancesWaitingForEvent">
> <query>
> select
> processInstanceInfo.processInstanceId
> from
> ProcessInstanceInfo processInstanceInfo
> where
> :type in elements(processInstanceInfo.eventTypes)
> </query>
> </named-query>
> <named-query name="TasksAssignedAsBusinessAdministrator">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity businessAdministrator
> where
> businessAdministrator.id = :userId and
> businessAdministrator in elements ( t.peopleAssignments.businessAdministrators ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksAssignedAsExcludedOwner">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity excludedOwners
> where
> excludedOwners.id = :userId and
> excludedOwners in elements ( t.peopleAssignments.excludedOwners ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksAssignedAsPotentialOwner">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subject.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t
> left join t.taskData.createdBy
> left join t.taskData.actualOwner
> left join t.subjects as subject,
> I18NText names,
> I18NText descriptions,
> OrganizationalEntity potentialOwners
> where
> potentialOwners.id = :userId and
> potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subject.language = :language
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
>
>
>
>
>
>
> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksAssignedAsPotentialOwnerWithGroups">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy left join t.taskData.actualOwner,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity potentialOwners
> where
> ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds) ) and
> potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
>
>
> <named-query name="TasksAssignedAsPotentialOwnerByGroup">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy left join t.taskData.actualOwner,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity potentialOwners
> where
> potentialOwners.id = :groupId and
> potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
>
>
> <named-query name="SubTasksAssignedAsPotentialOwner">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy left join t.taskData.actualOwner,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity potentialOwners
> where
> t.taskData.parentId = :parentId and
> potentialOwners.id = :userId and
> potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
>
>
> <named-query name="GetSubTasksByParentTaskId">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t,
> I18NText names,
> I18NText subjects,
> I18NText descriptions
>
>
> where
> t.taskData.parentId = :parentId and
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.status in ('Created', 'Ready', 'Reserved', 'InProgress', 'Suspended') and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
>
>
>
>
> <named-query name="TasksAssignedAsRecipient">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity recipients
> where
> recipients.id = :userId and
> recipients in elements ( t.peopleAssignments.recipients ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksAssignedAsTaskInitiator">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity taskInitiator
> where
> taskInitiator.id = :userId and
> taskInitiator = t.peopleAssignments.taskInitiator and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksAssignedAsTaskStakeholder">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions,
> OrganizationalEntity taskStakeholder
> where
> taskStakeholder.id = :userId and
> taskStakeholder in elements ( t.peopleAssignments.taskStakeholders ) and
>
>
> names.language = :language and
> names in elements( t.names) and
>
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TasksOwned">
> <query>
> select
> new org.jbpm.task.query.TaskSummary(
> t.id,
> t.taskData.processInstanceId,
> names.text,
> subjects.text,
> descriptions.text,
> t.taskData.status,
> t.priority,
> t.taskData.skipable,
> t.taskData.actualOwner,
> t.taskData.createdBy,
> t.taskData.createdOn,
> t.taskData.activationTime,
> t.taskData.expirationTime)
> from
> Task t left join t.taskData.createdBy,
> I18NText names,
> I18NText subjects,
> I18NText descriptions
> where
> t.taskData.actualOwner.id = :userId and
> names in elements( t.names) and
> names.language = :language and
>
> (
> subjects.language = :language and
> subjects in elements( t.subjects)
> or t.subjects.size = 0
> ) and
>
>
> (
> descriptions.language = :language and
> descriptions in elements( t.descriptions)
> or t.descriptions.size = 0
> ) and
>
>
> t.taskData.expirationTime is null
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="UnescalatedDeadlines">
> <query>
> select
> new org.jbpm.task.query.DeadlineSummary(
> t.id,
> d.id,
> d.date)
> from
> Task t,
> Deadline d
> where
> (d in elements( t.deadlines.startDeadlines ) or d in elements( t.deadlines.endDeadlines ) ) and
> d.escalated = false
> order by
> d.date
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> <named-query name="TaskByWorkItemId">
> <query>
> select
> t
> from
> Task t
> where
> t.taskData.workItemId = :workItemId
> </query>
> <!-- hint name="org.hibernate.timeout" value="200"/ -->
> </named-query>
> </entity-mappings>
>
my persistenceorm.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <entity-mappings xmlns=" 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"
> xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm orm_1_0.xsd"
> version="1.0">
> <named-query name="ProcessInstancesWaitingForEvent">
> <query>
> select
> processInstanceInfo.processInstanceId
> from
> ProcessInstanceInfo processInstanceInfo
> where
> :type in elements(processInstanceInfo.eventTypes)
> </query>
> </named-query>
> </entity-mappings>
>
i am using tomcat so I added under web content/META_INF file context.xml:
> <WatchedResource>WEB-INF/web.xml</WatchedResource>
> <Transaction factory="bitronix.tm.BitronixUserTransactionObjectFactory" />
> <Resource name="jdbc/testDS1" auth="Container" type="javax.sql.DataSource"
> maxActive="15" maxIdle="2" maxWait="10000"
> logAbandoned="true"
> username="workflow_cust" password="workflow_cust"
> driverClassName="oracle.jdbc.OracleDriver"
> url="jdbc:oracle:thin:@myserver:1523:mydb"/>
>
and resources.properties:
> resource.ds1.className=bitronix.tm.resource.jdbc.lrc.LrcXADataSource
> resource.ds1.uniqueName=jdbc/testDS1
> resource.ds1.minPoolSize=0
> resource.ds1.maxPoolSize=5
> resource.ds1.driverProperties.driverClassName=oracle.jdbc.OracleDriver
>
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/590029#590029]
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/20110228/44405027/attachment-0001.html
More information about the jboss-user
mailing list