You have not clearly defined when you want to execute SQL queries.
 
If you want to access a DB from the LHS you can use the "from" keyword. Note the results need to be time-constant i.e. not change on successive calls.
 
If you want to access a DB from the RHS it is plain Java (or MVEL depending upon your rule dialect).
 
See the documentation for more information.


From: rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Amila Silva
Sent: 23 June 2009 07:55
To: rules-users@lists.jboss.org
Subject: [rules-users] How to execute the SQL query using drools



hi All,

I have requirement like to execute the sql queries through drools. is there are way to do it?
please let me know asap.

thanks
amila silva