Thanks, Alex! It works after adding <param name="schema" value="mysql"/>.
Appreciate your quick help! Mona -----Original Message----- From: Alexander Klimetschek [mailto:aklim...@day.com] Sent: Thursday, July 02, 2009 1:06 PM To: users@jackrabbit.apache.org Subject: Re: Configuring new workspace On Thu, Jul 2, 2009 at 6:17 PM, Khanapurkar, Mona A.<mona.a.khanapur...@idearc.com> wrote: > 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. You need to set the schema to MySQL (if this is the database type you are using) - the SQL statements for creating the tables for the filesystem and the persistence manager are different from db to db and Jackrabbit includes schemas for most common dbs. For the persistence manager there are even different implementations, since they try to optimize queries and such for the specific database. Hence, for the DB file system config, add this (see config here [1]): <param name="schema" value="mysql"/> And the persistence manager should be the (bundle) MySqlPersistenceManager [2]. For more info, see the configuration manual [3] and the persistence manager documentation [4]. [1] http://jackrabbit.apache.org/api/1.5/org/apache/jackrabbit/core/fs/db/Db FileSystem.html [2] http://jackrabbit.apache.org/api/1.5/org/apache/jackrabbit/core/persiste nce/bundle/MySqlPersistenceManager.html [3] http://jackrabbit.apache.org/jackrabbit-configuration.html [4] http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ Regards, Alex -- Alexander Klimetschek alexander.klimetsc...@day.com
