以前插入一条是用这样的方法(指定ID指) CommunityarticleDao dao = new  CommunityarticleDaoimpl();
Communityarticle article = new Communityarticle();

article.setArticleid(new Integer(5));
article.setCreatetime("99");

dao.saveCommunityarticle(article);现在那个setArticleid方法里应该写什么呢?

解决方案 »

  1.   

    如果设置了自增的话就不需要再调用setArticleid()方法了,hibernate会自动判断最大的ID然后+1
      

  2.   

    楼上的朋友...如果我不写article.setArticleid(new Integer(5));这句..报错
      

  3.   

    Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not get next sequence value
    at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
    at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:96)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:85)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
    at com.bizengine.km.daoimpl.CommunityarticleDaoimpl.saveCommunityarticle(CommunityarticleDaoimpl.java:45)
    at com.bizengine.km.test.Testarticle.main(Testarticle.java:30)
    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:573)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
    at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
    at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)
    ... 10 more
      

  4.   

    <id name="articleid" type="integer">
                <column name="ARTICLEID" precision="22" scale="0" />
                <generator class="sequence" />
    ============================================================
    改为
    <id name="articleid" type="integer">
                <column name="ARTICLEID" precision="22" scale="0" />
                <generator class="sequence" >
                  <param name="sequence">你创建的序列</param>
          </generator>