首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > J2EE开发 >

java ssh 保存数据有关问题? 急 待.

2012-01-15 
java ssh 保存数据问题? 急 在线等待....今天写了一个保存数据的方法(注册)报错提示为:Java code[12:47:06

java ssh 保存数据问题? 急 在线等待....
今天写了一个保存数据的方法(注册)报错提示为:

Java code
[12:47:06] ERROR util.JDBCExceptionReporter "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法将 NULL 值插入列 'USER_CD',表 'cattle.dbo.UserInfo';该列不允许空值。INSERT 失败。"[12:47:06] ERROR util.JDBCExceptionReporter "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]语句已终止。"2011-11-4 12:47:06 org.apache.catalina.core.StandardWrapperValve invoke严重: Servlet.service() for servlet action threw exceptionjava.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]无法将 NULL 值插入列 'USER_CD',表 'cattle.dbo.UserInfo';该列不允许空值。INSERT 失败。    at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)    at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)    at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)    at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)    at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)    at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)    at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)    at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)    at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)    at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)    at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)    at org.hibernate.id.IdentityGenerator$InsertSelectDelegate.executeAndExtract(IdentityGenerator.java:108)    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)    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 org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:625)    at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)    at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:622)    at com.commcon.daoImpl.IJDBCDaoImpl.create(IJDBCDaoImpl.java:236)    at com.cattle.daoImpl.UserInfoDaoIMPL_ss.saveUser(UserInfoDaoIMPL_ss.java:24)    at com.cattle.serice.UserInfoService_ss.saveUser(UserInfoService_ss.java:37)    at com.cattle.struts.action.UserInfoAction.register(UserInfoAction.java:152)    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.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)    at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)    at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)    at com.commcon.Filter.FilterEncode.doFilter(FilterEncode.java:42)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)    at java.lang.Thread.run(Unknown Source) 


走断点也走了报错的字段确实有值 就是差不进去
 

[解决办法]
报错不是说你的USER_CD字段插入NULL了。。。

user.setUserCd(Integer.parseInt(userCd));
这里如果你的userCd确实有值的话,,那你看你hibernate的映射文件中。配置的属性和列的配置是否正确。。如表的列名是否正确。。。


[解决办法]
配置文件中。。你的USER_CD字段配置了自增的。。。那你的实体中UserCd属性应该不设置值了。。
[解决办法]
<generator class="identity" />是对的,save的那个对象,主键设置null进去就行。
此外建表的时候,要 id int identity(1,1) primary key,

热点排行