Hi Stefan, Thanks for the pointer!
Martijn Hendriks <GX> creative online development B.V. t: 024 - 3888 261 f: 024 - 3888 621 e: [EMAIL PROTECTED] Wijchenseweg 111 6538 SW Nijmegen http://www.gx.nl/ > -----Original Message----- > From: Stefan Guggisberg [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 28, 2007 2:53 PM > To: dev@jackrabbit.apache.org > Subject: Re: Problem with using the DatabaseFileSystem with My-SQL > > hi martjin, > > On 3/28/07, Martijn Hendriks <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I cannot get the DatabaseFileSystem to work with my My-SQL > database. I > > get the following exception > > > > SEVERE: failed to initialize file system > > java.sql.SQLException: Specified key was too long; max key length is > > 1024 bytes > > at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921) > > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570) > > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2972) > > at com.mysql.jdbc.Connection.execSQL(Connection.java:2902) > > at > com.mysql.jdbc.Statement.executeUpdate(Statement.java:929) > > at > > > org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(Databa > > se > > FileSystem.java:1167) > > at > > > org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileS > > ys > > tem.java:181) > > at > > > org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(Fi > > le > > SystemConfig.java:47) > > at > > > org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(Reposit > > or > > yImpl.java:368) > > at > > > org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:2 > > 82 > > ) > > at > > > org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:5 > > 88 > > ) > > > > which is thrown on line 1167 of the DatabaseFileSystem > class with the > > following value for the sql variable (which is executed in > a Statement > > on that line): > > > > create unique index WM9_VERSIONING_FS_FSENTRY_IDX on > > WM9_VERSIONING_FS_FSENTRY (FSENTRY_PATH(245), FSENTRY_NAME) > > this issue has been reported a while ago on the dev-list. you > can find the discussion (incl. answer) here: > http://www.mail-archive.com/dev@jackrabbit.apache.org/msg00969.html > > cheers > stefan > > > > > > Help is greatly appreciated! > > > > Regards, > > > > Martijn Hendriks > > <GX> creative online development B.V. > > > > t: 024 - 3888 261 > > f: 024 - 3888 621 > > e: [EMAIL PROTECTED] > > > > Wijchenseweg 111 > > 6538 SW Nijmegen > > http://www.gx.nl/ > > >
