Hibernate Books

All times are UTC - 5 hours [ DST ]



Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Table 'hibernate_sequence' doesn't exist on MySQL
PostPosted: Tue Aug 22, 2017 1:12 am 
Beginner
Beginner

Joined: Tue Aug 08, 2017 12:14 am
Posts: 20
Hi experts,

I got error that Hibernate-sequence doesn't exist.

And then I tried to follow the advice from https://stackoverflow.com/questions/329 ... esnt-exist

However, when I put it in my hibernate.cfg.xml file, eclipse gives an x beside the line

Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

   
<hibernate-configuration>
        
<session-factory>
            <!-- Database connection settings -->
    <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="connection.url">jdbc:mysql://localhost:3306/hi5</property>
    <property name="connection.username">root</property>
    <property name="connection.password">root</property>
   <!-- JDBC connection pool (use the built-in) -->
    <property name="connection_pool_size">true</property>


<!-- Use the C3P0 connection pool. --> 
        <property name="c3p0.min_size">3</property> 
        <property name="c3p0.max_size">5</property> 
        <property name="c3p0.timeout">1800</property>
   
   <!-- SQL dialect -->
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

    <!-- Disable the second-level cache -->
    <property name="cache.provider_class">org.hibernate.NoCacheProvider</property>

<property name="hibernate.current_session_context_class">org.hibernate.context.internal.ThreadLocalSessionContext</property>
    <!-- Echo all executed SQL to stdout -->
    <property name="show_sql">1</property>
    <property key="hibernate.id.new_generator_mappings">false</property>
    <mapping class="model.Tutor"/>
    <mapping class="model.Subject"/>

</session-factory>
</hibernate-configuration>   


Where should I put this line and why am I getting an error ?


Top
 Profile  
 
 Post subject: Re: hibernate.id.new_generator_mappings property set to false
PostPosted: Wed Aug 23, 2017 4:00 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1430
Code:
<property name="show_sql">1</property>
<property key="hibernate.id.new_generator_mappings">false</property>


If you look closer to these two lines, you'll see that one uses the name attribute while the other uses key instead.

The fix is as simple as this:

Code:
s/key/name

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: hibernate.id.new_generator_mappings property set to false
PostPosted: Wed Aug 23, 2017 6:14 am 
Beginner
Beginner

Joined: Tue Aug 08, 2017 12:14 am
Posts: 20
vlad wrote:
Code:
<property name="show_sql">1</property>
<property key="hibernate.id.new_generator_mappings">false</property>


If you look closer to these two lines, you'll see that one uses the name attribute while the other uses key instead.

The fix is as simple as this:

Code:
s/key/name


Hi,

I have changed it to <property name="hibernate.id.new_generator_mappings">false</property> and there is no more error. Tks.

However, I am still getting the following error...
I tried with @GeneratedValue(strategy = GenerationType.AUTO) or changed it to GenerationType.Sequence...all not working.

What could be cause of this error below ?

Code:
Aug 23, 2017 6:09:13 PM org.hibernate.id.enhanced.TableStructure$1$1 execute
ERROR: could not read a hi value
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hi5.hibernate_sequence' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.Util.getInstance(Util.java:387)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
   at org.hibernate.id.enhanced.TableStructure.executeQuery(TableStructure.java:216)
   at org.hibernate.id.enhanced.TableStructure.access$300(TableStructure.java:46)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:138)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:126)
   at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:55)
   at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:57)
   at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:125)
   at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
   at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:432)
   at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
   at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
   at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
   at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:689)
   at org.hibernate.internal.SessionImpl.save(SessionImpl.java:681)
   at org.hibernate.internal.SessionImpl.save(SessionImpl.java:676)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:497)
   at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:355)
   at com.sun.proxy.$Proxy33.save(Unknown Source)
   at DAOSql.tutorDAOImpl.insertTutor(tutorDAOImpl.java:63)
   at Business.Manager.insertTutor(Manager.java:24)
   at controller.tutorController.doPost(tutorController.java:128)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)

Aug 23, 2017 6:09:13 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1146, SQLState: 42S02
Aug 23, 2017 6:09:13 PM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Table 'hi5.hibernate_sequence' doesn't exist
org.hibernate.exception.SQLGrammarException: error performing isolated work
   at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
   at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
   at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:79)
   at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:125)
   at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
   at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:432)
   at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
   at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
   at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
   at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
   at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:689)
   at org.hibernate.internal.SessionImpl.save(SessionImpl.java:681)
   at org.hibernate.internal.SessionImpl.save(SessionImpl.java:676)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:497)
   at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:355)
   at com.sun.proxy.$Proxy33.save(Unknown Source)
   at DAOSql.tutorDAOImpl.insertTutor(tutorDAOImpl.java:63)
   at Business.Manager.insertTutor(Manager.java:24)
   at controller.tutorController.doPost(tutorController.java:128)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hi5.hibernate_sequence' doesn't exist
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.Util.getInstance(Util.java:387)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2550)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
   at org.hibernate.id.enhanced.TableStructure.executeQuery(TableStructure.java:216)
   at org.hibernate.id.enhanced.TableStructure.access$300(TableStructure.java:46)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:138)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:126)
   at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:55)
   at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:57)
   ... 43 more
