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

My pleasure. Within ProcessInstanceInfo, I've got a similar observation about the eventTypes member. 'private Set<EventType>' is currently commented out in favor of 'private Set<String>'. When using an Oracle hibernate dialect, this results in the DDL 'create table ProcessInstanceInfo_eventTypes' which yields the error 'ORA-00972: identifier is too long'. I imagine this will be resolved when the String is promoted to EventType but I thought you might want to know. 2010/2/13 Mauricio Salatino <salaboy(a)gmail.com&gt; 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 > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users