[rules-users] How to store and load rules from the database

[nkumar]

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/Storing-rules-in-a-database-td47854.html

http://drools-java-rules-engine.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Database-td58955.html#a58956


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

Thanks
Navdeep
-- 
View this message in context: http://drools-java-rules-engine.46999.n3.nabble.com/How-to-store-and-load-rules-from-the-database-tp1920000p1920000.html
Sent from the Drools - User mailing list archive at Nabble.com.