Return-Path: 
 <dev-return-7203-apmail-jackrabbit-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org
Received: (qmail 87566 invoked from network); 25 May 2006 08:30:58 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 May 2006 08:30:58 -0000
Received: (qmail 62821 invoked by uid 500); 25 May 2006 08:30:57 -0000
Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org
Received: (qmail 62786 invoked by uid 500); 25 May 2006 08:30:57 -0000
Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:dev@jackrabbit.apache.org>
List-Id: <dev.jackrabbit.apache.org>
Reply-To: dev@jackrabbit.apache.org
Delivered-To: mailing list dev@jackrabbit.apache.org
Received: (qmail 62774 invoked by uid 99); 25 May 2006 08:30:56 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 May 2006 01:30:56 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [216.173.237.164] (HELO mail26a.sbc-webhosting.com)
 (216.173.237.164)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 25 May 2006 01:30:55 -0700
Received: from mx11.stngva01.us.mxservers.net (204.202.242.100)
	by mail26a.sbc-webhosting.com (RS ver 1.0.95vs) with SMTP id 2-0191005832
	for <dev@jackrabbit.apache.org>; Thu, 25 May 2006 04:30:33 -0400 (EDT)
Received: from www.macnica.com [64.143.71.112] (EHLO [192.168.1.66])
	by mx11.stngva01.us.mxservers.net (mxl_mta-1.3.8-10p4) with ESMTP id
 cea65744.29414.299.mx11.stngva01.us.mxservers.net;
	Thu, 25 May 2006 04:29:32 -0400 (EDT)
Mime-Version: 1.0 (Apple Message framework v750)
In-Reply-To: <90a8d1c00605250114h273671ddrc3dbd09e96636e0b@mail.gmail.com>
References: <18987344.1148462309782.JavaMail.jira@brutus>
 <7CE73644-C50C-411B-8B1A-9C3F60C6FDAF@macnica.com>
 <90a8d1c00605250114h273671ddrc3dbd09e96636e0b@mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <98642197-76F2-46BF-A17F-FBD94989E505@macnica.com>
Content-Transfer-Encoding: 7bit
From: Nicolas Modrzyk <Nicolas.Modrzyk@macnica.com>
Subject: Re: mysql for filesystem
Date: Thu, 25 May 2006 17:30:29 +0900
To: dev@jackrabbit.apache.org
X-Mailer: Apple Mail (2.750)
X-Spam: [F=0.1293041663; heur=0.500(-9200); stat=0.129;
 spamtraq-heur=0.500(2006052411)]
X-MAIL-FROM: <nicolas.modrzyk@macnica.com>
X-SOURCE-IP: [64.143.71.112]
X-Loop-Detect: 1
X-DistLoop-Detect: 1
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

HI Stefan,

Thank you for your quick answer. See below for my full configuration.  
I don't have the full strack trace anymore, I will try to reproduce it.

Does that mean it is better to simply have the persistence manager  
using the database, but keeping the FileSystem as regular files ?

Regards,

Nicolas,

============= Jackrabbit configuration file =================
<Repository>
         <FileSystem  
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
             <param name="driver" value="com.mysql.jdbc.Driver"/>
             <param name="url" value="jdbc:mysql:///test"/>
             <param name="schema" value="mysql"/>
             <param name="user" value="xxx"/>
             <param name="schemaObjectPrefix" value="rep_"/>
         </FileSystem>
     <Security appName="Jackrabbit">
         <AccessManager  
class="org.apache.jackrabbit.core.security.SimpleAccessManager"></ 
AccessManager>
         <LoginModule  
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
             <param name="anonymousId" value="anonymous"/>
         </LoginModule>
     </Security>
     <Workspaces rootPath="${rep.home}/workspaces"  
defaultWorkspace="default"/>
     <Workspace name="default">
         <FileSystem  
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
             <param name="path" value="${wsp.home}/default" />
         </FileSystem>
         <PersistenceManager  
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
             <param name="driver" value="com.mysql.jdbc.Driver"/>
             <param name="url" value="jdbc:mysql:///test"/>
             <param name="schema" value="mysql"/>
             <param name="user" value="xxx"/>
             <param name="schemaObjectPrefix" value="${wsp.name}_"/>
             <param name="externalBLOBs" value="false"/>
         </PersistenceManager>
         <SearchIndex  
class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
             <param name="textFilterClasses"
                     
value="org.apache.jackrabbit.core.query.MsExcelTextFilter,org.apache.jac 
krabbit.core.query.MsPowerPointTextFilter,org.apache.jackrabbit.core.que 
ry.MsWordTextFilter,org.apache.jackrabbit.core.query.PdfTextFilter,org.a 
pache.jackrabbit.core.query.HTMLTextFilter,org.apache.jackrabbit.core.qu 
ery.XMLTextFilter,org.apache.jackrabbit.core.query.RTFTextFilter"/>
             <param name="path" value="${wsp.home}/index"/>
             <param name="useCompoundFile" value="true"/>
             <param name="minMergeDocs" value="100"/>
             <param name="volatileIdleTime" value="3"/>
             <param name="maxMergeDocs" value="100000"/>
             <param name="mergeFactor" value="10"/>
             <param name="bufferSize" value="10"/>
         </SearchIndex>
     </Workspace>
     <Versioning rootPath="${rep.home}/version">
         <FileSystem  
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
             <param name="path" value="${rep.home}/workspaces/version"/>
         </FileSystem>
         <PersistenceManager  
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
             <param name="driver" value="com.mysql.jdbc.Driver"/>
             <param name="url" value="jdbc:mysql:///test"/>
             <param name="schema" value="mysql"/>
             <param name="user" value="xxx"/>
             <param name="schemaObjectPrefix" value="version_"/>
             <param name="externalBLOBs" value="false"/>
         </PersistenceManager>
     </Versioning>
</Repository>