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

[David Sinclair]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090123/28ebb11c/attachment.html