Your requirement isn't that clear however here's a few thoughts:- Data can be inserted into the Rule Engine either externally (i.e. WorkingMemory.insert) or internally (using "from"). If you use DSL you can make DRL more human readable; although neither are binary format in the first place. Drools will fit your requirement, but without knowing your use-cases better I can't say whether it would be the best fit. Perhaps if you can give a more detailed use-case the group would be better able to comment further. Please also ensure your emails go to the group.... http://www.jboss.org/drools/lists.html Finally, do read the documentation, you would probably be able to answer your own questions. With kind regards, Mike ________________________________ From: Amila Silva [mailto:amilac@hsenidmobile.com] Sent: 23 June 2009 10:58 To: Anstis, Michael (M.) Subject: Re: [rules-users] How to execute the SQL query using drools Thanks Michael, another thing can you tell me how can select data set or execute some queries using the drools ? can we have method to store rules as humand readable format instead of binary format? My requirement is to have rule engine , basically there are some set of rules which used to execute some queries and populate some tables depend on the situations, other than that need have every flexible rule engine instead of hard coded rule in java? what you think,is it possible to use drools for my requirement. thank you very much amila On Tue, Jun 23, 2009 at 2:29 PM, Anstis, Michael (M.) <manstis1(a)ford.com&gt; wrote: Let me see if I understand correctly. You want the user to be able to define the SQL query (table, field list, predicates) and have the resulting SQL executed within Drools? Is this your only requirement for the rules engine; if so have you thought a rules engine might not be your best option. ________________________________ From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Amila Silva Sent: 23 June 2009 09:49 To: rules-users(a)lists.jboss.org Subject: [rules-users] How to execute the SQL query using drools Hi Anstis, I'm creating a rule engine which is basically a SQL query executor. for that i need to have a drool file where i can add new rules to build the different query criteria. user should be able to create new selection criteria. is there any way that i can define sql queries in side the drool files. thanks -- Thanks, Regrads, Amila Silva, Associate Software Engineer hSenid Mobile Solutions Phone : +94-77-9983894 Fax : +94-11-2673 845 Web: http://www.hSenid.com Make it Happen http://www.hSenidMobile.com Enabling the Mobile World Disclaimer: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. The content and opinions contained in this email are not necessarily those of hSenid Software International. If you have received this email in error please contact the sender.