jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From emiliano albiani <EmilianoAlbi...@tagetik.com>
Subject Warning! The maximum key length is 900 bytes
Date Fri, 13 May 2011 07:40:50 GMT
Hi all,

We are using the DBMS as filesystem and we had a look at the tables created by Jackrabbit
when working with Microsoft SQL Server.  

The Jackrabbit's SQL script:
create unique index ${schemaObjectPrefix}FSENTRY_IDX on ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH,
FSENTRY_NAME) ${tableSpace},
creates an index on FSENTRY_PATH which is a column of the table create by the script:
create table ${schemaObjectPrefix}FSENTRY (FSENTRY_PATH varchar(2048) not null, FSENTRY_NAME
varchar(255) not null, FSENTRY_DATA image null, FSENTRY_LASTMOD bigint not null, FSENTRY_LENGTH
bigint not null) ${tableSpace}.

We noticed that the FSENTRY_PATH column's length exceed the maximum size of index keys (http://msdn.microsoft.com/en-us/library/aa224343%28v=sql.80%29.aspx).

Could we face any problem?
Is anyone aware of this warning?

Thanks in advance.

View raw message