hibernate
bitscn.com 问题的原因很简单,可能有的时候一下想不起来。mark下。
报错信息如下:
org.springframework.jdbc.uncategorizedsqlexception: hibernate operation: could 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.executewithnativesession(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.defaultactioninvocation.invokeaction(defaultactioninvocation.java:441)
at com.opensymphony.xwork2.defaultactioninvocation.invokeactiononly(defaultactioninvocation.java:280)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:243)
at com.wondertek.meeting.interceptor.analyticsinterceptor.intercept(analyticsinterceptor.java:92)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.defaultworkflowinterceptor.dointercept(defaultworkflowinterceptor.java:165)
at com.opensymphony.xwork2.interceptor.methodfilterinterceptor.intercept(methodfilterinterceptor.java:87)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.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.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.conversionerrorinterceptor.intercept(conversionerrorinterceptor.java:122)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.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.defaultactioninvocation.invoke(defaultactioninvocation.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.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.staticparametersinterceptor.intercept(staticparametersinterceptor.java:179)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.interceptor.multiselectinterceptor.intercept(multiselectinterceptor.java:75)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.interceptor.checkboxinterceptor.intercept(checkboxinterceptor.java:94)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.interceptor.fileuploadinterceptor.intercept(fileuploadinterceptor.java:235)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.modeldriveninterceptor.intercept(modeldriveninterceptor.java:89)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.scopedmodeldriveninterceptor.intercept(scopedmodeldriveninterceptor.java:130)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.interceptor.debugging.debugginginterceptor.intercept(debugginginterceptor.java:267)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.chaininginterceptor.intercept(chaininginterceptor.java:126)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.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.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.i18ninterceptor.intercept(i18ninterceptor.java:165)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.interceptor.servletconfiginterceptor.intercept(servletconfiginterceptor.java:164)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.aliasinterceptor.intercept(aliasinterceptor.java:179)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at com.opensymphony.xwork2.interceptor.exceptionmappinginterceptor.intercept(exceptionmappinginterceptor.java:176)
at com.opensymphony.xwork2.defaultactioninvocation.invoke(defaultactioninvocation.java:237)
at org.apache.struts2.impl.strutsactionproxy.execute(strutsactionproxy.java:52)
at org.apache.struts2.dispatcher.dispatcher.serviceaction(dispatcher.java:488)
at org.apache.struts2.dispatcher.ng.executeoperations.executeaction(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(httpconnection.java:536)
at org.mortbay.jetty.httpconnection$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.execsql(connectionimpl.java:2643)
at com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2077)
at com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2362)
at com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2280)
at com.mysql.jdbc.preparedstatement.executeupdate(preparedstatement.java:2265)
at com.mchange.v2.c3p0.impl.newproxypreparedstatement.executeupdate(newproxypreparedstatement.java:105)
at org.hibernate.id.identitygenerator$getgeneratedkeysdelegate.executeandextract(identitygenerator.java:94)
at org.hibernate.id.insert.abstractreturningdelegate.performinsert(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.execute(entityidentityinsertaction.java:71)
at org.hibernate.engine.actionqueue.execute(actionqueue.java:279)
at org.hibernate.event.def.abstractsaveeventlistener.performsaveorreplicate(abstractsaveeventlistener.java:321)
at org.hibernate.event.def.abstractsaveeventlistener.performsave(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)
摘自 菜菜de学习 bitscn.com