Return-Path: 
 <users-return-14543-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org
Received: (qmail 15690 invoked from network); 1 Mar 2010 20:59:32 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 1 Mar 2010 20:59:32 -0000
Received: (qmail 50095 invoked by uid 500); 1 Mar 2010 20:59:29 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 50075 invoked by uid 500); 1 Mar 2010 20:59:29 -0000
Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:users@jackrabbit.apache.org>
List-Id: <users.jackrabbit.apache.org>
Reply-To: users@jackrabbit.apache.org
Delivered-To: mailing list users@jackrabbit.apache.org
Received: (qmail 50066 invoked by uid 99); 1 Mar 2010 20:59:29 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Mar 2010 20:59:29 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [206.130.172.24] (HELO tuli-1x.inet.toronto.ca)
 (206.130.172.24)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Mar 2010 20:59:19 +0000
Received: from atlas-2-v1.inet.toronto.ca (atlas-2-v1-s.inet.toronto.ca
 [137.15.73.35])
	by tuli-1x.inet.toronto.ca (BorderWare Security Platform) with ESMTP id
 596922190D13B8BF
	for <users@jackrabbit.apache.org>; Mon,  1 Mar 2010 15:58:57 -0500 (EST)
Received: from gwia.toronto.ca (vs-563-cotgate.corp.toronto.ca
 [137.15.55.154])
	by atlas-2-v1.inet.toronto.ca (8.13.8+Sun/8.13.8) with ESMTP id
 o21KwvaY018125
	for <users@jackrabbit.apache.org>; Mon, 1 Mar 2010 15:58:57 -0500 (EST)
Received: from COTGATE-MTA by gwia.toronto.ca
	with Novell_GroupWise; Mon, 01 Mar 2010 15:58:57 -0500
Message-Id: <4B8BE41A.17B8.0005.0@toronto.ca>
X-Mailer: Novell GroupWise Internet Agent 7.0.3 
Date: Mon, 01 Mar 2010 15:58:52 -0500
From: "Matthew Ma" <mma2@toronto.ca>
To: <users@jackrabbit.apache.org>
Subject: use jackrabbit JCA
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Scanned-By: MIMEDefang 2.58 on 137.15.48.35
X-Virus-Checked: Checked by ClamAV on apache.org


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

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
<Repository>


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

    <Security appName=3D"Jackrabbit">
        <AccessManager class=3D"org.apache.jackrabbit.core.security.SimpleA=
ccessManager">
            <!-- <param name=3D"config" value=3D"${rep.home}/access.xml"/> =
-->
        </AccessManager>
        <LoginModule class=3D"org.apache.jackrabbit.core.security.SimpleLog=
inModule">
        </LoginModule>
    </Security>


    <Workspaces rootPath=3D"${rep.home}/workspaces" defaultWorkspace=3D"def=
ault"/>

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

        <PersistenceManager class=3D"org.apache.jackrabbit.core.persistence=
.bundle.OraclePersistenceManager">
        	<param name=3D"driver" value=3D"javax.naming.InitialContext=
"/>
        	<param name=3D"url" value=3D"java:comp/env/jdbc/csis" />
        	<param name=3D"schema" value=3D"oracle"/>
          	<param name=3D"schemaObjectPrefix" value=3D"J_PM_${wsp.name=
}_"/>
          	<param name=3D"externalBLOBs" value=3D"false"/>
        </PersistenceManager>

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


    <Versioning rootPath=3D"${rep.home}/version">

    	<FileSystem class=3D"org.apache.jackrabbit.core.fs.db.DbFileSystem"=
>
			<param name=3D"driver" value=3D"javax.naming.Initia=
lContext"/>
			<param name=3D"url" value=3D"java:comp/env/jdbc/csi=
s" />
			<param name=3D"schema" value=3D"oracle"/>
			<param name=3D"schemaObjectPrefix" value=3D"J_V_FS_=
"/>
		</FileSystem>
       =20

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


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

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