<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV>Hi Pardeep,</DIV>
<DIV> </DIV>
<DIV>I have gotten this functionality to work.</DIV>
<DIV> </DIV>
<DIV>I am using SQL Server, but that is just a difference in the persistence.xml or datasource. </DIV>
<DIV> </DIV>
<DIV>You are seeing SessionInfo data, so your persistence is there, did you add this?</DIV>
<DIV><BR> <class>org.drools.persistence.processinstance.variabletypes.JPAPersistedVariable</class></DIV>
<DIV> </DIV>
<DIV>Here is the main points of my code.</DIV>
<DIV><BR> EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.drools.persistence.jpa");<BR> env = KnowledgeBaseFactory.newEnvironment();<BR> env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);</DIV>
<DIV> VariablePersistenceStrategyFactory.getVariablePersistenceStrategy()<BR> .setPersister("javax.persistence.Entity",<BR> "org.drools.persistence.processinstance.persisters.JPAVariablePersister");</DIV>
<DIV><BR> session = JPAKnowledgeService.newStatefulKnowledgeSession(knowledgeBase, null, env);</DIV>
<DIV> KnowledgeRuntimeLogger logger = KnowledgeRuntimeLoggerFactory.newFileLogger(session, "log/claimsdemo");</DIV>
<DIV> trackingProcessEventListener = new TrackingProcessEventListener();<BR> session.addEventListener(trackingProcessEventListener);</DIV>
<DIV><BR> Map<String, Object> parameterMap =<BR> new HashMap<String, Object>();<BR> parameterMap.put("claim", claim);<BR> processInstance = session.startProcess(CLAIM_FLOW, parameterMap);</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Bill<BR></DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> "Pardeep.Ruhil@lntinfotech.com" <Pardeep.Ruhil@lntinfotech.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> rules-users@lists.jboss.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thu, October 29, 2009 5:56:18 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [rules-users] Drools Persistence Prob : No values going into 'VaraibleInstanceInfo' Table<BR></FONT><BR><BR><FONT size=2 face="Trebuchet MS">Hi,</FONT> <BR><BR><FONT size=2 face="Trebuchet MS">I am working on persisting Drools session info into the database.</FONT> <BR><FONT size=2 face="Trebuchet MS">For that I have taken a sample project from </FONT>
<TABLE>
<TBODY>
<TR vAlign=top>
<TD><A href="http://blog.athico.com/2009/09/drools-flow-variable-persistence.html" rel=nofollow target=_blank><FONT color=blue size=2 face="Trebuchet MS"><U>http://blog.athico.com/2009/09/drools-flow-variable-<B>persistence</U></B><U>.html</U></FONT></A><FONT size=2 face="Trebuchet MS">.</FONT><FONT size=3> </FONT><BR><FONT size=2 face="Trebuchet MS">When I tried to debug the project, no values are inserted into the table 'VaraibleInstanceInfo' table. </FONT><BR><FONT size=2 face="Trebuchet MS">However In between the debugging I am able to see data going into the table 'SessionInfo' , 'ProcessInstaceInfo', WorkItemInfo' table. But no data is going into the 'VaraibleInstanceInfo' and 'ProcessInstanceEventInfo' table.</FONT> <BR><BR><FONT size=2 face="Trebuchet MS">I have taken the code for VariableInstanceInfo.java, SerializablePersistedVariable.java, JPAPersistedVariable.java and other required classes for running the project from
http://anonsvn.jboss.org/repos/labs/labs/jbossrules/trunk/drools-persistence-jpa/src/main/java/org/drools/persistence/processinstance/</FONT> <BR><BR><FONT size=2 face="Trebuchet MS">Kindly tell me what going wrong in this. I am using Mysql database for persistence storage.</FONT> <BR></TR></TBODY></TABLE><BR><BR><FONT size=2 face="Trebuchet MS">Thanks & Regards<BR><BR>Pardeep Ruhil<BR>L&T Infotech Ltd<BR>Mumbai<BR>Ph: +919820283884<BR><B><BR>Larsen & Toubro Infotech Ltd.</B></FONT><FONT color=blue size=2 face="Trebuchet MS"><U><BR></U></FONT><A href="http://www.lntinfotech.com/" rel=nofollow target=_blank><FONT color=blue size=2 face="Trebuchet MS"><U>www.Lntinfotech.com</U></FONT></A><FONT size=2 face="Trebuchet MS"><BR><BR>This Document is classified as: <BR><BR></FONT><INPUT value=on CHECKED type=checkbox name=F1_chkbox><FONT size=2 face="Trebuchet MS">L&T Infotech Proprietary </FONT><INPUT value=on type=checkbox
name=F1_chkbox><FONT size=2 face="Trebuchet MS">L&T Infotech Confidential </FONT><INPUT value=on type=checkbox name=F1_chkbox><FONT size=2 face="Trebuchet MS">L&T Infotech Internal Use Only </FONT><INPUT value=on type=checkbox name=F1_chkbox><FONT size=2 face="Trebuchet MS">L&T Infotech General Business <BR><BR>This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. </FONT><BR>______________________________________________________________________<BR></DIV></DIV></div><br>
</body></html>