[
https://issues.apache.org/jira/browse/DDLUTILS-195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12573168#action_12573168
]
Thomas Dudziak commented on DDLUTILS-195:
-----------------------------------------
Please post the SQL to create the relevant tables and foreign key, as well as
Ant target or Java code that you used.
> Can not update a foreign key on a case sensetive MySql Database
> ---------------------------------------------------------------
>
> Key: DDLUTILS-195
> URL: https://issues.apache.org/jira/browse/DDLUTILS-195
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - MySql
> Affects Versions: 1.1
> Environment: Trying to update a existing case sensitive mysql
> database on Linux
> Reporter: meindert hoving
> Assignee: Thomas Dudziak
>
> For testing purposes I made my MySql database case sensitive (to avoid
> problems when deploying to linux)
> The foreign key restrained throws the following exception;
> throw new ModelException("The foreignkey "+fkDesc+" in table
> "+curTable.getName()+" references the undefined table
> "+fk.getForeignTableName());
> fk.getForeignTableName is all lower case, while the table name is camel case.
> hacking the correct camel case into the piece of code that throws the
> exception 'fixes' the issue. Therefore the issue is that
> fk.getForeignTableName()) contains the wrong table name.
> This wrong table name comes from JdbcModelReader
> fk.setForeignTableName((String)values.get("PKTABLE_NAME"));
> The PKTABLE_NAME value comes from readColumn what returns the table name in
> lowercase
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
