Re: [rules-users] Drools Flow: Variable Persistence Strategies

done.. I will apply the patch into the trunk.. it seems to be correct. Thanks a lot! 2010/2/13 Dale Wyttenbach <dale.wyttenbach(a)gmail.com&gt; Please see attached. > > > 2010/2/12 Mauricio Salatino <salaboy(a)gmail.com&gt; > >> I just want to make sure before apply the patch that the change will not >> impact in other places. >> Thanks >> >> >> On Fri, Feb 12, 2010 at 5:38 PM, Mauricio Salatino <salaboy(a)gmail.com&gt;wrote: >> >>> can you post both, previous and new, sql schema generated for the >>> VariableInstanceInfo and ProcessInstanceInfo tables? >>> >>> >>> >>> 2010/2/12 Dale Wyttenbach <dale.wyttenbach(a)gmail.com&gt; >>> >>>> If you try to write a query that >>>> requires VariableInstanceInfo.processId, it won't work because that class >>>> has no processId member. >>>> I guessed that processInstanceId would be a better join column, and >>>> that worked (patch attached) >>>> >>>> Thanks for the reply. >>>> >>>> 2010/2/12 Mauricio Salatino <salaboy(a)gmail.com&gt; >>>> >>>> Hmm.. >>>>> I'm looking at the source and I see the following mapping: >>>>> >>>>> @OneToMany(cascade = CascadeType.ALL) >>>>> @JoinColumn(name = "processId") >>>>> @MapKey(name = "name") >>>>> private Map<String, VariableInstanceInfo> variables = new >>>>> HashMap<String, VariableInstanceInfo>(); >>>>> >>>>> That makes me think that there is a join column called processId >>>>> between VariableInstanceInfo and ProcessInstanceInfo. >>>>> >>>>> >>>>> 2010/2/12 Dale Wyttenbach <dale.wyttenbach(a)gmail.com&gt; >>>>> >>>>>> I have a patch for drools-persistence-jpa should anyone agree with me >>>>>> that ProcessInstanceInfo and VariableInstanceInfo should be joined by >>>>>> processInstanceId. >>>>>> >>>>>> >>>>>> On Fri, Feb 12, 2010 at 10:52 AM, Dale Wyttenbach < >>>>>> dale.wyttenbach(a)gmail.com&gt; wrote: >>>>>> >>>>>>> I'm trying to adapt the StringVariablePersister presented in >>>>>>> http://blog.athico.com/2009/09/drools-flow-variable-persistence.html >>>>>>> >>>>>>> <http://blog.athico.com/2009/09/drools-flow-variable-persistence.html>I >>>>>>> can create process instances with variable "color": >>>>>>> >>>>>>> private static WorkflowProcessInstance >>>>>>> startProcess(StatefulKnowledgeSession ksession, String color) { >>>>>>> Map<String, Object> vars = new HashMap<String, Object>(); >>>>>>> vars.put("color", color); >>>>>>> WorkflowProcessInstance p1 = (WorkflowProcessInstance) >>>>>>> ksession.startProcess("com.sample.ruleflow", vars); >>>>>>> return p1; >>>>>>> } >>>>>>> >>>>>>> I can count them: >>>>>>> >>>>>>> select >>>>>>> count(*) >>>>>>> from >>>>>>> ProcessInstanceInfo >>>>>>> >>>>>>> However I'm stymied as to counting process instances with a given >>>>>>> color, as there appears to be no join column between ProcessInstanceInfo and >>>>>>> VariableInstanceInfo. >>>>>>> Can such a query be written? >>>>>>> >>>>>>> Thanks. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> rules-users mailing list >>>>>> rules-users(a)lists.jboss.org >>>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> - http://salaboy.wordpress.com >>>>> - http://www.jbug.com.ar >>>>> - Salatino "Salaboy" Mauricio - >>>>> >>>>> _______________________________________________ >>>>> rules-users mailing list >>>>> rules-users(a)lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> rules-users mailing list >>>> rules-users(a)lists.jboss.org >>>> https://lists.jboss.org/mailman/listinfo/rules-users >>>> >>>> >>> >>> >>> -- >>> - http://salaboy.wordpress.com >>> - http://www.jbug.com.ar >>> - Salatino "Salaboy" Mauricio - >>> >> >> >> >> -- >> - http://salaboy.wordpress.com >> - http://www.jbug.com.ar >> - Salatino "Salaboy" Mauricio - >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> >> > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > -- - http://salaboy.wordpress.com - http://www.jbug.com.ar - Salatino "Salaboy" Mauricio - _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users