RE: Configuring new workspace

[Khanapurkar, Mona A.]

Hi Alex,

Thanks for your response. I am using jackrabbit 1.3.1, but even when I switch 
to 1.5.6 I get the same issue. I have attached repository.xml and the generated 
workspace.xml for your reference. For security reasons, I have changed the db 
url, username and password from my original config file.

Please let me know if I've missed anything.



Thanks,
Mona

-----Original Message-----
From: Alexander Klimetschek [mailto:aklim...@day.com] 
Sent: Thursday, July 02, 2009 10:16 AM
To: users@jackrabbit.apache.org
Subject: Re: Configuring new workspace

On Thu, Jul 2, 2009 at 4:24 PM, Khanapurkar, Mona
A.<mona.a.khanapur...@idearc.com> wrote:
>> 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

This means the database file system for the new workspace couldn't be
created, due to this SQL syntax error. This could be a
misconfiguration of the db file system, ie. the wrong implementation
or the wrong schema. What does your config look like? Are you using
the latest version of Jackrabbit (1.5.x)?

Regards,
Alex

-- 
Alexander Klimetschek
alexander.klimetsc...@day.com

<?xml version="1.0"?>
<!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 1.2//EN"
                            "http://jackrabbit.apache.org/dtd/repository-1.2.dtd";>
<Repository>
    
    <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
        <param name="driver" value="com.mysql.jdbc.Driver"/>
        <param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>
        <param name="schemaObjectPrefix" value="jcr_fs_"/>
    </FileSystem>
    
    <Security appName="Jackrabbit">
        <AccessManager class="org.apache.jackrabbit.core.security.SimpleAccessManager">
        </AccessManager>

        <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.db.DbFileSystem">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_fs_${wsp.name}_"/>
		</FileSystem>
        
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
            <param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_pm_${wsp.name}_"/>  
			<param name="externalBLOBs" value="false"/>
        </PersistenceManager>
    </Workspace>
    
    <Versioning rootPath="${rep.home}/version">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_fs_ver_"/>
		</FileSystem>
        
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
            <param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_pm_ver_"/> 
			<param name="externalBLOBs" value="false"/>
        </PersistenceManager>
    </Versioning>
    
</Repository>

<?xml version="1.0" encoding="UTF-8"?>
<Workspace name="my_new_workspace">
        <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
			<param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_fs_${wsp.name}_"/>
		</FileSystem>
        
        <PersistenceManager class="org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager">
            <param name="driver" value="com.mysql.jdbc.Driver"/>
			<param name="url" value="jdbc:mysql://test.com:3309/opencms_admin?user=abc&amp;password=abc"/>    
			<param name="schemaObjectPrefix" value="jcr_pm_${wsp.name}_"/>  
			<param name="externalBLOBs" value="false"/>
        </PersistenceManager>
    </Workspace>