SQL Exception when dropping FK's on MySQL
-----------------------------------------
Key: OFBIZ-243
URL:
http://issues.apache.org/jira/browse/OFBIZ-243 Project: OFBiz (The Open for Business Project)
Issue Type: Bug
Components: framework
Reporter: Jacopo Cappellato
Priority: Minor
Migrated from an issue in the old server from Matt Penner:
On r4762 (probably since the beginning of this class) removing Foreign Keys using the WebTools app causes SQL Exceptions using MySQL 4.1.11 on Windows. This is because the SQL call is using DROP CONSTRAINT whereas MySQL requires DROP FOREIGN KEY.
I noticed that the DatabaseUtil class takes into account fkStyle when creating a Foreign Key but it doesn't check this when deleting one.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
