Hibernate-sequence doesn t exist

Question

I tried to upgrade hibernate from 4 to 5 in my project with spring 4 2 version  After this upgrade  I found the following error in my stack trace when I called a method for updating   10 53 32 185 ERROR TableStructure 149 - could not read a hi value com mysql jdbc exceptions jdbc4 MySQLSyntaxErrorException  Table  test hibernate sequence  doesn t exist    I changed the auto incremented Id with annotation    GeneratedValue strategy GenerationType AUTO     still the error remains

User · Answer

Working with Spring Boot  Solution  Put the string below in  application properties  spring jpa properties hibernate id new generator mappings false   Explanation  On Hibernate 4 X this attribute defaults to true

User · Answer

You can also put     GeneratedValue strategy   GenerationType IDENTITY    And let the DateBase manage the incrementation of the primary key   AUTO INCREMENT PRIMARY KEY

User · Answer

Run this query   create sequence hibernate sequence start with 1 increment by 1

User · Answer

You need to set for Hibernate5 x  lt property name  hibernate id new generator mappings  gt false lt  property gt    see and link   For older version of hibernate 4 x   lt prop key  hibernate id new generator mappings  gt false lt  prop gt

User · Answer

This is the reason behind this error   It will look for how the database that you are using generates ids  For MySql or HSQSL  there are increment fields that automatically increment  In Postgres or Oracle  they use sequence tables  Since you didn t specify a sequence table name  it will look for a sequence table named hibernate sequence and use it for default  So you probably don t have such a sequence table in your database and now you get that error

User · Answer

In my case  replacing all annotations GenerationType AUTO by GenerationType SEQUENCE solved the issue

User · Answer

I was getting the same error  com mysql jdbc exceptions jdbc4 MySQLSyntaxErrorException  Table  mylocaldb hibernate sequence  doesn t exist    Using spring mvc 4 3 7 and hibernate version 5 2 9  application is made using spring java based configuration  Now I have to add the hibernate id new generator mappings property mentioned by  Eva Mariam in my code like this    Autowired      Bean name    sessionFactory       public SessionFactory getSessionFactory DataSource dataSource             LocalSessionFactoryBuilder sessionBuilder   new LocalSessionFactoryBuilder dataSource           sessionBuilder addProperties getHibernateProperties             sessionBuilder addAnnotatedClasses User class            return sessionBuilder buildSessionFactory               private Properties getHibernateProperties             Properties properties   new Properties            properties put  hibernate show sql    true            properties put  hibernate dialect    org hibernate dialect MySQLDialect            properties put  hibernate id new generator mappings   false            return properties          And it worked like charm

User · Answer

I added Hibernate sequence in postgres  Run this query in PostGres Editor       CREATE SEQUENCE hibernate sequence   INCREMENT 1   MINVALUE 1   MAXVALUE 9223372036854775807   START 2   CACHE 1  ALTER TABLE hibernate sequence   OWNER TO postgres    I will find out the pros cons of using the query but for someone who need help can use this

User · Answer

FYI  If you are using hbm files to define the O R mapping   Notice that   In Hibernate 5  the param name for the sequence name has been changed   The following setting worked fine in Hibernate 4    lt generator class  sequence  gt       lt param name  sequence  gt xxxxxx seq lt  param gt   lt  generator gt    But in Hibernate 5  the same mapping setting file will cause a  hibernate sequence doesn t exist  error   To fix this error  the param name must change to    lt generator class  sequence  gt       lt param name  sequence name  gt xxxxxx seq lt  param gt   lt  generator gt    This problem wasted me 2  3 hours   And somehow  it looks like there are no document about it   I have to read the source code of org hibernate id enhanced SequenceStyleGenerator to figure it out

User · Answer

You can also put     GeneratedValue strategy   GenerationType IDENTITY    And let the DateBase manage the incrementation of the primary key   AUTO INCREMENT PRIMARY KEY   The above answer helped me

User · Answer

in hibernate 5 x  you should add set hibernate id new generator mappings to false in hibernate cfg xml   lt session-factory gt                  lt property name  show sql  gt 1 lt  property gt       lt property name  hibernate id new generator mappings  gt false lt  property gt                lt  session-factory gt

User · Answer

This might be caused by HHH-10876 which got fixed so make sure you update to    Hibernate ORM 5 2 1   Hibernate ORM 5 1 1   Hibernate ORM 5 0 11

User · Answer

When you use     GeneratedValue strategy GenerationType AUTO    or   GeneratedValue which is short hand way of the above  Hibernate starts to decide the best   generation strategy for you  in this case it has selected    GenerationType SEQUENCE as the strategy and that is why it is looking for     schemaName hibernate sequence which is a table  for sequence based id generation   When you use GenerationType SEQUENCE as the strategy you need to provide the  TableGenerator as follows           Id       GeneratedValue strategy   GenerationType TABLE  generator    user table generator         TableGenerator name    user table generator                   table    user keys   pkColumnName    PK NAME   valueColumnName    PK VALUE         Column name    USER ID        private long userId    When you set the strategy it the to    GeneratedValue strategy   GenerationType IDENTITY      original issue get resolved because then Hibernate stop looking for sequence table

User · Answer

Just in case someone pulls their hair out with this problem like I did today  I couldn t resolve this error until I changed  spring jpa hibernate dll-auto create   to  spring jpa properties hibernate hbm2ddl auto create

User · Answer

If you are using Hibernate version prior to Hibernate5  GeneratedValue strategy   GenerationType IDENTITY  works like a charm  But post Hibernate5 the following fix is necessary    Id  GeneratedValue strategy  GenerationType AUTO generator  native    GenericGenerator name    native  strategy    native   private Long id    DDL   id  BIGINT 20  NOT NULL AUTO INCREMENT PRIMARY KEY   REASON  Excerpt from hibernate-issue     Currently  if the hibernate id new generator mappings is set to false     GeneratedValue strategy   GenerationType AUTO  is mapped to native     If this property is true  which is the defult value in 5 x   the    GeneratedValue strategy   GenerationType AUTO  is always mapped to   SequenceStyleGenerator       For this reason  on any database that does not support sequences   natively  e g  MySQL  we are going to use the TABLE generator instead   of IDENTITY       However  TABLE generator  although more portable  uses a separate   transaction every time a value is being fetched from the database  In   fact  even if the IDENTITY disables JDBC batch updates and the TABLE   generator uses the pooled optimizer  the IDENTITY still scales better

[java] Hibernate-sequence doesn't exist

Solution

Explanation

Examples related to java

Examples related to spring

Examples related to hibernate