[
https://issues.apache.org/jira/browse/OFBIZ-243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacopo Cappellato closed OFBIZ-243.
-----------------------------------
> SQL Exception when dropping FK's on MySQL
> -----------------------------------------
>
> Key: OFBIZ-243
> URL: https://issues.apache.org/jira/browse/OFBIZ-243
> Project: OFBiz
> 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 was sent by Atlassian JIRA
(v6.2#6252)
