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-boun...@lists.jboss.org
[mailto:rules-users-boun...@lists.jboss.org] On Behalf Of san_hegde
Sent: 01 October 2013 18:12
To: rules-users@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..
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"/>
--
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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
http://jackrabbit.apache.org/dtd/repository-1.4.dtd";>
___
rules-users mailing list
rules-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users