JBoss Community

HI

I have solved issue as per this post https://community.jboss.org/message/739144#739144

Here is my jbpmorm.xml file ( jpa2)

<?xml version="1.0" encoding="UTF-8"?>

<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"

                 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                 xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm orm_2_0.xsd"

                 version="2.0">

      <named-query name="ProcessInstancesWaitingForEvent">

          <query>

select

    processInstanceInfo.processInstanceId

from

    org.jbpm.persistence.processinstance.ProcessInstanceInfo processInstanceInfo join processInstanceInfo.eventTypes eventTypes

where

    eventTypes = :type

          </query>

      </named-query>

        <!-- ProcessInstanceInfo mapping (needed for JPA 2) -->

      <entity class="org.jbpm.persistence.processinstance.ProcessInstanceInfo"

              metadata-complete="true">

        <pre-update method-name="update" />

        <attributes>

            <id name="processInstanceId">

                <column name="InstanceId" />

                <generated-value strategy="AUTO"/>

            </id>

            <basic name="processId" access="FIELD" />

            <basic name="startDate" access="FIELD" >

                <temporal>DATE</temporal>

            </basic>

            <basic name="lastReadDate" access="FIELD" >

                <temporal>DATE</temporal>

            </basic>

            <basic name="lastModificationDate" access="FIELD" >

                <temporal>DATE</temporal>

            </basic>

            <basic name="state" access="FIELD" />

            <basic name="processInstanceByteArray" access="FIELD" >

                <lob/>

            </basic>

            <version name="version" access="FIELD" >

                <column name="OPTLOCK" />

            </version>

            <element-collection name="eventTypes" target-class="java.lang.String" access="FIELD" >

                <collection-table name="EventTypes">

                    <join-column name="InstanceId"/>

                </collection-table>

            </element-collection>

            <transient name="processInstance" />

            <transient name="env" />

            <transient name="id" />

        </attributes>

      </entity>

      <entity class="org.drools.persistence.info.SessionInfo" metadata-complete="false">

           <attributes>

            <id name="id">

                <column name="id" />

                <generated-value strategy="IDENTITY"></generated-value>

            </id>

          </attributes>

        </entity>

</entity-mappings>