Hi,
> I tried generating a new workspace programmatically using the
> following line of code :
>
> ((JackrabbitWorkspace)session.getWorkspace()).createWorkspace("my_new_
> workspace");
>
> It creates the requested workspace folder and appropriate
> workspace.xml within it. I then try obtaining a session on the new
> workspace like the following:
>
> session = repository.login(new SimpleCredentials(username, password
> .toCharArray()),
> "my_new_workspace");
>
> It throws javax.jcr.NoSuchWorkspaceException. And the underlying error
> is:
>
> ERROR [org.apache.jackrabbit.core.fs.db.DatabaseFileSyst
> em] - failed to initialize file system
> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error
> in your S
> QL syntax; check the manual that corresponds to your MySQL server
> version for th
> e right syntax to use near 'not null, FSENTRY_NAME varchar not null,
> FSENTRY_DAT
> A varbinary null, FSENTRY_LA' at line 1
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
> at
> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
> at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
> at
> com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
> at
> com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
> at
> org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(Datab
> aseFileSystem.java:1180)
> at
> org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFile
> System.java:190)
> at
> org.apache.jackrabbit.core.config.RepositoryConfigurationParser$2.get
> FileSystem(RepositoryConfigurationParser.java:762)
> at
> org.apache.jackrabbit.core.config.WorkspaceConfig.getFileSystem(Works
> paceConfig.java:147)
> at
> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(
> RepositoryImpl.java:1849)
> at
> org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(Re
> positoryImpl.java:1834)
> at
> org.apache.jackrabbit.core.RepositoryImpl.getWorkspaceInfo(Repository
> Impl.java:729)
> at
> org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1
> 341)
> at
> org.apache.jackrabbit.core.jndi.BindableRepository.login(BindableRepo
> sitory.java:161)
> at
> com.idearc.contentmanagement.jackrabbit.service.ContentService.<init>
> (ContentService.java:102)
> at
> com.idearc.contentmanagement.jackrabbit.web.ContentPage.<init>(Conten
> tPage.java:148)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
> orAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
> onstructorAccessorImpl.java:27)
> at
> java.lang.reflect.Constructor.newInstance(Constructor.java:494)
> at java.lang.Class.newInstance0(Class.java:350)
> at java.lang.Class.newInstance(Class.java:303)
> at
> org.apache.wicket.session.DefaultPageFactory.newPage(DefaultPageFacto
> ry.java:58)
> at
> org.apache.wicket.request.target.component.BookmarkablePageRequestTar
> get.newPage(BookmarkablePageRequestTarget.java:256)
> at
> org.apache.wicket.request.target.component.BookmarkablePageRequestTar
> get.getPage(BookmarkablePageRequestTarget.java:277)
> at
> org.apache.wicket.request.target.component.BookmarkablePageRequestTar
> get.processEvents(BookmarkablePageRequestTarget.java:205)
> at
> org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents
> (AbstractRequestCycleProcessor.java:90)
> at
> org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.j
> ava:1031)
> at org.apache.wicket.RequestCycle.step(RequestCycle.java:1107)
> at
> org.apache.wicket.RequestCycle.steps(RequestCycle.java:1176)
> at
> org.apache.wicket.RequestCycle.request(RequestCycle.java:499)
> at
> org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:
> 257)
> at
> org.apache.wicket.protocol.http.WicketServlet.doGet(WicketServlet.jav
> a:126)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
> at
> javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
> at
> org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:491
> )
> at
> org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:3
> 67)
> at
> org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.jav
> a:185)
> at
> org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:1
> 81)
> at
> org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:6
> 89)
> at
> org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:391)
>
> at
> org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHand
> lerCollection.java:146)
> at
> org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.
> java:114)
> at
> org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:1
> 39)
> at org.mortbay.jetty.Server.handle(Server.java:285)
> at
> org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:45
> 7)
> at
> org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpCo
> nnection.java:751)
> at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:500)
> at
> org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209)
> at
> org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:357)
> at
> org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.ja
> va:329)
> at
> org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool
> .java:475)
>
> Am I missing something here? Please advise.
>
> Thanks!
> _____________________________________________
> From: Khanapurkar, Mona A.
> Sent: Monday, June 29, 2009 3:20 PM
> To: '[email protected]'
> Subject: Configuring new workspace
>
> Hello,
>
> How can I configure an additional workspace in jackrabbit content
> repository? I tried adding a new directory under "workspaces" by the
> name of the new workspace. I copied the old workspace.xml from the
> existing workspace directory and modified it's name, <Workspace
> name="my_new_workspace">. But, when I try accessing the new workspace
> like this,
>
> repository.login(new SimpleCredentials("username", "password"
> .toCharArray()), "my_new_workspace");)
>
> it throws me this exception : javax.jcr.NoSuchWorkspaceException.
>
> Restarting server does not help. I am using Jackrabbit 1.5.6. Any
> advice?
>
> Thanks!
>
>
