[rules-users] How to Access and Execute Rules from Database

Ashish Soni learnspring at gmail.com
Fri Jan 23 11:41:00 EST 2009


Thanks a lot , Do you have any suggestion/pointers i can start with .

Regards,
Ashish

On Fri, Jan 23, 2009 at 11:30 AM, David Sinclair <
dsinclair at chariotsolutions.com> wrote:

> These are JackRabbit tables. You would actually need to understand how
> Drools make's use of the JCR to use them directly.
>
>
> On Fri, Jan 23, 2009 at 11:19 AM, Ashish Soni <learnspring at gmail.com>wrote:
>
>> Thanks a lot for the help.
>>
>> Also i see below tables created in the database not sure which table need
>> to use to pulling the rules.
>>
>> DEFAULT_BINVAL
>> DEFAULT_NODE
>> DEFAULT_PROP
>> DEFAULT_REFS
>>
>>
>> REP_FSENTRY
>> REP_VERSION_FSENTRY
>>
>>
>> VERSION_BINVAL
>> VERSION_NODE
>> VERSION_PROP
>> VERSION_REFS
>>
>>
>> Please help.
>>
>> Regards,
>> Ashish
>>
>> On Fri, Jan 23, 2009 at 10:26 AM, techy <techluver007 at gmail.com> wrote:
>>
>>>
>>> I do it this way...hope this may help..
>>>  List<Rule> rules = dao.getAllRules();//reads RULE table and returns list
>>> of
>>> rule Object
>>>            for (Rule rule : rules)
>>>            {
>>>                try
>>>                {
>>>                    Clob ruleClob = rule.getRuleContent(); //I store
>>> complete rule info in this db clob column
>>>                    if (ruleClob != null
>>>                            &&
>>> StringUtils.isNotBlank(ruleClob.toString()))
>>>                    {
>>>                        builder.addPackageFromDrl(ruleClob
>>>                                        .getCharacterStream());//add each
>>> rule into package
>>>
>>>
>>>
>>>                    }
>>>
>>>                }
>>>
>>>                //pkg = builder.getPackage();
>>>               //ruleBase.addPackage(pkg)
>>>
>>>
>>>
>>> learndrools wrote:
>>> >
>>> > Hi All ,
>>> >
>>> > I am able to configure oracle database in drools but now i am not able
>>> to
>>> > find how can i load rules from the DB and execute them , I gone through
>>> > the
>>> > documentation but not able to get much information or might be i am
>>> > missing
>>> > something.
>>> >
>>> > If any one can provide me a example or some pointer ,hints then it
>>> would
>>> > be
>>> > helpful.
>>> >
>>> >
>>> > Regards,
>>> > Ashish
>>> >
>>> > _______________________________________________
>>> > rules-users mailing list
>>> > rules-users at lists.jboss.org
>>> > https://lists.jboss.org/mailman/listinfo/rules-users
>>> >
>>> >
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/How-to-Access-and-Execute-Rules-from-Database-tp21626109p21626458.html
>>> Sent from the drools - user mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> 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
>>
>>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090123/37475648/attachment.html 


More information about the rules-users mailing list