Vikrant,<br><br>Thanks for the prompt reply. It would be surely helpful if you can post the samples which worked for you. What are the license and support issues that made you decide against BRMS? My understanding is that we need to enable JackRabbit clustering when we have JackRabbit running in all nodes of the app server cluster. Oracle RAD would handle only clustering at the DB level. Please correct me if I'm wrong.<br>
<br>Thanks,<br>Seema<br><br><div class="gmail_quote">On Thu, Nov 13, 2008 at 1:18 PM, Vikrant Yagnick <span dir="ltr"><<a href="mailto:VikrantY@mastek.com">VikrantY@mastek.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;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hi Seema,</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">We had initially tried using the BRMS for rules using WAS 6.1
and Oracle in clustered modes. </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">While, we are not going for the BRMS right now due to license
and support issues, from that experience I can answer some of the questions,
below.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:rules-users-bounces@lists.jboss.org" target="_blank">rules-users-bounces@lists.jboss.org</a>
[mailto:<a href="mailto:rules-users-bounces@lists.jboss.org" target="_blank">rules-users-bounces@lists.jboss.org</a>] <b>On Behalf Of </b>Seema
Manivannan<br>
<b>Sent:</b> Thursday, November 13, 2008 6:15 AM<br>
<b>To:</b> <a href="mailto:rules-users@lists.jboss.org" target="_blank">rules-users@lists.jboss.org</a><br>
<b>Subject:</b> Re: [rules-users] BRMS in a WAS cluster</span></p>
</div><div class="Ih2E3d">
<p> </p>
<p style="margin-bottom: 12pt;">hi,<br>
<br>
I would appreciate any replies at least confirming that my approach below is
right.<br>
<br>
Thanks,<br>
Seema</p>
</div><div><div class="Ih2E3d">
<p>On Sun, Nov 9, 2008 at 11:16 PM, seemamani <<a href="mailto:seemamani@gmail.com" target="_blank">seemamani@gmail.com</a>> wrote:</p>
<p><br>
We use Drools 4.0.7 in our application which is deployed on a WAS 6.1 cluster<br>
and it is working fine. Now we want to deploy the Drools BRMS also in the<br>
WAS cluster. I went through the Drools and Jackrabbit mailing lists and<br>
documentation. Please confirm if my understanding of how this can be<br>
implemented is correct.<br>
<br>
1. By default, JackRabbit uses Apache Derby in-memory database which does<br>
not support clustering<span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><p><span style="font-size: 11pt; color: rgb(31, 73, 125);">That is correct</span></p><div class="Ih2E3d">
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><br>
2. We need to configure a persistence manager in JackRabbit that stores data<br>
in a RDBMS like Oracle<span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Yes. If you need a sample, I can send it to you. (Though, I am
sure there is a lot of material on this on the web). </span></p><div class="Ih2E3d">
<p><br>
3. I need to follow the instructions for JackRabbit clustering given here<br>
<a href="http://wiki.apache.org/jackrabbit/Clustering" target="_blank">http://wiki.apache.org/jackrabbit/Clustering</a><span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><p><span style="font-size: 11pt; color: rgb(31, 73, 125);">I am not sure, why you need Jack Rabbit clustering. If the
tables are stored in the database, then I am assuming RAC should handle
clustering at the DB level. Though, do correct me if I am wrong. </span></p><div class="Ih2E3d">
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><br>
4. Also, the Drools documentation says that "The BRMS will create
the<br>
tables the first time it is started up if it is running against a fresh<br>
(empty) RDBMS - so its important to note that the user credentials supplied<br>
have permissions to create tables (at least initially, on first run, after<br>
that they could be locked down)."<br>
Is it not possible to create the Oracle tables before running the BRMS (we<br>
have permission issues in creating the tables from the application)? I<br>
assume that the DDL for creating the tables is available with the JackRabbit<br>
distribution.<span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><p><span style="font-size: 11pt; color: rgb(31, 73, 125);">One Q&D way may be to just create the tables in a test
database and then make the schema into DDL scripts for use before installation.
</span></p><div class="Ih2E3d">
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><br>
5. Is there anything else I'm missing? Will BRMS work fine in the cluster<br>
with the above setup?<span style="color: rgb(31, 73, 125);"></span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><p><span style="color: rgb(31, 73, 125);">My assumption is that the BRMS
is just a web-app using the database as it's back-end and hence do not
know of any issues it could face. </span><br></p><div class="Ih2E3d">
<br>
Thanks,<br>
Seema<br>
<span style="color: rgb(136, 136, 136);">--<br>
View this message in context: <a href="http://www.nabble.com/BRMS-in-a-WAS-cluster-tp20408825p20408825.html" target="_blank">http://www.nabble.com/BRMS-in-a-WAS-cluster-tp20408825p20408825.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></span></div>
</div>
<p style="margin-bottom: 12pt;"><br>
<br>
</p>
<table style="background: white none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" border="0" cellpadding="0">
<tbody><tr>
<td style="padding: 0.75pt;"></td>
</tr>
</tbody></table>
<p> </p>
</div>
<br><br><table style="color: black;" bgcolor="white"><tbody><tr><td><br>MASTEK LTD.<br>
Mastek is in NASSCOM's 'India Top 20' Software Service Exporters List.<br>
In the US, we're called MAJESCOMASTEK<br>
<br>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
Opinions expressed in this e-mail are those of the individual and not that of Mastek Limited, unless specifically indicated to that effect. Mastek Limited does not accept any responsibility or liability for it. This e-mail and attachments (if any) transmitted with it are confidential and/or privileged and solely for the use of the intended person or entity to which it is addressed. Any review, re-transmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. This e-mail and its attachments have been scanned for the presence of computer viruses. It is the responsibility of the recipient to run the virus check on e-mails and attachments before opening them. If you have received this e-mail in error, kindly delete this e-mail from desktop and server.<br>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br>
</td></tr></tbody></table></div>
<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>