CODEWITHSUNDEEP
javamysqljpaglassfisheclipselink
Jason Bourne
Jason Bourne

Reputation: 786

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.

Upvotes: 0

Views: 5587

Answers (2)

Fabio Toniolo
Fabio Toniolo

Reputation: 1

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.

Upvotes: 0

Jason Bourne
Jason Bourne

Reputation: 786

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

Upvotes: 1

Related Questions