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