| Re: AW: [eclipselink-users] Minor Annoyance |
|
Dali attempts to handle case-sensitivity in a vendor specific way based
on the database information available. It is possible that there are
some holes in this support, specifically in the case of MySQL, due to
their varied treatment of case on different operating systems and
database objects. MySQL folds database and table names to lowercase on Windows by default, but this default can also be changed by the lower_case_table_names variable. On Unix, database and table names would be case sensitive by default since sensitivity is determined by the underlying filesystem. The following page explains MySQL treatment of case in greater detail, which may be of help: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html It might be necessary for Dali to have a general "Ignore case" option for database object resolution that can be set by the user to override our vendor specific settings if we cannot reasonably support all of the possibilities. In any case, I suggest that you enter a bug against Dali for this case (1) and/or continue this discussion on the Dali forums (2) for additional assistance. (1) https://bugs.eclipse.org/bugs/enter_bug.cgi?classification=WebTools (2) http://www.eclipse.org/forums/eclipse.technology.dali Thanks, Neil Mathias Walter wrote: Hi, I had the same problem and found out that Dali is case sensitive for all database objects (e. g. database name, table name and column names). In contrast, MySQL is only case sensitive for database and table names, but not for column names. Is it possible to tell Dali that it should use the correct case sensitivity depending on the underlying database vendor? According to the MySQL docs: "Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive, which differs from standard SQL." -- Kind regards, Mathias-----Ursprüngliche Nachricht----- Von: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users- bounces@xxxxxxxxxxx] Im Auftrag von RogerV Gesendet: Donnerstag, 5. November 2009 16:46 An: eclipselink-users@xxxxxxxxxxx Betreff: Re: [eclipselink-users] Minor Annoyance Hi Shaun Thanks for the response. Your suggestion was wrong about the connection information but is correct in that there was a mismatch between Eclipses' view and Dalis' view of things and the issue is a discrepancy between the entity class names, the @Entity(name="") annotation, the @Table(name="") and the actual name of the database table. and it was all about which ones started with an uppercase letter and which started with a lowercase letter. I'm using mySQL and for some reason insists on creating the tables with a lowercase first letter and I can't rename the tables through the admin functions. Once I'd got everything matching .... although I'm surprised that anything worked at all given the name mismatch Regards Shaun Smith wrote: |