無法將 NULL 值插入列 ‘keyid’

insert into systemmailnotify (subject,mailid,mailfrom,mailto,status) values('1341',32,'admin@way.com','test@way.com',0)<br />com.microsoft.sqlserver.jdbc.SQLServerException: 無法將 NULL 值插入列 'keyid'，表 'wayoa.dbo.SystemMailNotify'；該列不允許空值。INSERT 失敗。<br />at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteUpdate(Unknown Source)<br />at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)<br />at org.apache.jsp.admin.mail.send_005fdb_jsp._jspService(send_005fdb_jsp.java:448)<br />at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:390)<br />at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)<br />at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)<br />at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)<br />at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br />at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)<br />at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<br />at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<br />at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<br />at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br />at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212)<br />at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:866)<br />at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:716)<br />at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1498)<br />at java.lang.Thread.run(Thread.java:619)

 

 

 

 解決方案：

   設定主鍵為“標識”自動成長就可以了。