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(a)lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] On Behalf Of Amila Silva
Sent: 23 June 2009 07:55
To: rules-users(a)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