Neil, We use MySQL InnoDB all the time without incident. I believe that 4.1.* and 5.0.* versions have been tested. What version are you using?
If you continue to have problems, i suppose you could set this in my.cnf under [mysqld]: default-storage-engine=MyISAM HTH, Randy On Sun, 2006-01-15 at 02:17 -0600, Neil Aggarwal wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
