Return-Path: 
 <dev-return-11311-apmail-jackrabbit-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org>
Delivered-To: apmail-jackrabbit-dev-archive@www.apache.org
Received: (qmail 31435 invoked from network); 28 Mar 2007 13:28:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Mar 2007 13:28:29 -0000
Received: (qmail 53175 invoked by uid 500); 28 Mar 2007 13:28:35 -0000
Delivered-To: apmail-jackrabbit-dev-archive@jackrabbit.apache.org
Received: (qmail 53149 invoked by uid 500); 28 Mar 2007 13:28:35 -0000
Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:dev@jackrabbit.apache.org>
List-Id: <dev.jackrabbit.apache.org>
Reply-To: dev@jackrabbit.apache.org
Delivered-To: mailing list dev@jackrabbit.apache.org
Received: (qmail 53131 invoked by uid 99); 28 Mar 2007 13:28:35 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Mar 2007 06:28:35 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [193.173.25.11] (HELO boba.gx.nl) (193.173.25.11)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Mar 2007 06:28:26 -0700
Received: from darth-vader.nijmegen.gx.nl (infiltrator.gx.nl [193.173.25.10])
	by boba.gx.nl (8.13.1/8.13.1) with ESMTP id l2SDS4t9009038
	for <dev@jackrabbit.apache.org>; Wed, 28 Mar 2007 15:28:04 +0200
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Problem with using the DatabaseFileSystem with My-SQL
Date: Wed, 28 Mar 2007 15:28:05 +0200
Message-ID: 
 <34B0CDC6176518459F3A96E8C09196B805963A2F@darth-vader.nijmegen.gx.nl>
In-Reply-To: <90a8d1c00703280552s7ddc46a2n35fc786fd5162079@mail.gmail.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Problem with using the DatabaseFileSystem with My-SQL
Thread-Index: AcdxOAPNZYd5y3UQRAq+M7RxFN5NhgABLh5w
References: 
 <34B0CDC6176518459F3A96E8C09196B805963921@darth-vader.nijmegen.gx.nl>
 <90a8d1c00703280552s7ddc46a2n35fc786fd5162079@mail.gmail.com>
From: "Martijn Hendriks" <martijnh@gx.nl>
To: <dev@jackrabbit.apache.org>
X-Virus-Scanned: by amavisd-new
X-Virus-Checked: Checked by ClamAV on apache.org

Hi Stefan,

Thanks for the pointer!

Martijn Hendriks
<GX> creative online development B.V.
=20
t: 024 - 3888 261
f: 024 - 3888 621
e: martijnh@gx.nl
=20
Wijchenseweg 111
6538 SW Nijmegen
http://www.gx.nl/ =20

> -----Original Message-----
> From: Stefan Guggisberg [mailto:stefan.guggisberg@gmail.com]=20
> Sent: Wednesday, March 28, 2007 2:53 PM
> To: dev@jackrabbit.apache.org
> Subject: Re: Problem with using the DatabaseFileSystem with My-SQL
>=20
> hi martjin,
>=20
> On 3/28/07, Martijn Hendriks <martijnh@gx.nl> wrote:
> > Hi,
> >
> > I cannot get the DatabaseFileSystem to work with my My-SQL=20
> database. I=20
> > 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=20
> 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=20
> com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
> >         at
> >=20
> org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.checkSchema(Databa
> > se
> > FileSystem.java:1167)
> >         at
> >=20
> org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileS
> > ys
> > tem.java:181)
> >         at
> >=20
> org.apache.jackrabbit.core.config.FileSystemConfig.createFileSystem(Fi
> > le
> > SystemConfig.java:47)
> >         at
> >=20
> org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(Reposit
> > or
> > yImpl.java:368)
> >         at
> >=20
> org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:2
> > 82
> > )
> >         at
> >=20
> org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:5
> > 88
> > )
> >
> > which is thrown on line 1167 of the DatabaseFileSystem=20
> class with the=20
> > following value for the sql variable (which is executed in=20
> a Statement=20
> > on that line):
> >
> > create unique index WM9_VERSIONING_FS_FSENTRY_IDX on=20
> > WM9_VERSIONING_FS_FSENTRY (FSENTRY_PATH(245), FSENTRY_NAME)
>=20
> this issue has been reported a while ago on the dev-list. you=20
> can find the discussion (incl. answer) here:
> http://www.mail-archive.com/dev@jackrabbit.apache.org/msg00969.html
>=20
> cheers
> stefan
>=20
>=20
> >
> > Help is greatly appreciated!
> >
> > Regards,
> >
> > Martijn Hendriks
> > <GX> creative online development B.V.
> >
> > t: 024 - 3888 261
> > f: 024 - 3888 621
> > e: martijnh@gx.nl
> >
> > Wijchenseweg 111
> > 6538 SW Nijmegen
> > http://www.gx.nl/
> >
>=20