[ https://issues.apache.org/jira/browse/DDLUTILS-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Thomas Dudziak updated DDLUTILS-195: ------------------------------------ Fix Version/s: 1.1 > 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 > Fix For: 1.1 > > > 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.