MySQL and ICAT

[Steve Fisher]

The statement that ICAT should work with any JPA supported database is incorrect. The database must support transactions and be able to enforce foreign key constraints. In the case of MySQL on current distributions of Linux this is not the case with the default MyISAM engine. For MySQL you should instead use InnoDB. You can see the default engine with "show engines;" and the actual engine with, for example, "show create table APPLICATION;". To fix an existing system you can use the ALTER TABLE command as explained in:http://dev.mysql.com/doc/refman/5.1/en/storage-engine-setting.html.

Steve