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.wyttenb...@gmail.com> > 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.wyttenb...@gmail.com> 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@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@lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users