<!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=219441308-23062009><FONT face=Arial
color=#0000ff size=2>You have not clearly defined when you want to execute SQL
queries.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2>If you want to access a DB from the RHS it is plain Java
(or MVEL depending upon your rule dialect).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=219441308-23062009><FONT face=Arial
color=#0000ff size=2>See the documentation for more
information.</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 07:55<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><BR>hi All,<BR><BR>I have requirement like to execute
the sql queries through drools. is there are way to do it?<BR>please let me
know asap.<BR><BR>thanks<BR>amila silva<BR></BLOCKQUOTE></BODY></HTML>