jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sonu Vijay <son...@yahoo.com>
Subject Running Repository completely off of a RDBMS
Date Wed, 14 May 2008 00:28:49 GMT
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>



      

Mime
View raw message