jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew Ma" <m...@toronto.ca>
Subject use jackrabbit JCA
Date Mon, 01 Mar 2010 20:58:52 GMT

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


Mime
View raw message