Hello,

I am trying to configure jackrabbit repository in sql server. but i am
getting below error

org.apache.jackrabbit.j2ee.ServletExceptionWithCause: Error while creating
repository
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.initRepository(RepositoryStartupServlet.java:319)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.startup(RepositoryStartupServlet.java:148)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.init(RepositoryStartupServlet.java:121)
        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
        at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
        at 
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992)
        at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
        at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4371)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at 
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at 
org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at 
org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: javax.jcr.RepositoryException: File system initialization
failure.
        at
org.apache.jackrabbit.core.config.RepositoryConfigurationParser$4.getFileSystem(RepositoryConfigurationParser.java:850)
        at
org.apache.jackrabbit.core.config.RepositoryConfig.getFileSystem(RepositoryConfig.java:778)
        at
org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:291)
        at
org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:646)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.createRepository(RepositoryStartupServlet.java:349)
        at
org.apache.jackrabbit.j2ee.RepositoryStartupServlet.initRepository(RepositoryStartupServlet.java:317)
        ... 20 more
Caused by: org.apache.jackrabbit.core.fs.FileSystemException: failed to
initialize file system
        at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:223)
        at
org.apache.jackrabbit.core.config.RepositoryConfigurationParser$4.getFileSystem(RepositoryConfigurationParser.java:843)
        ... 25 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax
near '$'.
        at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
        at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
        at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642)
        at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(DatabaseFileSystem.java:1011)
        at
org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:207)


My repository.xml is as below


<?xml version="1.0" encoding="ISO-8859-1"?>

<!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.db.DbFileSystem">
                
                
                
                
                
                
        </FileSystem>
        
    <Security appName="Jackrabbit">
    
        <SecurityManager
class="org.apache.jackrabbit.core.security.simple.SimpleSecurityManager" 
        workspaceName="default" />
                
        <AccessManager
class="org.apache.jackrabbit.core.security.SimpleAccessManager" />
        
        <LoginModule
class="org.apache.jackrabbit.core.security.SimpleLoginModule">          
                     
        </LoginModule>
    </Security>
        
        <Workspaces rootPath="${rep.home}/workspaces" 
defaultWorkspace="default" />
        <Workspace name="${wsp.name}">
        
                <FileSystem 
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
                        
                        
                        
                        
                        
                        
                </FileSystem>
                <PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
                        
                        
                        
                        
                        
                        
                        
                </PersistenceManager>           
        </Workspace>
        
        <Versioning rootPath="${rep.home}/version">
        
                <FileSystem 
class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
                        
                        
                        
                        
                        
                        
                </FileSystem>
                <PersistenceManager
                
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
                        
                        
                        
                        
                        
                        
                        
                </PersistenceManager>
        </Versioning>
</Repository>



thanks in advance
pradeep

-- 
View this message in context: 
http://n4.nabble.com/database-configuration-error-tp1690571p1690571.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Reply via email to