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

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>