[rules-users] How to execute the SQL query using drools

[Anstis, Michael (M.)]

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 at 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 at ford.com> 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 at lists.jboss.org
[mailto:rules-users-bounces at lists.jboss.org] On Behalf Of Amila Silva
			Sent: 23 June 2009 09:49
			To: rules-users at 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.
	
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20090623/f0bde267/attachment.html