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(a)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-tp216... Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

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(a)gmail.com&gt;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(a)gmail.com&gt; 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(a)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-tp216... >> Sent from the drools - user mailing list archive at Nabble.com. >> >> _______________________________________________ >> 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 > > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Drools project without using .drl, decision table etc.?

I am using Drools project and want to store rules in database as they will be configurable, even when application is running. I have searched on internet but didn't find any satisfactory result.**** ** ** My requirement is:**** ** ** "How to store rules in database and access them in java files

Do you mean I should create my own table structure and then save the rules in my tables and retrieve them in my java program as I retrieve any other table data?**** ** ** I am looking if Drools application supports some rule based structure/table compatible with Oracle database. **** ** ** *From:* rules-users-bounces(a)lists.jboss.org [mailto: rules-users-bounces(a)lists.jboss.org] *On Behalf Of *Wolfgang Laun *Sent:* Wednesday, July 13, 2011 12:52 PM *To:* Rules Users List *Subject:* Re: [rules-users] How to Access and Execute Rules from Database **** ** ** 2011/7/13 vineet.arora3 <vineet.arora(a)hcl.com&gt;**** I am using Drools project and want to store rules in database as they will be configurable, even when application is running. I have searched on internet but didn't find any satisfactory result.**** **** My requirement is:**** **** "How to store rules in database and access them in java files**** I assume that you know how to store entire rules or bits and pieces as "text" in some DB, and how to retrieve them and compose them into rules according to your requirements. If "configuration" is just the repeated insertion of values (or larger chunks of text) into rules, you could look at "templates" and how to generate rules via the Drools API.**** instead of using .drl files?"**** Once you have a String aDrlString containing text as you would normally have it on a file, you can - write it to a file and compile that - pass the String aDrlString to the builder by: Resource res = ResourceFactory.newReaderResource( myStringReader ); kBuilder.add( res, ResourceType.DRL ); -W**** **** If you have any idea or sample example to demonstrate the same, please share.**** **** Thanks.**** **** **** *From:* Wolfgang Laun-2 [via Drools] [mailto:ml-node+[hidden email]<http://user/SendEmail.jtp?type=node&node=3165063&i=0>] *Sent:* Wednesday, July 13, 2011 12:33 PM *To:* Vineet Arora *Subject:* Re: [rules-users] How to Access and Execute Rules from Database **** **** **** On 13 July 2011 08:26, vineet.arora3 <[hidden email]<http://user/SendEmail.jtp?type=node&node=3165056&i=0>> wrote:**** **** Drools project without using .drl, decision table etc.?**** Do you really mean what you write here? Please be more specific. -W **** _______________________________________________ rules-users mailing list [hidden email] <http://user/SendEmail.jtp?type=node&node=3165056&i=1> https://lists.jboss.org/mailman/listinfo/rules-users**** ------------------------------ *If you reply to this email, your message will be added to the discussion below:***** http://drools.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Da... **** To unsubscribe from How to Access and Execute Rules from Database, click here. **** ** ** ------------------------------ ::DISCLAIMER:: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. ----------------------------------------------------------------------------------------------------------------------- **** ------------------------------ View this message in context: RE: [rules-users] How to Access and Execute Rules from Database<http://drools.46999.n3.nabble.com/How-to-Access-and-Execute-R... Sent from the Drools: User forum mailing list archive<http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.htm... Nabble.com. _______________________________________________ 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