[ http://jira.undersunconsulting.com/browse/OFBIZ-215?page=all ]
Jacopo Cappellato closed OFBIZ-215:
-----------------------------------
Resolution: Duplicate
https://issues.apache.org/jira/browse/OFBIZ-243
> SQL Exception when dropping FK's on MySQL
> -----------------------------------------
>
> Key: OFBIZ-215
> URL: http://jira.undersunconsulting.com/browse/OFBIZ-215
> Project: [OFBiz] Open For Business
> Type: Bug
> Components: entity
> Versions: SVN
> Environment: WinXP, MySQL 4.1.11, InnoDB
> Reporter: Matt Penner
> Assignee: Jira Administrator
> Priority: Minor
>
> Original Estimate: 1 day
> Remaining: 1 day
>
> 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://jira.undersunconsulting.com/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
