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>

Reply via email to