You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Neil Aggarwal <ne...@JAMMConsulting.com> on 2006/01/15 09:17:29 UTC
MySQL problem with InnoDB tables
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: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
RE: MySQL problem with InnoDB tables
Posted by Neil Aggarwal <ne...@JAMMConsulting.com>.
Randy:
I am using an old MySQL server running version 4.0 so I think it
is just too old.
I will upgrate it to a newer version and try again.
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
-----Original Message-----
From: Randy Watler [mailto:watler@wispertel.net]
Sent: Sunday, January 15, 2006 12:04 PM
To: Jetspeed Users List
Subject: Re: MySQL problem with InnoDB tables
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: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: MySQL problem with InnoDB tables
Posted by Randy Watler <wa...@wispertel.net>.
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: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org