[rules-users] Drools Flow: Variable Persistence Strategies

[Mauricio Salatino]

done.. I will apply the patch into the trunk.. it seems to be correct.
Thanks a lot!

2010/2/13 Dale Wyttenbach <dale.wyttenbach at gmail.com>

> Please see attached.
>
>
> 2010/2/12 Mauricio Salatino <salaboy at gmail.com>
>
>> 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 at gmail.com>wrote:
>>
>>> can you post both, previous and new, sql schema generated for the
>>> VariableInstanceInfo and ProcessInstanceInfo tables?
>>>
>>>
>>>
>>> 2010/2/12 Dale Wyttenbach <dale.wyttenbach at gmail.com>
>>>
>>>> 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 at gmail.com>
>>>>
>>>> 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 at 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.wyttenbach at 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 at 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 at lists.jboss.org
>>>>> https://lists.jboss.org/mailman/listinfo/rules-users
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> rules-users mailing list
>>>> rules-users at 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>


-- 
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20100213/29a1f199/attachment.html