MySQL rejects our DROP CONSTRAINT statements, it requires different syntax.
org.apache.openjpa.persistence.kernel.TestEJBState fails with two exceptions ORA-00904 and ORA-02275 against oracleDB.
Looks like ALTER TABLE xxx DROP FOREIGN KEY yyy should work . I'm not sure if there's a more general name we can use though.
I have modified MySQLDictionary to use "ALTER TABLE xxx DROP FOREIGN KEY yyy". Also corrected the statement to drop a primary key to "ALTER TABLE xxx DROP PRIMARY KEY" although it seems to be unused at the moment.
Change applied to trunk and 1.3.x branch.