Hello:
I am trying to use Jetspeed with MySQL. My MySQL database is set to use
InnoDb tables by default (I need that for several projects since they
use TJDO).
When I try to do maven j2:quickStart, I get this error:
j2:_db.execute:
[sql] Executing file:
/usr/local/jetspeed/portal/target/portal-sql/mysql/schema/security-schema.sq
l
[sql] [ERROR] Failed to execute: CREATE TABLE PRINCIPAL_PERMISSION (
PRINCIPAL_ID MEDIUMINT NOT NULL, PERMISSION_ID MEDIUMINT NOT NULL, PRIMARY
KEY(PRINCIPAL_ID,PERMISSION_ID), FOREIGN KEY (PERMISSION_ID) REFERENCES
SECURITY_PERMISSION (PERMISSION_ID) ON DELETE CASCADE , FOREIGN KEY
(PRINCIPAL_ID) REFERENCES SECURITY_PRINCIPAL (PRINCIPAL_ID) ON DELETE
CASCADE )
BUILD FAILED
File...... /root/.maven/cache/maven-jetspeed2-plugin-2.0/plugin.jelly
Element... sql
Line...... 839
Column.... 44
java.sql.SQLException: Can't create table
'./jetspeed/PRINCIPAL_PERMISSION.frm' (errno: 150)
Reading on the web, there is a problem when using foreign key constraints on
MySQL InnoDB tables. Everything is supposed to work fine with MyISAM
tables.
Is there a way to tell Jetspeed to put Type=MyISAM at the end of the
create table definitions?
Thanks,
Neil
--
Neil Aggarwal, JAMM Consulting, (214) 986-3533, www.JAMMConsulting.com
FREE! Valuable info on how your business can reduce operating costs by
17% or more in 6 months or less! http://newsletter.JAMMConsulting.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
