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.
Emiliano
