<span class="Apple-style-span" style="font-family: verdana, geneva, helvetica, arial, sans-serif; font-size: 13px; border-collapse: collapse; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; ">Hi,�<br>
<br>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.�<br>
<br><br>� � � �when�<br>� � � � � � � � � � � � b:Feature(featureClass.name=="FrontSuspension")�<br>� � � � � � � � � � � � c:Feature(featureClass.name=="FrontAxle")�<br>� � � � � � � � � � � � eval(b.attributes.Capacity>=c.attributes.Capacity)�<br>
� � � � then <br>� � � � � � � � � � � � AvailabilityRuleState s = new AvailabilityRuleState();�<br>� � � � � � � � � � � � s.setValue("A");//Available�<br>� � � � � � � � � � � � s.setReason("");�<br>
� � � � � � � � � � � � s.setReference("FA-FS:1");�<br>� � � � � � � � � � � � resultState.add(s); <br>� � � � end�<br><br><br><br><br>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.�<br>
<br><a href="http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database" target="_top" rel="nofollow" link="external" style="font-size: 1em; ">http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database</a>��<br>
<br><a href="http://drools-java-rules-engine.46999.n3.nabble.com/Writing-rules-using-java-td57894.html?by-user=t#a57902" target="_top" rel="nofollow" link="external" style="font-size: 1em; ">http://drools-java-rules-engine.46999.n3.nabble.com/Writing-rules-using-java-td57894.html#a57902</a><br>
<br><a href="http://drools-java-rules-engine.46999.n3.nabble.com/Storing-rules-in-a-database-td47854.html?by-user=t" target="_top" rel="nofollow" link="external" style="font-size: 1em; ">http://drools-java-rules-engine.46999.n3.nabble.com/Storing-rules-in-a-database-td47854.html</a><br>
<br><a href="http://drools-java-rules-engine.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Database-td58955.html?by-user=t#a58956" target="_top" rel="nofollow" link="external" style="font-size: 1em; ">http://drools-java-rules-engine.46999.n3.nabble.com/How-to-Access-and-Execute-Rules-from-Database-td58955.html#a58956</a><br>
<br><br>these are the posts already in the forum. Please help me out.�<br><br>Thanks�<br>Navdeep</span>