Re: [rules-users] --Guvnor in Cluster mode with Oracle DB failing

Hi, Attached is my repository configuration with Oracle11. Its working perfectly fine for me. I have two nodes in cluster and its working perfectly great. I have followed the steps mentioned in http://wiki.apache.org/jackrabbit/Clustering Easily add new cluster nodes *Shutdown one of your instances *Get the current revision number that instance was from your database *Copy your whole Jackrabbit repository directory to another server/location *Start your original Jackrabbit again *Change the copied repository.xml with a new nodename in your clusterconfig *Add that nodename to your DB in JOURNAL_LOCAL_REVISIONS with the number from the original instance *Start your new Jackrabbit instance (or keep it for backup purposes) Regards, Zahid Ahmed Zaid_ahmmed"Hotmail.com -----Original Message----- From: rules-users-bounces(a)lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org] On Behalf Of san_hegde Sent: 01 October 2013 18:12 To: rules-users(a)lists.jboss.org Subject: [rules-users] --Guvnor in Cluster mode with Oracle DB failing Hi, I am trying to deploy Guvnor in Clustered Node, using Oracle 11 I am getting Caused By: java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype I am able to deploy in Non-cluster respository.. Any idea on why it is throwing that exception in cluster.. Below is my cluster configuration in repository xml.. <Cluster id="node1" syncDelay="2000"> <Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal"> param name="revision" value="${rep.home}/revision.log" /> param name="driver" value="oracle.jdbc.xa.client.OracleXADataSource" /> param name="url" value="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=gvu0513.austin.hp.com)(PORT=1525))(ADDRESS=(PROTOCOL=TCP)(HOST=gvu0514.austin.hp.com)(PORT=1525)))(CONNECT_DATA=(SERVICE_NAME = BDDBD)))" /> param name="user" value="abc"/> param name="password" value="abc"/> </Journal> </Cluster> -- View this message in context: http://drools.46999.n3.nabble.com/Guvnor-in-Cluster-mode-with-Oracle-DB-f... Sent from the Drools: User forum mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users