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

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 -