Return-Path: 
 <users-return-7422-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-users-archive@locus.apache.org
Received: (qmail 75862 invoked from network); 14 May 2008 14:03:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 14 May 2008 14:03:10 -0000
Received: (qmail 47034 invoked by uid 500); 14 May 2008 14:03:10 -0000
Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org
Received: (qmail 47017 invoked by uid 500); 14 May 2008 14:03:10 -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 47006 invoked by uid 99); 14 May 2008 14:03:10 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 May 2008 07:03:10 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of stefan.guggisberg@gmail.com
 designates 209.85.146.179 as permitted sender)
Received: from [209.85.146.179] (HELO wa-out-1112.google.com) (209.85.146.179)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 May 2008 14:02:22 +0000
Received: by wa-out-1112.google.com with SMTP id m33so4749181wag.9
        for <users@jackrabbit.apache.org>;
 Wed, 14 May 2008 07:02:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        bh=ZnR1sTe/BHXFMUTWLgzfg3eSGgzNcMRJyFxktPcp4Ps=;
        b=v43xHnwS9/ql+Cg1RqeuRqYbYBHxPnNphkzMcL+LdoyqX3TBB3F1j4p++/Jqwh9jNDgtJ7k4VJIcHvZKR9xQj3mNyHgNdL0ODpbRsBW/0OW2q/DpShcnAixcsex5BH4FGHGUv2WhfEid/KVQdIJxWynLcI6kv65qSkVwuRgj6cg=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=ha+jd628AK4R2sfNPXrMVQxk/xUUYvJvBdawwHYNOVmDENv7PG7DVsJOhUFyw9ppjUOphzAy979voUgLVx7rzORBJcmD261g+E31GHK7rOb1eu4xFKd9r4sLdEj6Dnx96M9MdSYTtwmaKhcu1Ek8FulTn3fFrC9bKdnstl9FMxY=
Received: by 10.114.67.2 with SMTP id p2mr1119558waa.1.1210773756203;
        Wed, 14 May 2008 07:02:36 -0700 (PDT)
Received: by 10.114.191.8 with HTTP; Wed, 14 May 2008 07:02:36 -0700 (PDT)
Message-ID: <90a8d1c00805140702l3f728b68ue9d46f72b486486e@mail.gmail.com>
Date: Wed, 14 May 2008 16:02:36 +0200
From: "Stefan Guggisberg" <stefan.guggisberg@day.com>
Reply-To: stefan.guggisberg@day.com
Sender: stefan.guggisberg@gmail.com
To: users@jackrabbit.apache.org
Subject: Re: Running Repository completely off of a RDBMS
In-Reply-To: <199181.40862.qm@web52707.mail.re2.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <199181.40862.qm@web52707.mail.re2.yahoo.com>
X-Google-Sender-Auth: a9e30d28249fb276
X-Virus-Checked: Checked by ClamAV on apache.org

hi sonu

you have to specify the "configRootPath" attribute of the
<wokspaces/> element. you can find more information here:
http://markmail.org/message/kewjulasgtys3uzo

cheers
stefan


On Wed, May 14, 2008 at 2:28 AM, Sonu Vijay <sonupv@yahoo.com> wrote:
> Hi Everybody,
>
>  I'm a newbie and I came to Jackrabbit via JBoss Rules.
>
>  I need to run my repository completely off of a RDBMS.
>  I can't have anything stored on the local file
>  system.I'm able to make this work partially but still
>  some stuff is being stored in local file system. If I
>  delete the local repository folder, my application
>  stops working.
>
>  I'm trying to understand the Jackrabbit configuration
>  properties and would appreciate some help. I'm
>  including my repository.xml below. I have following
>  questions.
>
>  1. What configurations in my repository.xml are still
>  keeping stuff on my local file system.
>
>  2. When I try to use a DataStore with a
>  BundleDbPersistenceManager instead of just using
>  SimpleDbPersistenceManager, I get an error which says
>  that the repository has been locked by another
>  application. I'm running against MS SQL Server. Has
>  anybody faced this issue ? This issue doesn't happen
>  with SimpleDBPersistanceManager.
>
>
>  Thanks in advance for your help.
>
>  Sonu
>
>  ----------Repository.xml---------------
>  <Repository>
>     <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="MyRepo"/>
>     <Workspace name="MyRepo">
>
>         <FileSystem
>  class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
>                        <param name="driver"
>  value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
>                                <param name="url"
>  value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=MyDB;SelectMethod=Cursor;"/>
>                                <param name="schema" value="mssql"/>
>                                <param name="user" value="duser"/>
>                                <param name="password"
>  value="dsadmin"/>
>                        <param name="schemaObjectPrefix"
>  value="${wsp.name}_FS_"/>
>            </FileSystem>
>
>
>          <PersistenceManager
>  class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
>                <param name="driver"
>  value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
>                <param name="url"
>  value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=MyDB;SelectMethod=Cursor;"/>
>                <param name="schema" value="mssql"/>
>                <param name="user" value="dadmin"/>
>                <param name="password" value="dadmin"/>
>                <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.db.DbFileSystem">
>                        <param name="driver"
>  value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
>                                <param name="url"
>  value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=MyDB;SelectMethod=Cursor;"/>
>                                <param name="schema" value="mssql"/>
>                                <param name="user" value="dadmin"/>
>                                <param name="password"
>  value="dadmin"/>
>                        <param name="schemaObjectPrefix"
>  value="version_FS_"/>
>            </FileSystem>
>
>         <PersistenceManager
>  class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
>                        <param name="driver"
>  value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
>                        <param name="url"
>  value="jdbc:microsoft:sqlserver://localhost:1433;;DatabaseName=MyDB;SelectMethod=Cursor;"/>
>                        <param name="schema" value="mssql"/>
>                        <param name="user" value="dadmin"/>
>                        <param name="password" value="dadmin"/>
>                        <param name="schemaObjectPrefix"
>  value="version_"/>
>                        <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>
>
>
>
>
>