Hi,<br><br>We do something similar, a bit more intricate though. We have been integrating Drools into an SCA container, where the rule infrastructure is used as an implementation type. We define the implementation type in a SCDL, which is an XML file that has the service component definitions. Like below for example,<br>
<br><composite><br><br> <component name="MyRoolsComponent"><br> <implementation.drools resource="jdbc://myDs?query=foo" /><br> </component><br><br></composite><br>
<br>The resource attribute is a URL, and we have custom URL connection factories that source DRL definitions from relational databases. The users may edit the DRL files whichever way they want and upload through a web UI.<br>
<br>On a slight sidebar, we also allow other components within the SCA container, injected via DI as globals into the rule files. We are also able to autowire non-components implemented in Groovy, BPEL etc, into globals within the rules component based on contract compatibility checks.<br>
<br>Regards<br>Meeraj<br><br><div class="gmail_quote">On Mon, Jul 19, 2010 at 9:38 PM, wilsonywx <span dir="ltr"><<a href="mailto:wei.yuan@baml.com">wei.yuan@baml.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
I am trying to develop an application where users can specify rules at a<br>
front end and the rule engine would execute in the backend. The users will<br>
work with a pre-defined set of objects and actions they can take on the<br>
objects.<br>
<br>
I could use a BRMS such as Guvnor but I found the GUI lacking and not<br>
friendly enough for the non-technical end users I am supporting. I will<br>
instead write a front end for user input, which is stored in the DB, and the<br>
backend will pull data and generate a .drl file each time it's run.<br>
<br>
I have found an old article on loading rules in and out of a DB dynamically,<br>
at<br>
<a href="http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database" target="_blank">http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database</a><br>
<a href="http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database" target="_blank">http://docs.codehaus.org/display/DROOLS/Loading+and+managing+rules+dynamically+from+a+database</a><br>
, which seems to fit my need. I am looking for feedbacks on users who have<br>
tried this approach. How flexible is it? My main concerns is that future<br>
versions of Drools might break a lot of things and require a lot of<br>
recoding. To me it seems like a reasonable approach.<br>
<font color="#888888">--<br>
View this message in context: <a href="http://drools-java-rules-engine.46999.n3.nabble.com/Storing-and-loading-rules-in-database-tp979499p979499.html" target="_blank">http://drools-java-rules-engine.46999.n3.nabble.com/Storing-and-loading-rules-in-database-tp979499p979499.html</a><br>
Sent from the Drools - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</font></blockquote></div><br>