jbpm4.4下hibernate映射文件中表跟类的对应关系

 
 

  
  
jbpm4.4下hibernate映射文件中表跟类的对应关系
  
  
  
  
  
  

   
   
  
  
		
 
 
 
 

  
  
// 得到流程定义
ProcessDefinitionImpl processDefinition = (ProcessDefinitionImpl)repositoryService.createProcessDefinitionQuery().processDefinitionId(processDefinitionId).uniqueResult();
			
// 当前流程定义中，所有的Activities
List<? extends Activity> activities = processDefinition.getActivities();

  
  

 
 
 
 

  
  jbpm.history.hbm.xml
 
 
 
 

  
  package="org.jbpm.pvm.internal.history.model"
 
 
 
 

  
  <classname="HistoryProcessInstanceImpl"table="JBPM4_HIST_PROCINST">
 
 
 
 

  
  <classname="HistoryActivityInstanceImpl"table="JBPM4_HIST_ACTINST">
 
 
 
 

  
  <classname="HistoryTaskImpl"table="JBPM4_HIST_TASK">
 
 
 
 

  
  <classname="HistoryVariableImpl"table="JBPM4_HIST_VAR">
 
 
 
 

  
  <classname="HistoryDetailImpl"table="JBPM4_HIST_DETAIL">
 
 
 
 

  
  
 
 
 
 

  
  jbpm.task.hbm.xml
 
 
 
 

  
  package="org.jbpm.pvm.internal.task"
 
 
 
 

  
  <classname="TaskImpl" table="JBPM4_TASK"discriminator-value="T">
 
 
 
 

  
  <classname="ParticipationImpl"table="JBPM4_PARTICIPATION">
 
 
 
 

  
  <classname="SwimlaneImpl"table="JBPM4_SWIMLANE">
 
 
 
 

  
  
 
 
 
 

  
  jbpm.repository.hbm.xml
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.repository.DeploymentImpl" table="JBPM4_DEPLOYMENT">
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.repository.DeploymentProperty"table="JBPM4_DEPLOYPROP">
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.id.PropertyImpl"table="JBPM4_PROPERTY">
 
 
 
 

  
  
 
 
 
 

  
  jbpm.identity.hbm.xml
 
 
 
 

  
  package="org.jbpm.pvm.internal.identity.impl"
 
 
 
 

  
  <classname="UserImpl" table="JBPM4_ID_USER">
 
 
 
 

  
  <classname="MembershipImpl"table="JBPM4_ID_MEMBERSHIP">
 
 
 
 

  
  <classname="GroupImpl"table="JBPM4_ID_GROUP">
 
 
 
 

  
  
 
 
 
 

  
  jbpm.execution.hbm.xml
 
 
 
 

  
  package="org.jbpm.pvm.internal.model"
 
 
 
 

  
  <classname="ExecutionImpl"table="JBPM4_EXECUTION">
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.type.Variable" table="JBPM4_VARIABLE">
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.lob.Lob"table="JBPM4_LOB">
 
 
 
 

  
  <classname="org.jbpm.pvm.internal.job.JobImpl"table="JBPM4_JOB">
 
 
 
 

  
  
 
 
 
 

  
  部分hql语句
 
 
 
 

  
  <!-- ###HibernateJobDbSession QUERIES ##################################-->
 
 
 
 

  
  <queryname="findFirstAcquirableJob">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  select job
 
 
 
 

  
  fromorg.jbpm.pvm.internal.job.JobImpl as job
 
 
 
 

  
  where (job.lockExpirationTime isnull or job.lockExpirationTime <= :now)
 
 
 
 

  
  and (job.dueDate is null orjob.dueDate <= :now)
 
 
 
 

  
  and job.retries >0
 
 
 
 

  
  and job.state !='suspended'
 
 
 
 

  
  order by job.dueDateasc
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  
 
 
 
 

  
  <queryname="findExclusiveJobs">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  select job
 
 
 
 

  
  fromorg.jbpm.pvm.internal.job.JobImpl as job
 
 
 
 

  
  where job.lockOwner isnull
 
 
 
 

  
  and job.processInstance =:processInstance
 
 
 
 

  
  and job.isExclusive =true
 
 
 
 

  
  and job.retries >0
 
 
 
 

  
  and job.state !='suspended'
 
 
 
 

  
  and (job.dueDate is null orjob.dueDate <= :now)
 
 
 
 

  
  order by job.dueDateasc
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  <queryname="findFirstDueJob">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  select job
 
 
 
 

  
  fromorg.jbpm.pvm.internal.job.JobImpl as job
 
 
 
 

  
  where job.lockOwner isnull
 
 
 
 

  
  and job.retries >0
 
 
 
 

  
  and job.state !='suspended'
 
 
 
 

  
  order by job.dueDateasc
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  <!-- ###HibernatePvmDbSession QUERIES#############################################-->
 
 
 
 

  
  <queryname="findExecutionById">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  select execution
 
 
 
 

  
  fromorg.jbpm.pvm.internal.model.ExecutionImpl as execution
 
 
 
 

  
  where execution.id =:id
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  
 
 
 
 

  
  <queryname="findProcessInstanceById">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  selectprocessInstance
 
 
 
 

  
  fromorg.jbpm.pvm.internal.model.ExecutionImpl asprocessInstance
 
 
 
 

  
  where processInstance.id =:processInstanceId
 
 
 
 

  
  and processInstance.parent isnull
 
 
 
 

  
  and processInstance.state !='suspended'
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  
 
 
 
 

  
  <queryname="findProcessInstanceByIdIgnoreSuspended">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  selectprocessInstance
 
 
 
 

  
  fromorg.jbpm.pvm.internal.model.ExecutionImpl asprocessInstance
 
 
 
 

  
  where processInstance.id =:processInstanceId
 
 
 
 

  
  and processInstance.parent isnull
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>
 
 
 
 

  
  
 
 
 
 

  
  <queryname="findProcessInstanceIds">
 
 
 
 

  
  <![CDATA[
 
 
 
 

  
  selectprocessInstance.id
 
 
 
 

  
  fromorg.jbpm.pvm.internal.model.ExecutionImpl asprocessInstance
 
 
 
 

  
  whereprocessInstance.processDefinitionId =:processDefinitionId
 
 
 
 

  
  and processInstance.parent isnull
 
 
 
 

  
  ]]>
 
 
 
 

  
  </query>