could not get next sequence value hibernate.hbm2ddl.auto=update hibernate.default_schema

最新推荐文章于 2024-05-09 14:49:37 发布

pythonm

最新推荐文章于 2024-05-09 14:49:37 发布

阅读量1.6k

点赞数

CC 4.0 BY-SA版权

分类专栏： Hibernate 文章标签： schema generator oracle spring sql class

本文链接：https://blog.youkuaiyun.com/pythonm/article/details/6591582

Hibernate 专栏收录该内容

1 篇文章

订阅专栏

本文解决了一个Hibernate在Oracle数据库中尝试生成序列值时遇到的问题，并详细介绍了正确的配置方式以避免ORA-02289错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ibernate:
    select
        person_id_seq.nextval
    from
        dual
org.hibernate.exception.SQLGrammarException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:119)
  at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: java.sql.SQLException: ORA-02289: 序列（号）不存在

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:880)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2516)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2850)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:537)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:98)
... 40 more

oracle 连接hibernate

hibernate.hbm2ddl.auto=update

自动生成oracle中的表

正确配置

hibernate

<id name="id" type="java.lang.Integer">
            <generator class="sequence">
            <param name="sequence">person_id_seq</param>
            </generator>
</id>
设置sequence参数

spring 中beans配置：

<property name="hibernateProperties">
       <value>
         hibernate.dialect=org.hibernate.dialect.Oracle9iDialect
         hibernate.show_sql=true
         hibernate.format_sql=true
         hibernate.hbm2ddl.auto=update
         hibernate.default_schema=oracle当前连接用户（必加项，不加时有可能不能创建表的sequence，因为各用户空间可能错位关联，以致不能正确创建表）
         </value>
     </property>