jfinal异常

最新推荐文章于 2021-07-20 12:37:38 发布

原创最新推荐文章于 2021-07-20 12:37:38 发布 · 4.4k 阅读

0 ·

CC 4.0 BY-SA版权

本文记录了一次在使用JFinal框架进行数据保存操作时遇到的MySQL数据库完整性约束异常，原因是ID字段未被赋值且数据库中该字段未设置为自增。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[ERROR]-[Thread: qtp8918249-21]-[com.jfinal.core.ActionHandler.handle()]: /test/save
com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null
   at com.jfinal.plugin.activerecord.Model.save(Model.java:298)
   at com.demo.test.TestController.save(TestController.java:22)
   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.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:55)
   at com.jfinal.validate.Validator.intercept(Validator.java:60)
   at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51)
   at com.demo.test.TestInterceptor.intercept(TestInterceptor.java:13)
   at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51)
   at com.jfinal.core.ActionHandler.handle(ActionHandler.java:73)
   at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1072)
   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
   at org.eclipse.jetty.server.Server.handle(Server.java:365)
   at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
   at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
   at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
   at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
   at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
   at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
   at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
   at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
   at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
   at java.lang.Thread.run(Thread.java:619)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'id' cannot be null

是由于id没有赋值，并且数据库中该字段也没设置成自增，从而出现异常