<!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><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></BODY></HTML>