Jetspeed-2 on the mysql

[Alexander Buloichik <Al...@epam.com>]

Hi, All !

I am trying to setup jetspeed-2 for use mysql database. 
I changed build.properties for use mysql instead hsql.
But on the "maven j2:quickStart" it said :


j2:_db.execute:
    [sql] Executing file: D:\sources\jetspeed-2\target\portal-sql\mysql\schema\p
hase2-schema.sql
    [sql] [ERROR] Failed to execute: CREATE TABLE FOLDER ( FOLDER_ID MEDIUMINT N
OT NULL, PARENT_ID MEDIUMINT, PATH VARCHAR(160) NOT NULL, NAME VARCHAR(80) NOT N
ULL, TITLE VARCHAR(100), SHORT_TITLE VARCHAR(40), IS_HIDDEN INTEGER NOT NULL, DE
FAULT_PAGE_NAME VARCHAR(80), SUBSITE VARCHAR(40) NOT NULL, USER_PRINCIPAL VARCHA
R(40) NOT NULL, ROLE_PRINCIPAL VARCHAR(40) NOT NULL, GROUP_PRINCIPAL VARCHAR(40)
 NOT NULL, MEDIATYPE VARCHAR(15) NOT NULL, LOCALE VARCHAR(20) NOT NULL, EXT_ATTR
_NAME VARCHAR(15) NOT NULL, EXT_ATTR_VALUE VARCHAR(40) NOT NULL, PRIMARY KEY(FOL
DER_ID), FOREIGN KEY (PARENT_ID) REFERENCES FOLDER (FOLDER_ID) ON DELETE CASCADE
 , UNIQUE (PATH, SUBSITE, USER_PRINCIPAL, ROLE_PRINCIPAL, GROUP_PRINCIPAL, MEDIA
TYPE, LOCALE, EXT_ATTR_NAME, EXT_ATTR_VALUE), INDEX IX_FOLDER_1 (PARENT_ID))

BUILD FAILED
File...... C:\Documents and Settings\Alexander_Buloichik\.maven\cache\maven-jets
peed2-plugin-2.0-M4-SNAPSHOT\plugin.jelly
Element... sql
Line...... 842
Column.... 44
java.sql.SQLException: Specified key was too long; max key length is 1024 bytes
Total time: 58 seconds


WBR, Alex.