When Mysql database hibernate saves data, the Mysql primary key must be set to auto-increment; otherwise, an error is returned! (Field Hibernate
The reason for the bitsCN.com problem is very simple. sometimes it may be hard to remember. MARK.
The error message is as follows:
Org. springframework. jdbc. uncategorizedSQLException: Hibernate operation: cocould not insert: [com. wondertek. meeting. model. spokesman. spokesman]; uncategorized SQLException for SQL [insert into Spokesman (mobile, gender, create_time, creator) values (?, ?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'id' doesn' t have a default value; nested exception is java. SQL. SQLException:
Field 'id' doesn' t have a default value
At org. springframework. jdbc. support. AbstractFallbackSQLExceptionTranslator. translate (AbstractFallbackSQLExceptionTranslator. java: 83)
At org. springframework. jdbc. support. AbstractFallbackSQLExceptionTranslator. translate (AbstractFallbackSQLExceptionTranslator. java: 80)
At org. springframework. jdbc. support. AbstractFallbackSQLExceptionTranslator. translate (AbstractFallbackSQLExceptionTranslator. java: 80)
At org. springframework. orm. hibernate3.HibernateAccessor. convertJdbcAccessException (HibernateAccessor. java: 424)
At org. springframework. orm. hibernate3.HibernateAccessor. convertHibernateAccessException (HibernateAccessor. java: 410)
At org. springframework. orm. hibernate3.HibernateTemplate. doExecute (HibernateTemplate. java: 411)
At org.springframework.orm.hibernate3.HibernateTemplate.exe cuteWithNativeSession (HibernateTemplate. java: 374)
At org. springframework. orm. hibernate3.HibernateTemplate. saveOrUpdate (HibernateTemplate. java: 737)
At com. wondertek. meeting. dao. impl. BaseDaoImpl. saveOrUpdateEntity (BaseDaoImpl. java: 83)
At com. wondertek. meeting. dao. impl. SpokesmanDaoImpl. saveOrUpdateEntity (SpokesmanDaoImpl. java)
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. springframework. aop. support. AopUtils. invokeJoinpointUsingReflection (AopUtils. java: 309)
At org. springframework. aop. framework. JdkDynamicAopProxy. invoke (JdkDynamicAopProxy. java: 196)
At $ Proxy72.saveOrUpdateEntity (Unknown Source)
At com. wondertek. meeting. service. impl. BaseServiceImpl. saveOrUpdate (BaseServiceImpl. java: 58)
At com. wondertek. meeting. service. impl. SpokesmanServiceImpl. saveOrUpdate (SpokesmanServiceImpl. java)
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. springframework. aop. support. AopUtils. invokeJoinpointUsingReflection (AopUtils. java: 309)
At org. springframework. aop. framework. ReflectiveMethodInvocation. invokeJoinpoint (ReflectiveMethodInvocation. java: 183)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 150)
At org. springframework. transaction. interceptor. TransactionInterceptor. invoke (TransactionInterceptor. java: 110)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 172)
At org. springframework. aop. interceptor. ExposeInvocationInterceptor. invoke (ExposeInvocationInterceptor. java: 89)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 172)
At org. springframework. aop. framework. JdkDynamicAopProxy. invoke (JdkDynamicAopProxy. java: 202)
At $ Proxy125.saveOrUpdate (Unknown Source)
At com. wondertek. meeting. action. spokesman. SpokesmanAction. saveSpokesMan (SpokesmanAction. java: 79)
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 com. opensymphony. xwork2.defaactionactioninvocation. invokeAction (DefaultActionInvocation. java: 441)
At com. opensymphony. xwork2.DefaultActionInvocation. invokeActionOnly (DefaultActionInvocation. java: 280)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 243)
At com. wondertek. meeting. interceptor. AnalyticsInterceptor. intercept (AnalyticsInterceptor. java: 92)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. DefaultWorkflowInterceptor. doIntercept (defaworkworkflowinterceptor. java: 165)
At com. opensymphony. xwork2.interceptor. MethodFilterInterceptor. intercept (MethodFilterInterceptor. java: 87)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.validator. ValidationInterceptor. doIntercept (ValidationInterceptor. java: 252)
At org. apache. struts2.interceptor. validation. AnnotationValidationInterceptor. doIntercept (AnnotationValidationInterceptor. java: 68)
At com. opensymphony. xwork2.interceptor. MethodFilterInterceptor. intercept (MethodFilterInterceptor. java: 87)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ConversionErrorInterceptor. intercept (ConversionErrorInterceptor. java: 122)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ParametersInterceptor. doIntercept (ParametersInterceptor. java: 195)
At com. opensymphony. xwork2.interceptor. MethodFilterInterceptor. intercept (MethodFilterInterceptor. java: 87)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ParametersInterceptor. doIntercept (ParametersInterceptor. java: 195)
At com. opensymphony. xwork2.interceptor. MethodFilterInterceptor. intercept (MethodFilterInterceptor. java: 87)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. StaticParametersInterceptor. intercept (StaticParametersInterceptor. java: 179)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org. apache. struts2.interceptor. MultiselectInterceptor. intercept (MultiselectInterceptor. java: 75)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org. apache. struts2.interceptor. CheckboxInterceptor. intercept (CheckboxInterceptor. java: 94)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org. apache. struts2.interceptor. FileUploadInterceptor. intercept (FileUploadInterceptor. java: 235)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ModelDrivenInterceptor. intercept (ModelDrivenInterceptor. java: 89)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ScopedModelDrivenInterceptor. intercept (ScopedModelDrivenInterceptor. java: 130)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org. apache. struts2.interceptor. debugging. DebuggingInterceptor. intercept (DebuggingInterceptor. java: 267)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ChainingInterceptor. intercept (ChainingInterceptor. java: 126)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. PrepareInterceptor. doIntercept (PrepareInterceptor. java: 138)
At com. opensymphony. xwork2.interceptor. MethodFilterInterceptor. intercept (MethodFilterInterceptor. java: 87)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. I18nInterceptor. intercept (I18nInterceptor. java: 165)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org. apache. struts2.interceptor. ServletConfigInterceptor. intercept (ServletConfigInterceptor. java: 164)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. AliasInterceptor. intercept (AliasInterceptor. java: 179)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At com. opensymphony. xwork2.interceptor. ExceptionMappingInterceptor. intercept (ExceptionMappingInterceptor. java: 176)
At com. opensymphony. xwork2.defaactionactioninvocation. invoke (defaactionactioninvocation. java: 237)
At org.apache.struts2.impl.StrutsActionProxy.exe cute (StrutsActionProxy. java: 52)
At org. apache. struts2.dispatcher. Dispatcher. serviceAction (Dispatcher. java: 488)
At org.apache.struts2.dispatcher.ng.ExecuteOperations.exe cuteAction (ExecuteOperations. java: 77)
At org. apache. struts2.dispatcher. ng. filter. StrutsExecuteFilter. doFilter (StrutsExecuteFilter. java: 88)
At org. mortbay. jetty. servlet. ServletHandler $ CachedChain. doFilter (ServletHandler. java: 1157)
At org. apache. struts2.dispatcher. ng. filter. StrutsPrepareFilter. doFilter (StrutsPrepareFilter. java: 82)
At org. mortbay. jetty. servlet. ServletHandler $ CachedChain. doFilter (ServletHandler. java: 1157)
At com. wondertek. meeting. filter. AuthorizationFilter. doFilter (AuthorizationFilter. java: 59)
At org. mortbay. jetty. servlet. ServletHandler $ CachedChain. doFilter (ServletHandler. java: 1157)
At org. springframework. web. filter. CharacterEncodingFilter. doFilterInternal (CharacterEncodingFilter. java: 88)
At org. springframework. web. filter. OncePerRequestFilter. doFilter (OncePerRequestFilter. java: 76)
At org. mortbay. jetty. servlet. ServletHandler $ CachedChain. doFilter (ServletHandler. java: 1157)
At org. mortbay. jetty. servlet. ServletHandler. handle (ServletHandler. java: 388)
At org. mortbay. jetty. security. SecurityHandler. handle (SecurityHandler. java: 216)
At org. mortbay. jetty. servlet. SessionHandler. handle (SessionHandler. java: 182)
At org. mortbay. jetty. handler. ContextHandler. handle (ContextHandler. java: 765)
At org. mortbay. jetty. webapp. WebAppContext. handle (WebAppContext. java: 418)
At org. mortbay. jetty. handler. ContextHandlerCollection. handle (ContextHandlerCollection. java: 230)
At org. mortbay. jetty. handler. HandlerCollection. handle (HandlerCollection. java: 114)
At org. mortbay. jetty. handler. HandlerWrapper. handle (HandlerWrapper. java: 152)
At org. mortbay. jetty. Server. handle (Server. java: 326)
At org. mortbay. jetty. HttpConnection. handleRequest (HTTP connection. java: 536)
At org. mortbay. jetty. httpconnections $ RequestHandler. content (HttpConnection. java: 930)
At org. mortbay. jetty. HttpParser. parseNext (HttpParser. java: 747)
At org. mortbay. jetty. HttpParser. parseAvailable (HttpParser. java: 218)
At org. mortbay. jetty. HttpConnection. handle (HttpConnection. java: 405)
At org. mortbay. io. nio. SelectChannelEndPoint. run (SelectChannelEndPoint. java: 409)
At org. mortbay. thread. QueuedThreadPool $ PoolThread. run (QueuedThreadPool. java: 582)
Caused by: java. SQL. SQLException: Field 'id' doesn' t have a default value
At com. mysql. jdbc. SQLError. createSQLException (SQLError. java: 1055)
At com. mysql. jdbc. SQLError. createSQLException (SQLError. java: 956)
At com. mysql. jdbc. MysqlIO. checkErrorPacket (MysqlIO. java: 3558)
At com. mysql. jdbc. MysqlIO. checkErrorPacket (MysqlIO. java: 3490)
At com. mysql. jdbc. MysqlIO. sendCommand (MysqlIO. java: 1959)
At com. mysql. jdbc. MysqlIO. sqlQueryDirect (MysqlIO. java: 2109)
At com.mysql.jdbc.ConnectionImpl.exe cSQL (ConnectionImpl. java: 2643)
At com.mysql.jdbc.PreparedStatement.exe cuteInternal (PreparedStatement. java: 2077)
At com.mysql.jdbc.PreparedStatement.exe cuteUpdate (PreparedStatement. java: 2362)
At com.mysql.jdbc.PreparedStatement.exe cuteUpdate (PreparedStatement. java: 2280)
At com.mysql.jdbc.PreparedStatement.exe cuteUpdate (PreparedStatement. java: 2265)
At com.mchange.v2.c31_impl.newproxypreparedstatement.exe cuteUpdate (NewProxyPreparedStatement. java: 105)
At org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.exe cuteAndExtract (IdentityGenerator. java: 94)
At org. hibernate. id. insert. AbstractReturningDelegate. abstrminsert (AbstractReturningDelegate. java: 57)
At org. hibernate. persister. entity. AbstractEntityPersister. insert (AbstractEntityPersister. java: 2176)
At org. hibernate. persister. entity. AbstractEntityPersister. insert (AbstractEntityPersister. java: 2649)
At org.hibernate.action.EntityIdentityInsertAction.exe cute (EntityIdentityInsertAction. java: 71)
At org.hibernate.engine.ActionQueue.exe cute (ActionQueue. java: 279)
At org. hibernate. event. def. AbstractSaveEventListener. descrimsaveorreplicate (AbstractSaveEventListener. java: 321)
At org. hibernate. event. def. AbstractSaveEventListener. abstrmsave (AbstractSaveEventListener. java: 204)
At org. hibernate. event. def. AbstractSaveEventListener. saveWithGeneratedId (AbstractSaveEventListener. java: 130)
At org. hibernate. event. def. DefaultSaveOrUpdateEventListener. saveWithGeneratedOrRequestedId (DefaultSaveOrUpdateEventListener. java: 210)
At org. hibernate. event. def. DefaultSaveOrUpdateEventListener. entityIsTransient (DefaultSaveOrUpdateEventListener. java: 195)
At org. hibernate. event. def. DefaultSaveOrUpdateEventListener. performSaveOrUpdate (DefaultSaveOrUpdateEventListener. java: 117)
At org. hibernate. event. def. DefaultSaveOrUpdateEventListener. onSaveOrUpdate (DefaultSaveOrUpdateEventListener. java: 93)
At org. hibernate. impl. SessionImpl. fireSaveOrUpdate (SessionImpl. java: 535)
At org. hibernate. impl. SessionImpl. saveOrUpdate (SessionImpl. java: 527)
At org. hibernate. impl. SessionImpl. saveOrUpdate (SessionImpl. java: 523)
At org. springframework. orm. hibernate3.HibernateTemplate $16. doInHibernate (HibernateTemplate. java: 740)
At org. springframework. orm. hibernate3.HibernateTemplate. doExecute (HibernateTemplate. java: 406)
From course De learning bitsCN.com
