LOMBART Christophe wrote:
Hi All,
I'm wondering if someone is using Jetspeed 2 with MySql 4.1 ?
I cannot build with this Mysql version. I'm not the MySql expert but I expect the issues comes from the differencies between MySql 3.x & 4.1. Mainly InnoDb support is not by default in 3.x.
I work with 4.1 here.
Seems to build fine, but I suspect you may have InnoDB as your default table type?
I think InnoDB should be the default for Jetspeed
Im trying to change my default table type so I can reproduce it but i can't get the setting to work :(
OK I switched over to InnoDB as my default DB type Now I get
db.execute:
[sql] Executing file: C:\bluesunrise\apache\jakarta-jetspeed-2\target\src\sq
l\mysql\phase2-schema.sql
[sql] [ERROR] Failed to execute: CREATE TABLE RULE_CRITERION ( CRITERION_ID
VARCHAR (80) NOT NULL, RULE_ID VARCHAR (80) NOT NULL, FALLBACK_ORDER INTEGER NOT
NULL, REQUEST_TYPE VARCHAR (40) NOT NULL, NAME VARCHAR (80) NOT NULL, VALUE VAR
CHAR (128), FALLBACK_TYPE INTEGER default 1, PRIMARY KEY(CRITERION_ID), FOREIGN
KEY (RULE_ID) REFERENCES PROFILING_RULE (RULE_ID) , INDEX IX_RULE_CRITERION_1 (R
ULE_ID, FALLBACK_ORDER) )
I imagine it has something to do with the order we create the tables ....
Looking into it now
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
