[jira] Commented: (OFBIZ-243) SQL Exception when dropping FK's on MySQL

["Adrian Crum (JIRA)" <ji...@apache.org>]

    [ 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.