Hi,
I have been trying to configure Jackrabbit with Oracle. I get exception while
schema check is performed for version table in cluster.
While the cluster configuration is being initialized.It calls the init() method
in DataBaseJournal class. In there it calls checkLocalRevisionSchema(); That
method in turns call CheckSchemaOperation .run() to check whether the
LOCAL_REVISIONS table exists if not it creates it. At first time it does not
have the table so it tries to create the table with query
create table ${schemaObjectPrefix}JOURNAL (REVISION_ID number(20,0) NOT NULL,
JOURNAL_ID varchar(255), PRODUCER_ID varchar(255), REVISION_DATA blob)
${tablespace}
Before executing the query the variable c${schemOBjectPrefix} is replaced with
PBVP_Journal but the ${tablespace} is being replaced. I am not sure what I am
doing wrong. I did
The whole repository.xml is attached.
My file system and persistence manager configuration looks like
<Versioning rootPath="${rep.home}/version">
<FileSystem class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="driver"
value="javax.naming.InitialContext"/>
<param name="url"
value="java:/jcr/repositoryDB"/>
<param name="schemaObjectPrefix"
value="PBVP_version_"/>
<param name="schema"
value="oracle"/>
<param name="tablespace"
value="default"/>
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.pool.OraclePersistenceManager">
<param name="driver"
value="javax.naming.InitialContext"/>
<param name="url"
value="java:/jcr/repositoryDB"/>
<param name="databaseType"
value="oracle"/>
<param name="schemaObjectPrefix"
value="PBVP_version_"/>
<param name="bundleCacheSize"
value="32"/>
<param name="tableSpace"
value="default"/>
</PersistenceManager>
</Versioning>
My cluster configuration looks like
<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="javax.naming.InitialContext"/>
<param name="url"
value="java:/jcr/repositoryDB"/>
<param name="schemaObjectPrefix"
value="PBVP_journal_"/>
<param name="databaseType"
value="oracle"/>
<param name="schemaCheckEnabled"
value="false"/>
<param name="tablespace"
value="default"/>
</Journal>
</Cluster>
Thanks & Regards
Prasad Bodapati, Software Engineer
Pitney Bowes Software
6 Hercules Way, Leavesden Park, Watford, Herts WD25 7GS
D: +441923 279174 | M: +447543399223
www.pb.com/software<http://www.pb.com/software>
prasad.bodap...@pb.com<mailto:maggie.jo...@pb.com>
Every connection is a new opportunity(tm)
[Pitney Bowes]
Please consider the environment before printing or forwarding this email. If
you do print this email, please recycle the paper.
This email message may contain confidential, proprietary and/or privileged
information. It is intended only for the use of the intended recipient(s). If
you have received it in error, please immediately advise the sender by reply
email and then delete this email message. Any disclosure, copying, distribution
or use of the information contained in this email message to or by anyone other
than the intended recipient is strictly prohibited.
________________________________
