jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefan Guggisberg" <stefan.guggisb...@gmail.com>
Subject Re: Cannot insert null ("SYSTEM"."REP_FSENTRY"."FSENTRY_NAME")
Date Fri, 16 Mar 2007 11:41:52 GMT
hi,

i noticed a couple of issues with your configuration.

1. is there a specific reason for using OracleFileSystem
instead of LocalFileSystem? generally i wouldn't recommend using
the db file systems as it is a rather advanced setup with some
potential tripping hazards.

there are some legitimate use cases for using the db file system
implementations but in most cases you don't need them.

2. you used conflicting/hardcoded values for the "schemaObjectPrefix" parameter.
schema objects used by a specific persistence manager/file system instance are
prefixed with this value in oder to avoid name collisions.

3. the workspace name in your workspace template element is hardcoded;
it should be the placeholder variable "$wsp.name".

4. you used the oracle "system" account. it's always a good idea to use
a dedicated user/schema per repository instance.



i appended a sample repository.xml that you can use. i used the
jdbc url from your config. however, the sample assumes an oracle
user/schema "repo" with password "repo".

try the following:

- delete the contents of your repository home directory (incl. subdirs)
- copy the appended repository.xml to your repository home directory
- create an oracle user/schema with name "repo" and password "repo"
- start your test application


cheers
stefan


sample repository.xml:


<?xml version="1.0"?>
<Repository>
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
        <param name="path" value="${rep.home}/repository"/>
    </FileSystem>

    <Security appName="Jackrabbit">
        <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="${wsp.name}">
        <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${wsp.home}"/>
        </FileSystem>

        <PersistenceManager
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
            <param name="url"
value="jdbc:oracle:thin://@192.168.12.112:1521:simge"/>
            <param name="user" value="repo"/>
            <param name="password" value="repo"/>
            <param name="schemaObjectPrefix" value="${wsp.name}_"/>
            <param name="externalBLOBs" value="false"/>
        </PersistenceManager>

        <SearchIndex
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
            <param name="path" value="${wsp.home}/index"/>
        </SearchIndex>
    </Workspace>

    <Versioning rootPath="${rep.home}/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
            <param name="path" value="${rep.home}/version"/>
        </FileSystem>

        <PersistenceManager
class="org.apache.jackrabbit.core.state.db.OraclePersistenceManager">
            <param name="url"
value="jdbc:oracle:thin://@192.168.12.112:1521:simge"/>
            <param name="user" value="repo"/>
            <param name="password" value="repo"/>
            <param name="schemaObjectPrefix" value="version_"/>
            <param name="externalBLOBs" value="false"/>
        </PersistenceManager>
    </Versioning>
</Repository>

Mime
View raw message