mysql忽略大小写jpa解决,JPA 2.0& MySQL不尊重区分大小写的表名

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.

解决方案

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