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: [email protected]
[mailto:[email protected]] On Behalf Of san_hegde
Sent: 01 October 2013 18:12
To: [email protected]
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
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
<?xml version="1.0"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.4//EN"
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd";>
<!-- Example Repository Configuration File -->
<Repository>
<!--
virtual file system where the repository stores global state
(e.g. registered namespaces, custom node types, etc.)
-->
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value="FS_"/>
</FileSystem>
<!--
security configuration
-->
<Security appName="Jackrabbit">
<!--
access manager:
class: FQN of class implementing the AccessManager interface
-->
<AccessManager class="org.apache.jackrabbit.core.security.simple.SimpleAccessManager">
<!-- <param name="config" value="${rep.home}/access.xml"/> -->
</AccessManager>
<LoginModule class="org.apache.jackrabbit.core.security.simple.SimpleLoginModule">
<!-- <param name="defaultUserId" value="superuser"/> -->
</LoginModule>
</Security>
<!--
location of workspaces root directory and name of default workspace
-->
<Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>
<!--
workspace configuration template:
used to create the initial workspace if there's no workspace yet
-->
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value="FS_WS_${wsp.name}_"/>
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager interface
-->
<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="schema" value="oracle"/>
<param name="tableSpace" value=""/>
<param name="externalBLOBs" value="false"/>
<param name="schemaObjectPrefix" value="PM_WS_${wsp.name}_" />
</PersistenceManager>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
<param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the respective
persistence manager
-->
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value="Versioning_FS_"/>
</FileSystem>
<!--
Configures the persistence manager to be used for persisting version state.
Please note that the current versioning implementation is based on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="schema" value="oracle"/>
<param name="tableSpace" value=""/>
<param name="externalBLOBs" value="false"/>
<param name="schemaObjectPrefix" value="Versioning_PM_" />
</PersistenceManager>
</Versioning>
<DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="databaseType" value="oracle"/>
<param name="minRecordLength" value="1024"/>
<param name="maxConnections" value="3"/>
<param name="copyWhenReading" value="true"/>
<param name="tablePrefix" value=""/>
<param name="schemaObjectPrefix" value="ds_"/>
</DataStore>
<Cluster id="node1">
<Journal class="org.apache.jackrabbit.core.journal.OracleDatabaseJournal">
<param name="driver" value="javax.naming.InitialContext"/>
<param name="url" value="java:jboss/datasources/jdbc/jbpmStagingRWDS"/>
<param name="databaseType" value="oracle"/>
<param name="schemaObjectPrefix" value="journal_"/>
</Journal>
</Cluster>
<!--
Search index for content that is shared repository wide
(/jcr:system tree, contains mainly versions)
-->
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${rep.home}/repository/index"/>
<param name="textFilterClasses" value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.jackrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtractor,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.jackrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTMLTextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="true"/>
</SearchIndex>
</Repository>
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
