# java.sql.SQLSyntaxErrorException: Table 'Database.hibernate\_sequences' doesn't exist

**URL:** <https://discourse.hibernate.org/t/java-sql-sqlsyntaxerrorexception-table-database-hibernate-sequences-doesnt-exist/5539>\
**Category:** Hibernate ORM\
**Created:** [July 13, 2021, 12:38pm UTC](https://discourse.hibernate.org/t/java-sql-sqlsyntaxerrorexception-table-database-hibernate-sequences-doesnt-exist/5539 "2021-07-13T12:38:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aapathak1221](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@aapathak1221](https://discourse.hibernate.org/u/aapathak1221)\
**Post date:** [July 13, 2021, 12:38pm UTC](https://discourse.hibernate.org/t/java-sql-sqlsyntaxerrorexception-table-database-hibernate-sequences-doesnt-exist/5539/1 "2021-07-13T12:38:29Z")

</div>

I am getting below error:  
[ERROR] 2021-07-13 12:21:23.164 TableGenerator - HHH000351: Could not read or init a hi value  
java.sql.SQLSyntaxErrorException: Table ‘database.hibernate\_sequences’ doesn’t exist  
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.25.jar:8.0.25]  
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.25.jar:8.0.25]  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.25.jar:8.0.25]  
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql-connector-java-8.0.25.jar:8.0.25]  
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431) ~[c3p0-0.9.5.4.jar:0.9.5.4]  
at org.hibernate.id.enhanced.TableGenerator.executeQuery(TableGenerator.java:705) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.TableGenerator.access$400(TableGenerator.java:132) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.TableGenerator$1$1.execute(TableGenerator.java:589) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.TableGenerator$1$1.execute(TableGenerator.java:575) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:55) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:57) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.TableGenerator$1.getNextValue(TableGenerator.java:574) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.id.enhanced.TableGenerator.generate(TableGenerator.java:570) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:115) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:185) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:128) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:55) ~[hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:93) [hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:720) [hibernate-core-5.4.30.Final.jar:5.4.30.Final]  
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:706) [hibernate-core-5.4.30.Final.jar:5.4.30.Final]

I am using Inheritance type TABLE\_PER\_CLASS and tried Generate value AUTO, TABLE, IDENTITY, SEQUENCE but same error.

[ERROR] 2021-07-13 12:21:23.164 TableGenerator - HHH000351: Could not read or init a hi value

---

<div class="post-metadata">

**Author:** ![aapathak1221](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@aapathak1221](https://discourse.hibernate.org/u/aapathak1221)\
**Post date:** [July 13, 2021, 12:55pm UTC](https://discourse.hibernate.org/t/java-sql-sqlsyntaxerrorexception-table-database-hibernate-sequences-doesnt-exist/5539/2 "2021-07-13T12:55:37Z")

</div>

Please find entity.

 ![entiry](https://canada1.discourse-cdn.com/flex035/uploads/hibernate/original/2X/6/6ae0432a3d3d0e33a917cac0044ecdbfc133cdb8.png)

---

<div class="post-metadata">

**Author:** ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)\
**Post date:** [July 19, 2021, 12:14pm UTC](https://discourse.hibernate.org/t/java-sql-sqlsyntaxerrorexception-table-database-hibernate-sequences-doesnt-exist/5539/3 "2021-07-19T12:14:56Z")

</div>

The error is telling you that the table to implement sequence based id generation is missing. What is it that you don’t understand there? If you are not using the hbm2ddl tool to automatically generate these tables, you will have to create this table manually in your database. Then your application will also startup properly.