let [dispatcherServlet] in context with path [/bs] threw exception [Request processing failed: org.springframework.dao.
InvalidDataAccessResourceUsageException: could not extract ResultSet [‘progate.hibernate_sequence’ is not a SEQUENCE] [
select next value for hibernate_sequence]; SQL [select next value for hibernate_sequence]] with root cause
java.sql.SQLSyntaxErrorException: ‘progate.hibernate_sequence’ is not a SEQUENCE
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:112)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:114)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:988)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1056)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:706)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:53)
at org.hibernate.id.enhanced.SequenceStructure$1.getNextValue(SequenceStructure.java:115)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:562)
at org.hibernate.id.IdentifierGenerator.generate(IdentifierGenerator.java:135)
at org.hibernate.event.internal.AbstractSaveEventListener.generateId(AbstractSaveEventListener.java:164)
at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:12
9)
at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:144)
at org.hibernate.event.internal.DefaultPersistEventListener.persist(DefaultPersistEventListener.java:91)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:75)
at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:51)
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138)
at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:709)
at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:692)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
at java.base/java.lang.reflect.Method.invoke(Method.java:565)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntit
I don’t know what you expect by posting a stack trace without any details or saying the things you tried already. If you want help, ask targeted questions.
Sorry for that, Eventually I figured it out myself it was because of mariadb
In MariaDB 11 (with Hibernate 7),hibernate_sequence must be a native SEQUENCE object rather than a standard TABLE