hibernate中的错Table/View 'HIBERNATE_UNIQUE_KEY' does not exis
j2ee吧
全部回复
仅看楼主
level 1
dong121011 楼主
0 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Table/View 'HIBERNATE_UNIQUE_KEY' does not exist. org.hibernate.exception.SQLGrammarException: could not get or update next value at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:41) at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:187) at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:43) at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:51) at org.hibernate.id.TableGenerator.generate(TableGenerator.java:94) at org.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:61) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) at net.dao.hbn.ActorDaoHbnImpl.insert(ActorDaoHbnImpl.java:24) at net.service.impl.GameServiceImpl.add(GameServiceImpl.java:18) at net.service.tx.GameServiceHbnTxProxy.add(GameServiceHbnTxProxy.java:26) at net.dao.AppTest.init(AppTest.java:35) at net.dao.AppTest.main(AppTest.java:12) Caused by: java.sql.SQLException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist. at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at org.hibernate.id.TableGenerator.doWorkInCurrentTransaction(TableGenerator.java:131) at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:38) ... 19 more Caused by: org.apache.derby.client.am.SqlException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist. at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) 
2008年04月11日 05点04分 1
level 1
dong121011 楼主
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 22 more Exception in thread "main" net.service.GameServiceException: org.hibernate.exception.SQLGrammarException: could not get or update next value at net.service.tx.GameServiceHbnTxProxy.add(GameServiceHbnTxProxy.java:33) at net.dao.AppTest.init(AppTest.java:35) at net.dao.AppTest.main(AppTest.java:12) Caused by: org.hibernate.exception.SQLGrammarException: could not get or update next value at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:41) at org.hibernate.engine.transaction.Isolater$JdbcDelegate.delegateWork(Isolater.java:187) at org.hibernate.engine.transaction.Isolater.doIsolatedWork(Isolater.java:43) at org.hibernate.engine.TransactionHelper.doWorkInNewTransaction(TransactionHelper.java:51) at org.hibernate.id.TableGenerator.generate(TableGenerator.java:94) at org.hibernate.id.TableHiLoGenerator.generate(TableHiLoGenerator.java:61) at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) at net.dao.hbn.ActorDaoHbnImpl.insert(ActorDaoHbnImpl.java:24) at net.service.impl.GameServiceImpl.add(GameServiceImpl.java:18) at net.service.tx.GameServiceHbnTxProxy.add(GameServiceHbnTxProxy.java:26) ... 2 more Caused by: java.sql.SQLException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist. at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatement(Unknown Source) at org.hibernate.id.TableGenerator.doWorkInCurrentTransaction(TableGenerator.java:131) at org.hibernate.engine.TransactionHelper$1Work.doWork(TransactionHelper.java:38) ... 19 more Caused by: org.apache.derby.client.am.SqlException: Table/View 'HIBERNATE_UNIQUE_KEY' does not exist. at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source) at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source) at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source) at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown Source) at org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source) at org.apache.derby.client.am.Connection.prepareStatementX(Unknown Source) ... 22 more 
2008年04月11日 05点04分 2
level 1
你sql里有唯一字段。唯一字段映射成hibernate关系有点问题. 你检查下hibernate映射文件的唯一字段.
2008年04月11日 10点04分 3
level 1
dong121011 楼主
哦。。。谢谢。。
2008年04月15日 01点04分 4
1