Can you please send the log file or something. It is very difficult to read. Please send these two 1> log file 2> config file 3> sqlserver version
do not copy paste it is a bit difficult to read. I have SQLSERVER I can give this a try. On Thu, Mar 25, 2010 at 6:24 PM, pradeepkudale <[email protected]>wrote: > > 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. > -- Thanks ... Dhrubo My Book - http://www.apress.com/book/view/1430210095 My Blog - http://www.jtraining.com/blogs/blogger/dhrubo/ LinkedIn - http://www.linkedin.com/in/dhrubo
