problem reagarding task node configuration in jbpm

[vnm]

Hi,
In my jbpm processdefinition I have configured a task node but on deployment of the processdefinition.xml I am getting error as below

14:35:40,280 ERROR [STDERR] org.hibernate.exception.DataException: could not insert: [org.jbpm.taskmgmt.def.Task]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
 at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
 at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
 at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
 at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
 at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
 at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
 at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
 at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
 at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
 at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
 at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
 at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
 at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
 at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
 at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
 at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)
 at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)
 at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218)
 at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
 at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)
 at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)
 at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)
 at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)
 at org.hibernate.engine.Cascade.cascade(Cascade.java:130)
 at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)
 at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)
 at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
 at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
 at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
 at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
 at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
 at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
 at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
 at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
 at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:77)
 at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
 at com.tcs.sgv.jbpm.filter.LoginAuthenticationFilter.doFilter(LoginAuthenticationFilter.java:56)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
 at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: No data - zero rows fetched, selected, or processed
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
 at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
 at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
 at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
 at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
 ... 74 more
14:35:40,281 ERROR [LoginAuthenticationFilter] org.hibernate.exception.DataException: could not insert: [org.jbpm.taskmgmt.def.Task]

And the problem of this error is because of task node insert...If I alter my jpdl without any tasknode configuration it will be deployed successfully without any problem...

Can anyone please tell me what can be root cause of the problem? It might be the prb wid my hibernate.cfg.xml so for your reference I am sending you the same as below

<?xml version='1.0' encoding='utf-8'?>

<!DOCTYPE hibernate-configuration PUBLIC
 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
 <session-factory>

 <!-- hibernate dialect -->
 <!--<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>-->

 <!-- JDBC connection properties (begin) ===-->
 <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
 <!-- <property name="hibernate.connection.url">jdbc:mysql://172.26.141.27:3309/jbpm_db1</property> -->
 <property name="hibernate.connection.url">jdbc:mysql://172.26.146.118:3306/jbpmdb</property>
 <property name="hibernate.connection.username">dep_admin</property>
 <property name="hibernate.connection.password">dep_admin</property>
 <!--==== JDBC connection properties (end) -->

 <property name="hibernate.show_sql">true</property>
 <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

 <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

 <!-- DataSource properties (begin)
 <property name="hibernate.connection.datasource">java:comp/env/jdbc/JbpmDataSource</property>-->
 <!-- DataSource properties (end) -->

 <!-- JTA transaction properties (begin) === -->
 <property name="hibernate.transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
 <!--<property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
 ==== JTA transaction properties (end) -->

 <!-- CMT transaction properties (begin) ===
 <property name="hibernate.transaction.factory_class">org.hibernate.transaction.CMTTransactionFactory</property>
 <property name="hibernate.transaction.manager_lookup_class">org.hibernate.transaction.JBossTransactionManagerLookup</property>
 ==== CMT transaction properties (end) -->

 <!-- logging properties (begin) ===
 <property name="hibernate.show_sql">true</property>
 <property name="hibernate.format_sql">true</property>
 <property name="hibernate.use_sql_comments">true</property>
 ==== logging properties (end) -->

 <!-- ############################################ -->
 <!-- # mapping files with external dependencies # -->
 <!-- ############################################ -->

 <!-- following mapping files have a dependency on -->
 <!-- 'jbpm-identity.jar', mapping files -->
 <!-- of the pluggable jbpm identity component. -->
 <!-- Uncomment the following 3 lines if you -->
 <!-- want to use the jBPM identity mgmgt -->
 <!-- component. -->
 <!-- identity mappings (begin) -->
 <mapping resource="org/jbpm/identity/User.hbm.xml"/>
 <mapping resource="org/jbpm/identity/Group.hbm.xml"/>
 <mapping resource="org/jbpm/identity/Membership.hbm.xml"/>
 <!-- identity mappings (end) -->

 <!-- following mapping files have a dependency on -->
 <!-- the JCR API -->
 <!-- jcr mappings (begin) ===
 <mapping resource="org/jbpm/context/exe/variableinstance/JcrNodeInstance.hbm.xml"/>
 ==== jcr mappings (end) -->


 <!-- ###################### -->
 <!-- # jbpm mapping files # -->
 <!-- ###################### -->

 <!-- hql queries and type defs -->
 <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
 <!-- hql queries used in simulation for querying historical data
 uncomment if you want to use the GetSimulationInputCommand
 or maybe you also want to use the queries yourself
 be patient: the queries need the stddev function to be enabled in your dialect
 more information on this can be found here: http://www.camunda.com/business_process_simulation_news/mysql_and_stddev.html -->
 <!--
 <mapping resource="org/jbpm/sim/bam/hibernate.queries.hbm.xml" />
 -->

 <!-- graph.action mapping files -->
 <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/>

 <!-- graph.def mapping files -->
 <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
 <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
 <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>

 <!-- ############################################ -->
 <!-- # another mapping file with external dependencies # -->
 <!-- ############################################ -->
 <!-- following mapping file has a dependency on -->
 <!-- 'bsh-{version}.jar'. -->
 <!-- uncomment this if you don't have bsh on your -->
 <!-- classpath. you won't be able to use the -->
 <!-- script element in process definition files -->
 <!-- has to be defined below org/jbpm/graph/def/Action.hbm.xml -->
 <!-- due to the inline collection-cache elements below -->
 <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>

 <!-- graph.node mapping files -->
 <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
 <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>

 <!-- context.def mapping files -->
 <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
 <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>

 <!-- bytes mapping files -->
 <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>

 <!-- module.def mapping files -->
 <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>

 <!-- file.def mapping files -->
 <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>

 <!-- taskmgmt.def mapping files -->
 <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>

 <!-- scheduler.def mapping files -->
 <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
 <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>

 <!-- graph.exe mapping files -->
 <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
 <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
 <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
 <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>

 <!-- module.exe mapping files -->
 <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>

 <!-- context.exe mapping files -->
 <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/>
 <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/>

 <!-- job mapping files -->
 <mapping resource="org/jbpm/job/Job.hbm.xml"/>
 <mapping resource="org/jbpm/job/Timer.hbm.xml"/>
 <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/>
 <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/>

 <!-- taskmgmt.exe mapping files -->
 <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/>

 <!-- logging mapping files -->
 <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/>
 <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/>
 <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/>
 <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/>
 <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/>


 </session-factory>
