Re: [rules-users] BRMS in a WAS cluster

Hi Seema, We had initially tried using the BRMS for rules using WAS 6.1 and Oracle in clustered modes. 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. *From:* rules-users-bounces(a)lists.jboss.org [mailto: rules-users-bounces(a)lists.jboss.org] *On Behalf Of *Seema Manivannan *Sent:* Thursday, November 13, 2008 6:15 AM *To:* rules-users(a)lists.jboss.org *Subject:* Re: [rules-users] BRMS in a WAS cluster hi, I would appreciate any replies at least confirming that my approach below is right. Thanks, Seema On Sun, Nov 9, 2008 at 11:16 PM, seemamani <seemamani(a)gmail.com&gt; wrote: We use Drools 4.0.7 in our application which is deployed on a WAS 6.1 cluster and it is working fine. Now we want to deploy the Drools BRMS also in the WAS cluster. I went through the Drools and Jackrabbit mailing lists and documentation. Please confirm if my understanding of how this can be implemented is correct. 1. By default, JackRabbit uses Apache Derby in-memory database which does not support clustering That is correct 2. We need to configure a persistence manager in JackRabbit that stores data in a RDBMS like Oracle 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). 3. I need to follow the instructions for JackRabbit clustering given here http://wiki.apache.org/jackrabbit/Clustering 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. 4. Also, the Drools documentation says that "The BRMS will create the tables the first time it is started up if it is running against a fresh (empty) RDBMS - so its important to note that the user credentials supplied have permissions to create tables (at least initially, on first run, after that they could be locked down)." Is it not possible to create the Oracle tables before running the BRMS (we have permission issues in creating the tables from the application)? I assume that the DDL for creating the tables is available with the JackRabbit distribution. 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. 5. Is there anything else I'm missing? Will BRMS work fine in the cluster with the above setup? 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. Thanks, Seema -- View this message in context: http://www.nabble.com/BRMS-in-a-WAS-cluster-tp20408825p20408825.html Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users MASTEK LTD. Mastek is in NASSCOM's 'India Top 20' Software Service Exporters List. In the US, we're called MAJESCOMASTEK ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users