[
https://issues.apache.org/jira/browse/OFBIZ-243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661261#action_12661261
]
Adrian Crum commented on OFBIZ-243:
-----------------------------------
Jacopo,
This appears to be fixed in the latest SVN trunk (DatabaseUtil.java, line
2515). Could you confirm please?
> 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 is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
