jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martijn Hendriks" <marti...@gx.nl>
Subject RE: Problem with using the DatabaseFileSystem with My-SQL
Date Wed, 28 Mar 2007 13:28:05 GMT
Hi Stefan,

Thanks for the pointer!

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/  

> -----Original Message-----
> From: Stefan Guggisberg [mailto:stefan.guggisberg@gmail.com] 
> 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 <martijnh@gx.nl> 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: martijnh@gx.nl
> >
> > Wijchenseweg 111
> > 6538 SW Nijmegen
> > http://www.gx.nl/
> >
> 

Mime
View raw message