Hibernate field naming issue with Spring Boot (naming strategy)

by

SINCE SPRING-BOOT 1.4

Starting from 1.4, because of the switch to Hibernate 5, the naming strategy has been updated to SpringPhysicalNamingStrategy which should be very close to 1.3 defaults.

See also:

PREVIOUS VERSION

Spring Boot provides the ImprovedNamingStrategy as default naming strategy, which makes Hibernate search for a team_id column (inferred from the int teamId field). As this column doesn’t exist in your table, that’s the cause of the error. From the Hibernate docs:

An improved naming strategy that prefers embedded underscores to mixed case names

You’ve got two options:

  1. Provide the column name explicitly as @Column(name="teamId"). There used to be a bug with this in early Boot versions, not anymore.

  2. Change the naming strategy in the Spring Boot properties and tell it to use the EJB3NamingStrategy, which doesn’t convert camelCase to snake_case, but keeps it as it is.

More Related Contents:

  1. How to do bulk (multi row) inserts with JpaRepository?
  2. How to use Spring managed Hibernate interceptors in Spring Boot?
  3. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  4. Spring Data JPA – Pass column name and value as parameters
  5. JPA Uppercase table names
  6. Configure Jackson to omit lazy-loading attributes in Spring Boot
  7. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  8. Spring Boot + JPA2 + Hibernate – enable second level cache
  9. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  10. Hibernate Criteria Join with 3 Tables
  11. How to use @Where in Hibernate
  12. Does the JPA specification allow references to non-primary key columns?
  13. Hibernate: comparing current & previous record
  14. Struggling to understand EntityManager proper use
  15. java.lang.ClassNotFoundException: org.hibernate.HibernateException
  16. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  17. How to use the Java 8 LocalDateTime with JPA and Hibernate
  18. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  19. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  20. Hibernate Transactions and Concurrency Using attachDirty (saveOrUpdate)
  21. JPA/Hibernate remove entity sometimes not working
  22. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  23. Hibernate ID Generator
  24. Hibernate, alter identifier/primary key
  25. Hibernate: More than one row with the given identifier was found error
  26. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  27. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  28. Hibernate 3.6 – session.get() vs session.load()
  29. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  30. CDI injection in EntityListeners

Leave a Comment