首页 > 代码库 > could not retrieve snapshot:

could not retrieve snapshot:

org.hibernate.exception.SQLGrammarException: could not retrieve snapshot: [com.pear.zcp.hkgt.Option#10002]    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)    at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1137)    at org.hibernate.engine.StatefulPersistenceContext.getDatabaseSnapshot(StatefulPersistenceContext.java:292)    at org.hibernate.engine.ForeignKeys.isTransient(ForeignKeys.java:211)    at org.hibernate.event.def.AbstractSaveEventListener.getEntityState(AbstractSaveEventListener.java:531)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:103)    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)    at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:685)    at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:677)    at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252)    at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392)    at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335)    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)    at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425)    at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:362)    at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:338)    at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)    at org.hibernate.engine.Cascade.cascade(Cascade.java:161)    at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:154)    at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:145)    at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:88)    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)    at com.pear.zcp.hkgt.TestQuestion.saveQuestion(TestQuestion.java:55)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)    at java.lang.reflect.Method.invoke(Method.java:597)    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)    at org.junit.runners.ParentRunner.run(ParentRunner.java:309)    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near OPTION option_ where option_.OPTION_ID=10002 at line 1    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)    at com.mysql.jdbc.Util.getInstance(Util.java:381)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)    at org.hibernate.persister.entity.AbstractEntityPersister.getDatabaseSnapshot(AbstractEntityPersister.java:1110)    ... 48 more

原来是option 是mysql的关键字。。。

could not retrieve snapshot: