Thomas yes I am going to try it myself. Im trying to make exploratory
progress so I want to get it working on our development database. i have
taken the snippets from the wiki on oracle integration and integrated them
here.
some questions: -- it seems that the workspace and versioning configuration
elements have filesystem and persistencemanager subelements.
I want the persistencemanager to point to oracle right? I don't understand
where the filesystem configuration element fits in. what is it doing? If
the PM points to oracle why is there even a filesystem element? thanx
here is the configuration i am working on.
<Workspace name="${wsp.name}">
<FileSystem
class="org.apache.jackrabbit.core.fs.mem.MemoryFileSystem" />
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.JNDIOracleDatabasePersistenceManager">
<param name="path" value="${wsp.home}/db"/>
<param name="dataSourceLocation" value="jdbc/jcr"/>
<param name="checkValidConnectionSQL" value="select 0 from dual"
/>
<param name="schemaObjectPrefix" value="pm_def"/>
<param name="schema" value="oracle" />
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Workspace>
<Versioning rootPath="${rep.home}/versions">
<FileSystem
class="org.apache.jackrabbit.core.fs.mem.MemoryFileSystem" />
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.JNDIOracleDatabasePersistenceManager">
<param name="path" value="${wsp.home}/db"/>
<param name="dataSourceLocation" value="jdbc/jcr"/>
<param name="checkValidConnectionSQL" value="select 0 from dual"
/>
<param name="schemaObjectPrefix" value="pm_def"/>
<param name="schema" value="oracle" />
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
</Versioning>
On Thu, Aug 7, 2008 at 3:07 PM, Thomas Müller <[EMAIL PROTECTED]>wrote:
> Hi,
>
> > I am talking about a db backed repo -- all content goes in the database.
> > was told that even with this configuration, a repo-home dir is still used
> on
> > the file system and must be restored with the db in the event of a crash.
>
> > The search index is in the repo home, but what else?
>
> Nothing else. Jukka wrote about "some relatively static configuration
> files", but those are stored in the database when using a database
> file system.
>
> What about you try it yourself? Install Jackrabbit, change the
> configuration to use DerbyFileSystem everywhere, as in:
>
> Repository level:
> <FileSystem class="org.apache.jackrabbit.core.fs.db.DerbyFileSystem">
> <param name="url" value="jdbc:derby:${rep.home}/db;create=true"/>
> </FileSystem>
>
> Workspace level:
> <FileSystem
> class="org.apache.jackrabbit.core.fs.db.DerbyFileSystem">
> <param name="url" value="jdbc:derby:${wsp.home}/db;create=true"/>
> </FileSystem>
>
> Versioning level:
> <FileSystem
> class="org.apache.jackrabbit.core.fs.db.DerbyFileSystem">
> <param name="url"
> value="jdbc:derby:${rep.home}/version/db;create=true"/>
> </FileSystem>
>
> Regards,
> Thomas
>
--
---------------------
Michael Harris
