These are JackRabbit tables. You would actually need to understand how Drools make's use of the JCR to use them directly.<br><br><div class="gmail_quote">On Fri, Jan 23, 2009 at 11:19 AM, Ashish Soni <span dir="ltr"><<a href="mailto:learnspring@gmail.com">learnspring@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Thanks a lot for the help.<br><br>Also i see below tables created in the database not sure which table need to use to pulling the rules.<br>
<br>DEFAULT_BINVAL<br>DEFAULT_NODE<br>DEFAULT_PROP<br>DEFAULT_REFS<br><br><br>REP_FSENTRY<br>
REP_VERSION_FSENTRY<br><br><br>VERSION_BINVAL<br>VERSION_NODE<br>VERSION_PROP<br>VERSION_REFS<br><br><br>Please help.<br><br>Regards,<br>Ashish<br><br><div class="gmail_quote">On Fri, Jan 23, 2009 at 10:26 AM, techy <span dir="ltr"><<a href="mailto:techluver007@gmail.com" target="_blank">techluver007@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
I do it this way...hope this may help..<br>
List<Rule> rules = dao.getAllRules();//reads RULE table and returns list of<br>
rule Object<br>
for (Rule rule : rules)<br>
{<br>
try<br>
{<br>
Clob ruleClob = rule.getRuleContent(); //I store<br>
complete rule info in this db clob column<br>
if (ruleClob != null<br>
&& StringUtils.isNotBlank(ruleClob.toString()))<br>
{<br>
builder.addPackageFromDrl(ruleClob<br>
.getCharacterStream());//add each<br>
rule into package<br>
<br>
<br>
<br>
}<br>
<br>
}<br>
<br>
//pkg = builder.getPackage();<br>
//ruleBase.addPackage(pkg)<br>
<div><div></div><div><br>
<br>
<br>
learndrools wrote:<br>
><br>
> Hi All ,<br>
><br>
> I am able to configure oracle database in drools but now i am not able to<br>
> find how can i load rules from the DB and execute them , I gone through<br>
> the<br>
> documentation but not able to get much information or might be i am<br>
> missing<br>
> something.<br>
><br>
> If any one can provide me a example or some pointer ,hints then it would<br>
> be<br>
> helpful.<br>
><br>
><br>
> Regards,<br>
> Ashish<br>
><br>
</div></div>> _______________________________________________<br>
> rules-users mailing list<br>
> <a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
><br>
><br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://www.nabble.com/How-to-Access-and-Execute-Rules-from-Database-tp21626109p21626458.html" target="_blank">http://www.nabble.com/How-to-Access-and-Execute-Rules-from-Database-tp21626109p21626458.html</a><br>
Sent from the drools - user mailing list archive at Nabble.com.<br>
<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</font></blockquote></div><br>
<br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br>