jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Mayr <mam...@cosy.sbg.ac.at>
Subject MSSQL usage - repository.xml - basic question
Date Tue, 22 Jul 2008 12:22:19 GMT
Hello,

I'm new to jackrabbit and want it to use a MS SQL database server for 
storage.
But my repository.xml seems to be wrong.
My webserver is Tomcat 5.5 and the log shows me this:

22.07.2008 13:44:13 *WARN * ConfigurationErrorHandler: Error parsing the 
configuration at line 13 using system id null: 
org.xml.sax.SAXParseException: The content of element type "Security" 
must match "(SecurityManager,AccessManager,LoginModule?)". 
(ConfigurationErrorHandler.java, line 43)
22.07.2008 13:44:13 *ERROR* RepositoryStartupServlet: 
RepositoryStartupServlet initializing failed: 
javax.servlet.ServletException: Error while creating repository 
(RepositoryStartupServlet.java, line 245)
javax.servlet.ServletException: Error while creating repository
    at 
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.initRepository(RepositoryStartupServlet.java:409)
    ...

I hope that someone can help me and tell me what i made wrong.
The user i entered has full rights on this named instance to create/drop 
tables and so on.

thanks!

my repository.xml:
---
<?xml version="1.0"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD 
Jackrabbit 1.5//EN"
                            
"http://jackrabbit.apache.org/dtd/repository-1.5.dtd">
<Repository>
  <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
    <param name="path" value="${rep.home}/repository" />
  </FileSystem>
  <Security appName="Jackrabbit">
    <AccessManager 
class="org.apache.jackrabbit.core.security.SimpleAccessManager" />
    <LoginModule 
class="org.apache.jackrabbit.core.security.SimpleLoginModule">
      <param name="anonymousId" value="anonymous" />
    </LoginModule>
  </Security>
  <Workspaces rootPath="${rep.home}/workspaces" 
defaultWorkspace="default" />
  <Workspace name="${wsp.name}">
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="${wsp.home}" />
    </FileSystem>

        <!-- MSSQL Server -->

    <PersistenceManager 
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
      <param name="driver" 
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
      <param name="url" 
value="jdbc:sqlserver://--ip--;instanceName=--instance--;SelectMethod=Cursor" 
/>
      <param name="user" value="--user--" />
      <param name="password" value="--pass--" />
      <param name="schema" value="mssql" />
      <param name="schemaObjectPrefix" value="JACKRABBIT_${wsp.name}_" />
      <param name="externalBLOBs" value="false" />
    </PersistenceManager>
  </Workspace>
  <Versioning rootPath="${rep.home}/version">
    <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
      <param name="path" value="${rep.home}/version" />
    </FileSystem>

        <!-- MSSQL Server -->
      
    <PersistenceManager 
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
      <param name="driver" 
value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
      <param name="url" 
value="jdbc:sqlserver://--ip--;instanceName=--instance--;SelectMethod=Cursor" 
/>
      <param name="user" value="--user--" />
      <param name="password" value="--pass--" />
      <param name="schema" value="mssql" />
      <param name="schemaObjectPrefix" value="JACKRABBIT_VERSION_" />
      <param name="externalBLOBs" value="false" />
    </PersistenceManager>
  </Versioning>
</Repository>

Mime
View raw message