Validate hibernate entity-database mappings in spring boot

Question

I have an entity:

@Entity
@Table(name = "tbl_user")
public class UserEntity {
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  @Column(name = "user_id")
  private Long userId;

The database definition file which I roll by hand to a real database or with spring.datasource.initialize=true to in-memory h2 test (take a look at column name):

CREATE TABLE tbl_user (
  uer_id BIGINT PRIMARY KEY AUTO_INCREMENT,

And application.properties definition related to db:

spring.datasource.initialize=false
spring.jpa.hibernate.ddl-auto=validate
hibernate.hbm2ddl.auto=validate
spring.jpa.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
spring.datasource.schema=classpath:sql/app-db-definition.sql

At startup of spring context (in tests too), I want to validate that entity columns mappings match db columns. How do I have to configure it?

I suggest a read of the documentation... docs.spring.io/spring-boot/docs/current/reference/htmlsingle/…... In short prefix with spring.jpa.properties. — M. Deinum
– M. Deinum, Commented Oct 25, 2015 at 18:37

mishka · Accepted Answer · 2015-10-29 09:18:34Z

1

I had an overriding version of hibernate in dependencies and misconfiguration to use it, so it skips properties :( M.Denium in the comment also right, that I forgot about spring.jpa.properties.* prefixes.

answered Oct 29, 2015 at 9:18

mishka

2,1072 gold badges20 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Validate hibernate entity-database mappings in spring boot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related