</hibernate-configuration>

and for your reference I am also sending my processdefinition.xml in which I have configured task node

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

<process-definition xmlns="urn:jbpm.org:jpdl-3.2" name="LeaveInsertFinal">


 <start-state name="start leave process">
 <transition to="Validate Leave Details" name="to validate leave details"></transition>
 </start-state>


 <process-state name="Validate Leave Details">
 <sub-process name="LeaveValidate"></sub-process>
 <variable access="read,write" name="serviceVO" mapped-name="serviceVO"></variable>
 <transition to="LeaveInsertDecision" name="to LeaveInsertDecision"></transition>
 </process-state>

 <process-state name="InsertLeaveDetails">
 <sub-process name="LeaveInsert"></sub-process>
 <variable access="read,write" name="serviceVO" mapped-name="serviceVO"></variable>
 <transition to="ForwardLeaveDetails" name="to LeaveDetailsForward"></transition>
 </process-state>

 <decision name="LeaveInsertDecision">
 <handler class="com.tcs.sgv.jbpm.apps.leave.handlers.LeaveInsertProceedDecisionHandler">
 <ruleFileName>
 /com/tcs/sgv/jbpm/apps/leave/rules/ProceedLeaveInsert.drl
 </ruleFileName>
 </handler>
 <transition to="InsertLeaveDetails" name="to InsertLeaveDetails"></transition>
 <transition to="End" name="to End"></transition>
 </decision>

 <process-state name="ForwardLeaveDetails">
 <sub-process name="ForwardLeaveDetails"/>
 <variable access="read,write" name="serviceVO" mapped-name="serviceVO"></variable>
 <transition to="ApproveLeaveDetails"></transition>
 </process-state>

 <task-node name="ApproveLeaveDetails">
 <task name="ApproveLeaveDetails">
 <assignment actor-id="tcs_secy"></assignment>
 </task>
 <event type="task-start">
 <action name="task start action" class="com.tcs.sgv.esb.common.util.SyncEsbActionHandler">
 <esbCategoryName>
 ProcessService
 </esbCategoryName>
 <esbServiceName>
 EndTask
 </esbServiceName>
 <bpmToEsbVars></bpmToEsbVars>
 <esbToBpmVars></esbToBpmVars>
 </action>
 </event>
 <transition to="End"></transition>
 </task-node>


 <end-state name="End"></end-state>


</process-definition>

Thanks and Regards
vnm

[kukeltje]

use the innodb dialect which is currently commented out.

[vnm]

hi Ronald,
Thanks for your reply..

As per your instruction I changed dialect property as below in my hibernate.cfg.xml because we are using innodb as default storage engine

org.hibernate.dialect.MySQLInnoDBDialect

which was priviously
org.hibernate.dialect.MySQLDialect

But the error still prevails...

Regards
vnm

[kukeltje]

how did you create the schema?

[vnm]

Are you asking for jbpmdb?

In this schema I have executed list of scripts given by jbpm to run persist your jpdl in mysql...Actually I am using jbpm and esb in integration...So on installation of jbossesb suit, I have found out the mysqlscript file for jbpm tables...

Thanks and Regards
vnm

[kukeltje]

than you can have version 'conflicts' if you use a newer version of jBPM e.g. 3.2.6sp1 and the scripts from the esb could be for 3.2.2

[vnm]

Hi Ronald,
Thank you so much for your help..You are right as the problem was because of version mismatch between the jbpm I am using and that for esb..
As I am using jbpm version 3.2.3 and esb is using 3.2.2 and the scripts I executed priviously was from esb ..So then I found the mysql script file from jbpm-jpdl-suite-3.2.3 and executed it and then tested my same application and now it is allowing me to deploy my jpdl on db...
Again thank you so much for your time and efforts

Regards
vnm

[kukeltje]

Then I would even switch to 3.2.6SP1...

[vnm]

I have not tried 3.2.6SP1 yet..The only thing I know about 3.2.6SP1 is that it has inbulit installer which we can directly point to standalone Jboss AS ..I have also downloaded 3.2.6SP1 installer jar but hav nt used it yet...

Regards
vnm

[vnm]

But thing I also want to mention is that I have decieded to shift to jbpm version 4 from 3.2.3...I need to study version 4 first as it differs from version 3 widely.. But is it advisable to shift to version 4 directly from 3.2.3 instead of to shift to version > 3.2.3?

Regards,
vnm

[jbarrez]

You'll see that the core concepts are the same, but the complete way of working has changed.

So yes, the switch to jBPM4 makes sense, ceratinly if you want to be future-proof (but this also means learning jBPM4)