Aug 23, 2017 6:09:13 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
INFO: HHH10001008: Cleaning up connection pool [jdbc:mysql://localhost:3306/hi5]
Aug 23, 2017 6:09:13 PM org.hibernate.engine.jdbc.connections.internal.PooledConnections close
ERROR: Collection leak detected: there are 1 unclosed connections upon shutting down pool jdbc:mysql://localhost:3306/hi5


Top
 Profile  
 
 Post subject: Re: hibernate.id.new_generator_mappings property set to false
PostPosted: Wed Aug 23, 2017 6:26 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1430
On a production setup or a real application, you'd need to use an automatic schema migration tool, like Flyway.

Because this is just a test project, you can auto generate your schema:

Code:
<property name="hibernate.hbm2ddl.auto">update</property>


If you don't generate the DB schema automatically, then you'll need to do it manually according to what Hibernate expects to find in the DB according to your mappings.

Anyway, since you are using MySQL, using AUTO is quite a bad idea. Check out this article for more details.

But, there's even more.

You decide to set the hibernate.id.new_generator_mappings property to false for no good reason. This property should be set to false only when migrating from Hibernate 4 to 5 while relying on hi/lo optimization for the sequence-based optimizers. I doubt that's you use case here.

What you need to do at this point is to:

1) Read the Hibernate User Guide.
1) Read these Hibernate tutorials on vladmihalcea.com.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
 Post subject: Re: hibernate.id.new_generator_mappings property set to false
PostPosted: Thu Aug 24, 2017 2:21 am 
Beginner
Beginner

Joined: Tue Aug 08, 2017 12:14 am
Posts: 20
vlad wrote:
On a production setup or a real application, you'd need to use an automatic schema migration tool, like Flyway.

Because this is just a test project, you can auto generate your schema:

Code:
<property name="hibernate.hbm2ddl.auto">update</property>


If you don't generate the DB schema automatically, then you'll need to do it manually according to what Hibernate expects to find in the DB according to your mappings.

Anyway, since you are using MySQL, using AUTO is quite a bad idea. Check out this article for more details.

But, there's even more.

You decide to set the hibernate.id.new_generator_mappings property to false for no good reason. This property should be set to false only when migrating from Hibernate 4 to 5 while relying on hi/lo optimization for the sequence-based optimizers. I doubt that's you use case here.

What you need to do at this point is to:

1) Read the Hibernate User Guide.
1) Read these Hibernate tutorials on vladmihalcea.com.


Tks for the pointer.
Both strategies I attempted did not work out.
I attempted the first one which is 'native'... it gives me error :
No generator named 'native' is defined in the persistence unit.

Then, I followed the sequence strategy as per your tutorial.

However, I am still getting another error :

Code:
Initial SessionFactory creation failed.org.hibernate.MappingException: org.hibernate.dialect.MySQLDialect does not support pooled sequences
Aug 24, 2017 2:18:16 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [tutorController] in context with path [/Hi5S] threw exception [Servlet execution threw an exception] with root cause
org.hibernate.MappingException: org.hibernate.dialect.MySQLDialect does not support pooled sequences
   at org.hibernate.dialect.Dialect.getCreateSequenceString(Dialect.java:905)
   at org.hibernate.dialect.Dialect.getCreateSequenceStrings(Dialect.java:863)
   at org.hibernate.tool.schema.internal.StandardSequenceExporter.getSqlCreateStrings(StandardSequenceExporter.java:28)
   at org.hibernate.tool.schema.internal.StandardSequenceExporter.getSqlCreateStrings(StandardSequenceExporter.java:18)
   at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:224)
   at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)
   at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
   at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
   at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309)
   at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:452)
   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)
   at util.HibernateUtil.<clinit>(HibernateUtil.java:18)
   at DAOSql.tutorDAOImpl.insertTutor(tutorDAOImpl.java:42)
   at Business.Manager.insertTutor(Manager.java:24)
   at controller.tutorController.doPost(tutorController.java:128)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
   at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
   at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
   at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   at java.lang.Thread.run(Thread.java:745)



Top
 Profile  
 
 Post subject: Re: Table 'hibernate_sequence' doesn't exist on MySQL
PostPosted: Thu Aug 24, 2017 2:43 am 
Hibernate Team
Hibernate Team

Joined: Thu Sep 11, 2014 2:50 am
Posts: 1430
Most likely, you forced MySQL to use a SEQUENCE which is not supported in the latest MySQL versions 5.7 or 8.0.

_________________
If you liked my answer, you are going to love my High-Performance Java Persistence book and my blog as well.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.