[rules-users] How to store(get) rules in database

[Navdeep Kumar]

Hi,

I want to store and then load rules from the database. I have seen that this
topic is already been discussed here but i did not understand that
completely that how can i do that. Can you please tell me the basic
requirements, what tables do i need to make,how can i parse that data into a
rule file. I have also seen a thread supported by Sujit and Micheal, i think
it is the same project which is discussed in this post. this project kind of
suits my requirement but the problem is that i am not able to get the whole
idea how to store and then load that back from the database to make a drl
file for rule engine. I also need a interface to get the input from the user
if he wants to add a new rule to the file. and user is non technical. I am
not getting how can i get the data and make that a rule for e.g.


       when
                        b:Feature(featureClass.name=="FrontSuspension")
                        c:Feature(featureClass.name=="FrontAxle")
                        eval(b.attributes.Capacity>=c.attributes.Capacity)
        then
                        AvailabilityRuleState s = new
AvailabilityRuleState();
                        s.setValue("A");//Available
                        s.setReason("");
                        s.setReference("FA-FS:1");
                        resultState.add(s);
        end




i have read article by Sujit Pal and code for this project is not there at
the link. Still got that code,but i am not able to import that in eclipse so
dint run that.The only relief is that all rules are on one single class
named Feature. as i saw in web interface images that whole package path was
written in one field.

http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database


http://drools-java-rules-engine.46999.n3.nabble.com/Writing-rules-using-java-td57894.html#a57902<http://drools-java-rules-engine.46999.n3.nabble.com/Writing-rules-using-java-td57894.html?by-user=t#a57902>

http://drools-java-rules-engine.46999.n3.nabble.com/Storing-rules-in-a-database-td47854.html<http://drools-java-rules-engine.46999.n3.nabble.com/Storing-rules-in-a-database-td47854.html?by-user=t>

http://drools-java-rules-engine.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Database-td58955.html#a58956<http://drools-java-rules-engine.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Database-td58955.html?by-user=t#a58956>


these are the posts already in the forum. Please help me out.

Thanks
Navdeep
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20101118/2d7ab1ff/attachment.html