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

[Zahid Ahmed]

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 at lists.jboss.org [mailto:rules-users-bounces at lists.jboss.org] On Behalf Of san_hegde
Sent: 01 October 2013 18:12
To: rules-users at 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-failing-tp4026214.html
Sent from the Drools: User forum mailing list archive at Nabble.com.
_______________________________________________
rules-users mailing list
rules-users at lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: repository.xml
Type: text/xml
Size: 7687 bytes
Desc: repository.xml
Url : http://lists.jboss.org/pipermail/rules-users/attachments/20131002/1e1d2944/attachment.xml