Today with the PostMan test registration function at a MySQLIntegrityConstraintViolationException abnormalities, errors in the User Mapper, look at it, can you tell me what's going on?
Org. Springframework. Dao. DataIntegrityViolationException:
# # # Error updating the database. Cause: the mysql. JDBC. Exceptions. Jdbc4. MySQLIntegrityConstraintViolationException: the Column 'id' always be null
# # # The error may exist in The com/alibaba/mapper/UserMapper. Java (best guess)
# # # The error may involve com. Alibaba. Mapper. UserMapper. Register - The Inline
# # # The error occurred while setting The parameters
# # # SQL: insert into user values (?,?,?,?,? ,? ,?)
# # # Cause: com. Mysql. JDBC. Exceptions. Jdbc4. MySQLIntegrityConstraintViolationException: the Column 'id' always be null
; [SQL]; The Column 'id' always be null. Nested exception is com. Mysql. JDBC. Exceptions. Jdbc4. MySQLIntegrityConstraintViolationException: the Column 'id' always be null
; [SQL]; The Column 'id' always be null. Nested exception is com. Mysql. JDBC. Exceptions. Jdbc4. MySQLIntegrityConstraintViolationException: the Column 'id' always be null
The at org. Springframework. JDBC. Support. SQLExceptionSubclassTranslator. DoTranslate (SQLExceptionSubclassTranslator. Java: 85)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 73)
The at org. Springframework. JDBC. Support. AbstractFallbackSQLExceptionTranslator. Translate (AbstractFallbackSQLExceptionTranslator. Java: 82)
The at org. Mybatis. Spring. MyBatisExceptionTranslator. TranslateExceptionIfPossible (MyBatisExceptionTranslator. Java: 88)
The at org. Mybatis. Spring. SqlSessionTemplate $SqlSessionInterceptor. Invoke (SqlSessionTemplate. Java: 440)
At com. Sun. Proxy. $Proxy61. Insert (Unknown Source)
The at org. Mybatis. Spring. SqlSessionTemplate. Insert (271) SqlSessionTemplate. Java:
The at org. Apache. Ibatis. Binding. MapperMethod. Execute (MapperMethod. Java: 62)
The at org. Apache. Ibatis. Binding. MapperProxy $PlainMethodInvoker. Invoke (MapperProxy. Java: 144)
The at org. Apache. Ibatis. Binding. MapperProxy. Invoke (MapperProxy. Java: 85)
At com. Sun. Proxy. $Proxy68. Register (Unknown Source)
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Springframework. Aop. Support. AopUtils. InvokeJoinpointUsingReflection (AopUtils. Java: 333)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. InvokeJoinpoint (ReflectiveMethodInvocation. Java: 190)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 157)
The at org. Springframework. Dao. Support. PersistenceExceptionTranslationInterceptor. Invoke (PersistenceExceptionTranslationInterceptor. Java: 136)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 179)
The at org. Springframework. Aop. Framework. JdkDynamicAopProxy. Invoke (JdkDynamicAopProxy. Java: 213)
At com. Sun. Proxy. $Proxy70. Register (Unknown Source)
At com. Alibaba. Service. UserService. Register (UserService. Java: 25)
At com. Alibaba. Service. $$$$bb559e12 FastClassBySpringCGLIB UserService. Invoke (& lt; Generated>)
The at org. Springframework. Additional. Proxy. MethodProxy. Invoke (MethodProxy. Java: 204)
The at org. Springframework. Aop. Framework. CglibAopProxy $CglibMethodInvocation. InvokeJoinpoint (CglibAopProxy. Java: 738)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 157)
The at org. Springframework. Transaction. The interceptor. TransactionInterceptor $1. ProceedWithInvocation (TransactionInterceptor. Java: 99)
The at org. Springframework. Transaction. The interceptor. TransactionAspectSupport. InvokeWithinTransaction (TransactionAspectSupport. Java: 282)
The at org. Springframework. Transaction. The interceptor. TransactionInterceptor. Invoke (TransactionInterceptor. Java: 96)
The at org. Springframework. Aop. Framework. ReflectiveMethodInvocation. Proceed (ReflectiveMethodInvocation. Java: 179)
The at org. Springframework. Aop. Framework. CglibAopProxy $DynamicAdvisedInterceptor. Intercept (CglibAopProxy. Java: 673)
At com. Alibaba. Service. UserService $$EnhancerBySpringCGLIB $$73 c6ca6d. Register (& lt; Generated>)
At com. Alibaba. Controller. UserController. Register (20) UserController. Java:
At sun. Reflect. NativeMethodAccessorImpl. Invoke0 (Native Method)
At sun. Reflect. NativeMethodAccessorImpl. Invoke (NativeMethodAccessorImpl. Java: 62)
At sun. Reflect. DelegatingMethodAccessorImpl. Invoke (43) DelegatingMethodAccessorImpl. Java:
The at Java. Lang. Reflect. Method. Invoke (498) Method. The Java:
The at org. Springframework. Web. Method. Support. InvocableHandlerMethod. DoInvoke (InvocableHandlerMethod. Java: 205)
The at org. Springframework. Web. Method. Support. InvocableHandlerMethod. InvokeForRequest (InvocableHandlerMethod. Java: 133)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull