use jackrabbit JCA

[Matthew Ma]

Does anyone use jackrabbit-jca-1.6.1? I had a problem when use oracle as my 
DbFileSystem, see my repository.xml below.

===========================
<Repository>


    <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
                <param name="driver" value="javax.naming.InitialContext"/>
                <param name="url" value="java:comp/env/jdbc/csis" />
                <param name="schema" value="oracle"/>
                <param name="schemaObjectPrefix" value="J_R_FS_"/>
        </FileSystem>

    <Security appName="Jackrabbit">
        <AccessManager 
class="org.apache.jackrabbit.core.security.SimpleAccessManager">
            <!-- <param name="config" value="${rep.home}/access.xml"/> -->
        </AccessManager>
        <LoginModule 
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
        </LoginModule>
    </Security>


    <Workspaces rootPath="${rep.home}/workspaces" defaultWorkspace="default"/>

    <Workspace name="${wsp.name}">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
                        <param name="driver" 
value="javax.naming.InitialContext"/>
                        <param name="url" value="java:comp/env/jdbc/csis" />
                        <param name="schema" value="oracle"/>
                        <param name="schemaObjectPrefix" 
value="J_PM_${wsp.name}_"/>
                </FileSystem>

        <PersistenceManager 
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
                <param name="driver" value="javax.naming.InitialContext"/>
                <param name="url" value="java:comp/env/jdbc/csis" />
                <param name="schema" value="oracle"/>
                <param name="schemaObjectPrefix" value="J_PM_${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.db.DbFileSystem">
                        <param name="driver" 
value="javax.naming.InitialContext"/>
                        <param name="url" value="java:comp/env/jdbc/csis" />
                        <param name="schema" value="oracle"/>
                        <param name="schemaObjectPrefix" value="J_V_FS_"/>
                </FileSystem>
        

        <PersistenceManager 
class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
                <param name="driver" value="javax.naming.InitialContext"/>
                <param name="url" value="java:comp/env/jdbc/csis" />
                <param name="schema" value="oracle"/>
                <param name="schemaObjectPrefix" value="J_V_PM_"/>
                <param name="externalBLOBs" value="false"/>
        </PersistenceManager>
    </Versioning>


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

the problem I encountered is, when first time to create tables, it throws a 
Tablespace exception, see the exception below,

Non supported SQL92 token at position: 213: tableSpace
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
        at oracle.jdbc.driver.OracleSql.handleToken(OracleSql.java:204)
        at oracle.jdbc.driver.OracleSql.handleODBC(OracleSql.java(Compiled 
Code))



Regards,
Matthew