SpringBoot JPA Hibernate DB Table name with a "." (period) in it

Question

OK, I'm trying to connect my SpringBoot application via JPA (Hibernate) to a legacy AS/400 DB database. The table names however have a "." (Period) in them. ex: LE.ONFP is the table name. Hibernate however is converting the period to an underscore which causes an error because there is not table called "le_onfp".

@Entity @Table(name = "\"LE.OFNP\"", schema = "QS36F")

Here is my annotations at the beginning of my Entity class.

I have also tried used `@Table(name="'LE.OFNP'", schema = "QS36F") (single quote round the table name) — Jacob Miles
– Jacob Miles, Commented Sep 13, 2017 at 13:27
backticks before the "." is the only one that would make any sense — user8558216
– user8558216, Commented Sep 13, 2017 at 14:55

Fangming · Accepted Answer · 2020-05-29 20:09:53Z

adding the following line to my application.properties files fixed my issue.

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

and keeping my annotation the same. @Table(name = "\"LE.OFNP\"", schema = "QS36F")

Collectives™ on Stack Overflow

SpringBoot JPA Hibernate DB Table name with a "." (period) in it

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related