<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3492" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009>The best I think you could achieve would be something
like this...</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009>Global ExecuterService
es; </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009>rule "execute some SQL"</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> when</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> $q :
Query()</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> $f :
Fields(query == $q)</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> $t :
Tables(query == $q)</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> $p :
Predicates(query == $q)</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> then</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009>
es.execute($f, $t, $p);</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009> end</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=162475908-23062009>Still not sure if a rules engine is your best option,
if I understand your use case correctly.</SPAN></FONT></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Anstis, Michael (M.) <BR><B>Sent:</B> 23
June 2009 10:00<BR><B>To:</B> 'amilac@hsenidmobile.com'; 'Rules Users
List'<BR><B>Subject:</B> RE: [rules-users] How to execute the SQL query using
drools<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=180485308-23062009><FONT face=Arial
color=#0000ff size=2>Let me see if I understand correctly.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=180485308-23062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=180485308-23062009><FONT face=Arial
color=#0000ff size=2>You want the user to be able to define the SQL query
(table, field list, predicates) and have the resulting SQL executed within
Drools?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=180485308-23062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=180485308-23062009><FONT face=Arial
color=#0000ff size=2>Is this your only requirement for the rules engine; if so
have you thought a rules engine might not be your best
option.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rules-users-bounces@lists.jboss.org
[mailto:rules-users-bounces@lists.jboss.org] <B>On Behalf Of </B>Amila
Silva<BR><B>Sent:</B> 23 June 2009 09:49<BR><B>To:</B>
rules-users@lists.jboss.org<BR><B>Subject:</B> [rules-users] How to execute
the SQL query using drools<BR></FONT><BR></DIV>
<DIV></DIV><BR clear=all>Hi <SPAN class=sender>Anstis,<BR> I'm
creating a rule engine which is basically a SQL query executor. for that i
need to have a drool<BR> file where i can add new rules to build the
different query criteria. user should be able to create new selection
criteria.<BR><BR>is there any way that i can define sql queries in side the
drool files.<BR><BR>thanks<BR><BR></SPAN>
<H1><BR></H1><SPAN
class=sender></SPAN><BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>