db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-195) Can not update a foreign key on a case sensetive MySql Database
Date Thu, 28 Feb 2008 07:15:54 GMT

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


Mime
View raw message