How to change the default format of JPA generated column names

Question

Currently I'm mapping new JPA entities to an old database. The column names in the database have column names separated with underscore like 'my_column_name'.

The problem is that JPA defaults to using with camel case.

// Will be 'myColumnName' in queries and generated databases
private String myColumnName;

I know it's possible to add @Column(name="..") or @JoinColumn(name="...") on the properties - but that means i have to add it to every single property in all entities.

@Column(name = "my_column_name")
private String myColumnName;

Is it possible to change the default behavior of JPA to use 'my_column_name' instead of 'myColumnName'?

score 3 · Answer 1 · edited Jul 10 '17 at 05:29

Add the following lines to your application.properties :

spring.jpa.hibernate.naming.implicit-strategy=
   org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyJpaImpl
spring.jpa.hibernate.naming.physical-strategy=
   org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

According to the following link, I tested and it worked:

Spring Boot + JPA : Column name annotation ignored

score 2 · Answer 2 · answered Oct 29 '14 at 14:57

2

Unfortunately JPA doesn't provide any global naming strategy. So you should use @Column annotation on each property. But you can use Hibernate to achive this goal. See Hibernate documentation.

answered Oct 29 '14 at 14:57

njjnex

1,490
13
23

score 1 · Answer 3 · answered Oct 29 '14 at 00:49

1

You need to investigate Implementing a NamingStrategy

answered Oct 29 '14 at 00:49

Steve C

18,876
5
34
37

which would only work in Hibernate, and he also tagged it as OpenJPA – Neil Stockton Oct 29 '14 at 19:14

How to change the default format of JPA generated column names

3 Answers3