I'm having trouble finding information about the configuration file,
especially in regards to databases.
I'm want to use oracle 9 for my persistence manager and file system.
My questions:
Should every filesystem and persistence manager use different tables?
Can they share tables? Is it a problem to share them?
Below is my initial repository xml (sorry it's long). Am I on the right
track?
Btw: I can't allow jackrabbit to create the tables (security
constraints) so I need them created beforehand.
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD
Jackrabbit 1.4//EN"
"http://jackrabbit.apache.org/dtd/repository-1.4.dtd";>
<Repository>
<FileSystem
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
<!-- TODO: fill in URL -->
<param name="user" value=""/>
<!-- TODO: fill in username -->
<param name="password" value=""/>
<!-- TODO: fill in password -->
<param name="schemaObjectPrefix" value=""/>
<param name="tableSpace" value=""/>
<!-- TODO: fill in tablespace -->
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<!--
This will change when we switch to JNDI.
Driver will be a class that is assignable to
javax.naming.Context
URL will be the name of the jndi resource
-->
</FileSystem>
<Security appName="Admin">
<AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager"/>
<LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule"/>
</Security>
<Workspaces rootPath="${rep.home}/workspaces"
defaultWorkspace="default"/>
<Workspace name="default">
<FileSystem
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
<!-- TODO: fill in URL -->
<param name="user" value=""/>
<!-- TODO: fill in username -->
<param name="password" value=""/>
<!-- TODO: fill in password -->
<param name="schemaObjectPrefix" value=""/>
<param name="tableSpace" value=""/>
<!-- TODO: fill in tablespace -->
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<!--
This will change when we switch to JNDI.
Driver will be a class that is assignable to
javax.naming.Context
URL will be the name of the jndi resource
-->
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceM
anager">
<param name="bundleCacheSize" value="8"/>
<param name="consistencyCheck" value="false"/>
<param name="minBlobSize" value="16384"/>
<param name="driver" value="oracle.jdbc.OracleDriverr"/>
<param name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:xe"/> <!-- TODO: fill in URL -->
<param name="user" value="crx"/> <!-- TODO: fill in user -->
<param name="password" value="crx"/> <!-- TODO: fill in
password -->
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value=""/>
<param name="errorHandling" value=""/>
<param name="tableSpace" value=""/> <!-- TODO: fill in table
space -->
</PersistenceManager>
<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.ja
ckrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.
MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtract
or,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.ja
ckrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTML
TextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="false"/>
</SearchIndex>
</Workspace>
<Versioning rootPath="${rep.home}/version">
<FileSystem
class="org.apache.jackrabbit.core.fs.db.OracleFileSystem">
<param name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:orcl"/>
<!-- TODO: fill in URL -->
<param name="user" value=""/>
<!-- TODO: fill in username -->
<param name="password" value=""/>
<!-- TODO: fill in password -->
<param name="schemaObjectPrefix" value=""/>
<param name="tableSpace" value=""/>
<!-- TODO: fill in tablespace -->
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<!--
This will change when we switch to JNDI.
Driver will be a class that is assignable to
javax.naming.Context
URL will be the name of the jndi resource
-->
</FileSystem>
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.Oracle9PersistenceM
anager">
<param name="bundleCacheSize" value="8"/>
<param name="consistencyCheck" value="false"/>
<param name="minBlobSize" value="16384"/>
<param name="driver" value="oracle.jdbc.OracleDriverr"/>
<param name="url"
value="jdbc:oracle:thin:@127.0.0.1:1521:xe"/> <!-- TODO: fill in URL -->
<param name="user" value="crx"/> <!-- TODO: fill in user -->
<param name="password" value="crx"/> <!-- TODO: fill in
password -->
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value=""/>
<param name="errorHandling" value=""/>
<param name="tableSpace" value=""/> <!-- TODO: fill in table
space -->
</PersistenceManager>
</Versioning>
<SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="default/index"/>
<param name="textFilterClasses"
value="org.apache.jackrabbit.extractor.MsWordTextExtractor,org.apache.ja
ckrabbit.extractor.MsExcelTextExtractor,org.apache.jackrabbit.extractor.
MsPowerPointTextExtractor,org.apache.jackrabbit.extractor.PdfTextExtract
or,org.apache.jackrabbit.extractor.OpenOfficeTextExtractor,org.apache.ja
ckrabbit.extractor.RTFTextExtractor,org.apache.jackrabbit.extractor.HTML
TextExtractor,org.apache.jackrabbit.extractor.XMLTextExtractor"/>
<param name="extractorPoolSize" value="2"/>
<param name="supportHighlighting" value="false"/>
</SearchIndex>
</Repository>
