JPA 2.0 & MySQL are not respecting case sensitive table names

I have a strange issue my ear project: I have put the correct annotations on my entity class:

@Entity
@Table(name = "PRODUCTS")

But when I deploy my application on glassfish 3.1.2.2, I find that JPA has created the tables with lowercase chars

I am using EclipseLink 2.4.1

Please Help me.

Answers


I got the solution from Brian Vosburgh's comment: In the windows version of MySQL the names of table are set to lower case. On linux, by default, this configuration is disabled, and the tables'names set by JPA are applied to MySQL without modification.

To make it working on windows as like linux, add the line:

lower_case_table_names=0

Thank you for your help, specially Brian Vosburgh


I found a property the makes all the difference. In the EclipseLink wizard (generate entities from tables), third page (Customize Defaults), I checked the "Always generate optional JPA annotations and DDL parameters" option. This option writes the below annotation in the Entity class:

@Table(name="TableName")

The correct table name letter case will be used.


Need Your Help

php array value gets replaced in loop

php arrays loops override

I just tried to loop through the fetched results of a database query and storing them in a new array. So my first attempt was this: