Execption: the database returned no natively generated identity value, execptionnatively
Org. hibernate. HibernateException: The database returned no natively generated identity value
At org. hibernate. id. IdentifierGeneratorHelper. getGeneratedIdentity (IdentifierGeneratorHelper. java: 90)
At org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.exe cuteAndExtract (IdentityGenerator. java: 100)
At org. hibernate. id. insert. AbstractReturningDelegate. abstrminsert (AbstractReturningDelegate. java: 58)
At org. hibernate. persister. entity. AbstractEntityPersister. insert (AbstractEntityPersister. java: 2975)
At org. hibernate. persister. entity. AbstractEntityPersister. insert (AbstractEntityPersister. java: 3487)
At org.hibernate.action.internal.EntityIdentityInsertAction.exe cute (EntityIdentityInsertAction. java: 81)
At org.hibernate.engine.spi.ActionQueue.exe cute (ActionQueue. java: 377)
At org. hibernate. engine. spi. ActionQueue. addResolvedEntityInsertAction (ActionQueue. java: 214)
At org. hibernate. engine. spi. ActionQueue. addInsertAction (ActionQueue. java: 194)
At org. hibernate. engine. spi. ActionQueue. addAction (ActionQueue. java: 178)
At org. hibernate. event. internal. AbstractSaveEventListener. addInsertAction (AbstractSaveEventListener. java: 321)
At org. hibernate. event. internal. AbstractSaveEventListener. abstrmsaveorreplicate (AbstractSaveEventListener. java: 286)
At org. hibernate. event. internal. AbstractSaveEventListener. abstrmsave (AbstractSaveEventListener. java: 192)
At org. hibernate. event. internal. AbstractSaveEventListener. saveWithGeneratedId (AbstractSaveEventListener. java: 125)
At org. hibernate. event. internal. DefaultSaveOrUpdateEventListener. saveWithGeneratedOrRequestedId (DefaultSaveOrUpdateEventListener. java: 206)
At org. hibernate. event. internal. DefaultSaveEventListener. saveWithGeneratedOrRequestedId (DefaultSaveEventListener. java: 55)
At org. hibernate. event. internal. DefaultSaveOrUpdateEventListener. entityIsTransient (DefaultSaveOrUpdateEventListener. java: 191)
At org. hibernate. event. internal. DefaultSaveEventListener. performSaveOrUpdate (DefaultSaveEventListener. java: 49)
At org. hibernate. event. internal. DefaultSaveOrUpdateEventListener. onSaveOrUpdate (DefaultSaveOrUpdateEventListener. java: 90)
At org. hibernate. internal. SessionImpl. fireSave (SessionImpl. java: 764)
At org. hibernate. internal. SessionImpl. save (SessionImpl. java: 756)
At org. hibernate. internal. SessionImpl. save (SessionImpl. java: 752)
At com. bjsxt. dao. impl. UserDAOImpl. save (UserDAOImpl. java: 27)
At com. bjsxt. service. UserService. add (UserService. java: 33)
At com. bjsxt. service. UserService $ FastClassBySpringCGLIB $ 189fc15d. invoke (<generated>)
At org. springframework. cglib. proxy. MethodProxy. invoke (MethodProxy. java: 204)
At org. springframework. aop. framework. CglibAopProxy $ CglibMethodInvocation. invokeJoinpoint (CglibAopProxy. java: 720)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 157)
At org. springframework. transaction. interceptor. TransactionInterceptor $1. proceedWithInvocation (TransactionInterceptor. java: 99)
At org. springframework. transaction. interceptor. TransactionAspectSupport. invokeWithinTransaction (TransactionAspectSupport. java: 280)
At org. springframework. transaction. interceptor. TransactionInterceptor. invoke (TransactionInterceptor. java: 96)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 179)
At org. springframework. aop. framework. CglibAopProxy $ DynamicAdvisedInterceptor. intercept (CglibAopProxy. java: 655)
At com. bjsxt. service. UserService $ EnhancerBySpringCGLIB $52fc0e09. add (<generated>)
At com. bjsxt. service. UserServiceTest. testAdd (UserServiceTest. java: 20)
At sun. reflect. NativeMethodAccessorImpl. invoke0 (Native Method)
At sun. reflect. NativeMethodAccessorImpl. invoke (Unknown Source)
At sun. reflect. DelegatingMethodAccessorImpl. invoke (Unknown Source)
At java. lang. reflect. Method. invoke (Unknown Source)
At org. junit. runners. model. FrameworkMethod $1. runReflectiveCall (FrameworkMethod. java: 50)
At org. junit. internal. runners. model. ReflectiveCallable. run (ReflectiveCallable. java: 12)
At org. junit. runners. model. FrameworkMethod. invokeExplosively (FrameworkMethod. java: 47)
At org. junit. internal. runners. statements. InvokeMethod. evaluate (InvokeMethod. java: 17)
At org. junit. runners. ParentRunner. runLeaf (ParentRunner. java: 325)
At org. junit. runners. BlockJUnit4ClassRunner. runChild (BlockJUnit4ClassRunner. java: 78)
At org. junit. runners. BlockJUnit4ClassRunner. runChild (BlockJUnit4ClassRunner. java: 57)
At org. junit. runners. ParentRunner $ 3.run( ParentRunner. java: 290)
At org. junit. runners. ParentRunner $1. schedule (ParentRunner. java: 71)
At org. junit. runners. ParentRunner. runChildren (ParentRunner. java: 288)
At org. junit. runners. ParentRunner. access $000 (ParentRunner. java: 58)
At org. junit. runners. ParentRunner $2. evaluate (ParentRunner. java: 268)
At org. junit. runners. ParentRunner. run (ParentRunner. java: 363)
At org. eclipse. jdt. internal. junit4.runner. JUnit4TestReference. run (JUnit4TestReference. java: 86)
At org. eclipse. jdt. internal. junit. runner. TestExecution. run (TestExecution. java: 38)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. runTests (RemoteTestRunner. java: 459)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. runTests (RemoteTestRunner. java: 678)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. run (RemoteTestRunner. java: 382)
At org. eclipse. jdt. internal. junit. runner. RemoteTestRunner. main (RemoteTestRunner. java: 192)
Technology used: spring + hibernate
Cause of exception: after spring integrates hibernate, it is directly configured in spring's session-Factory, and the aning is set through annotation (@ entity), but the primary key growth mode is not specified through annotation, after the object is instantiated, it is directly persisted to the database without assigning an initial value for the id, and the database does not set the id to auto_increment.
Result: The primary key value of the database cannot be determined, that is, null, which violates the entity integrity of the primary key of the database.
Deeeeeeebug: solution 1: add note: Add annotation to the getId Function
@ GenericGenerator (name = "generatsr", strategy = "increment") // sets the growth mode.
@ GeneratedValue (generator = "generatsr ")
Solution 2: assign an initial value to the primary key when the instance persists the object
Solution 3: Set the primary key to auto_increment on the database.