Field 'userID' doesn't have a default value问题

最新推荐文章于 2025-11-03 16:07:56 发布
转载 最新推荐文章于 2025-11-03 16:07:56 发布 · 8k 阅读 · 3
文章标签：

#数据库连接问题处理

本文解决在使用Hibernate框架向MySQL数据库插入数据时遇到的Field 'userID' doesn't have a default value异常，通过调整数据库表结构和Hibernate配置实现。 
				版权声明：欢迎转载，若转载请给出本文链接					https://blog.youkuaiyun.com/niaonao/article/details/78112792				</div>
							            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-d7e2a68c7c.css">
					<div class="htmledit_views" id="content_views">

字段需要设置一个默认值

Caused by: java.sql.SQLException: Field 'userID' doesn't have a default value


一、新增记录出现异常

1.问题的出现，我在新增一个用户信息时，报的错误，不能添加记录到数据库；



2.详细异常信息

Hibernate: insert into t_user (uname, userAddress, userBirth, userEmail, userGender, userName, userPassword, userPhone) values (?, ?, ?, ?, ?, ?, ?, ?)
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [biz.entity.main.User]; uncategorized SQLException for SQL [insert into t_user (uname, userAddress, userBirth, userEmail, userGender, userName, userPassword, userPhone) values (?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1364]; Field 'userID' doesn't have a default value; nested exception is java.sql.SQLException: Field 'userID' 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.save(HibernateTemplate.java:683)
	at common.dao.hibernate.BaseHibernateDao.save(BaseHibernateDao.java:57)
	at biz.web.service.impl.BizService.addSimpleUser(BizService.java:44)
	at biz.web.action.sys.SimpleUserAction.add(SimpleUserAction.java:80)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:446)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:285)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:238)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:238)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:325)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:544)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at common.filter.SessionFilter.doFilter(SessionFilter.java:69)
	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:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:744)
Caused by: java.sql.SQLException: Field 'userID' doesn't have a default value
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:139)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:93)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:56)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2346)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2853)
	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
	at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:686)
	at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:1)
	at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	... 73 more

二、异常信息分析

1.insert语句执行失败

    异常显示就是insert插入sql语句执行错误导致添加记录到数据库失败；

    根本原因就是Field 'userID' doesn't have a default value；

    字段userID没有设置默认值；

    下面该表的create语句中确实没有给userID设置默认值；


 
  1. 
   
    
    
    
   
    
   
    
    
    
     CREATE 
     TABLE 
     `t_user` (
    
    
   
  2. 
   
    
    
    
   
    
   
    
    
      
     `userID` 
     int(
     11) 
     NOT 
     NULL,
    
    
   
  3. 
   
    
    
    
   
    
   
    
    
      
     `uname` 
     varchar(
     20) 
     default 
     NULL,
    
    
   
  4. 
   
    
    
    
   
    
   
    
    
      
     `userAddress` 
     varchar(
     100) 
     default 
     NULL,
    
    
   
  5. 
   
    
    
    
   
    
   
    
    
      
     `userBirth` 
     varchar(
     10) 
     default 
     NULL,
    
    
   
  6. 
   
    
    
    
   
    
   
    
    
      
     `userEmail` 
     varchar(
     50) 
     default 
     NULL,
    
    
   
  7. 
   
    
    
    
   
    
   
    
    
      
     `userGender` 
     int(
     11) 
     default 
     NULL,
    
    
   
  8. 
   
    
    
    
   
    
   
    
    
      
     `userName` 
     varchar(
     20) 
     default 
     NULL,
    
    
   
  9. 
   
    
    
    
   
    
   
    
    
      
     `userPassword` 
     varchar(
     150) 
     default 
     NULL,
    
    
   
  10. 
   
    
    
    
   
    
   
    
    
      
     `userPhone` 
     varchar(
     255) 
     default 
     NULL,
    
    
   
  11. 
   
    
    
    
   
    
   
    
    
    
       PRIMARY 
     KEY  (
     `userID`)
    
    
   
  12. 
   
    
    
    
   
    
   
    
    
    
     );

    导致insert语句对应的userID字段没有插入数据，而该字段不允许为null导致的；

Hibernate: insert into t_user (uname, userAddress, userBirth, userEmail, userGender, userName, userPassword, userPhone) values (?, ?, ?, ?, ?, ?, ?, ?)

三、解决异常

3-1.给字段设置默认值

    这种问题简单的解决办法就是设置默认值,但是当前字段userID是主键不能设置默认值；

`userAddress` varchar(100) default '阿拉加斯加'

3-2.Hibernate配置检查

    那可能是Hibernate配置出现了问题；然后找到当前表对应的Entity实体类

    字段userID的配置


 
  1. 
   
    
    
    
   
    
   
    
    
    	
     @Id
    
    
   
  2. 
   
    
    
    
   
    
   
    
    
    	
     @GeneratedValue(strategy = IDENTITY)
    
    
   
  3. 
   
    
    
    
   
    
   
    
    
    	
     @Column(name = 
     "userID", unique = 
     true, nullable = 
     false)
    
    
   
  4. 
   
    
    
    
   
    
   
    
    
    	
     public Integer getUserId() {
    
    
   
  5. 
   
    
    
    
   
    
   
    
    
    		
     return 
     this.userId;
    
    
   
  6. 
   
    
    
    
   
    
   
    
    
    
     	}
    该字段设置了自增策略，指定不可为空，且是唯一的；
    感觉没啥问题；再次测试新增一条记录还是失败；

3-3.数据库中表t_user的修改

    然后就从数据表这里入手；

    将当t_user的userID修改为自增

alter table t_user modify userID int auto_increment;
    因为该字段有外键约束不允许修改；

    索性就把表删了；新建表t_user；直接在设置字段自增且不为空；然后新增一条记录成功了；


 
  1. 
   
    
    
    
   
    
   
    
    
    
     CREATE 
     TABLE 
     `t_user` (
    
    
   
  2. 
   
    
    
    
   
    
   
    
    
      
     `userID` 
     int(
     11) 
     NOT 
     NULL auto_increment,
    
    
   
  3. 
   
    
    
    
   
    
   
    
    
      
     `uname` 
     varchar(
     20) 
     default 
     NULL,
    
    
   
  4. 
   
    
    
    
   
    
   
    
    
      
     `userAddress` 
     varchar(
     100) 
     default 
     NULL,
    
    
   
  5. 
   
    
    
    
   
    
   
    
    
      
     `userBirth` 
     varchar(
     10) 
     default 
     NULL,
    
    
   
  6. 
   
    
    
    
   
    
   
    
    
      
     `userEmail` 
     varchar(
     50) 
     default 
     NULL,
    
    
   
  7. 
   
    
    
    
   
    
   
    
    
      
     `userGender` 
     int(
     11) 
     default 
     NULL,
    
    
   
  8. 
   
    
    
    
   
    
   
    
    
      
     `userName` 
     varchar(
     20) 
     default 
     NULL,
    
    
   
  9. 
   
    
    
    
   
    
   
    
    
      
     `userPassword` 
     varchar(
     150) 
     default 
     NULL,
    
    
   
  10. 
   
    
    
    
   
    
   
    
    
      
     `userPhone` 
     varchar(
     255) 
     default 
     NULL,
    
    
   
  11. 
   
    
    
    
   
    
   
    
    
    
       PRIMARY 
     KEY  (
     `userID`)
    
    
   
  12. 
   
    
    
    
   
    
   
    
    
    
     );


四、其他解决方法

1.修改mysql配置

    打开my.ini，查找sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"修改为sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"然后重启MYSQL

2.

    设置默认值即可，当然这个字段不是主键的情况下；

3.

    MySQL 5 uses a strict mode which needs to be disabled. In Windows, Goto Start-->Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens. At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart.

出现 Cause: java.sql.SQLException: Field ‘id‘ doesn‘t have a default value解决方法
码农研究僧的博客
01-02 2110
通过bug提示，在插入两个值的时候，另外一个值由于没有设置默认值，导致无法插入。检查自身的entity类中，具体id的属性是否有所设置：（比如类型是否正确）在数据库的设计表中，如果id是主键，必须设置为自增值！对此策略，我们应该设置一个默认值或者是自增值。配置完成之后，一定要重启项目。
出现Field ‘id‘ doesn‘t have a default value； nested exception is java.sql.SQLException的解决方法
码农研究僧的博客
11-18 9701
出现这个指示错误 org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: java.sql.SQLException: Field 'id' doesn't have a default value ### The error may involve com.wkcto.plus.mapper.UserMapper.insert-Inline ### The error o
Mysql疑难报错排查 - Field ‘XXX‘ doesn‘t have a default value
2509_94083731的博客
11-03 369
既然说的是没有默认值，那我们就在插入的时候指定传null 进去即可，由于MyBatisPlus的特性，所以最终在DBclass层，为end_time1和end_time2都设置为null 也插入和更新。某一个插入语句使用了 MyBatisPlus 的 save 方法，因为end_time1 end_time2都并没有值，所以在MyBatisPlus默认情况下，并不会在插入语句中提及，一般情况下，这种报错是表设置成非空字段，我们又没设置默认值导致的。但是这里我们明明表中设置了可空。修复后没有再次报错。
Mysql出现问题：ERROR 1364(HY000 (ER_NO_DEFAULT_FOR_FIELD)): Field ‘%s‘ doesn‘t have a default value解决方案
小虚竹的专栏
04-04 2976
Mysql出现问题：ERROR 1364(HY000 (ER_NO_DEFAULT_FOR_FIELD)): Field ‘%s‘ doesn‘t have a default value解决方案
java.sql.SQLException Field ‘user_id‘ doesn‘t have a default value
m0_74055560的博客
03-23 689
参考：https://blog.youkuaiyun.com/qq_38974638/article/details/120002074?1、数据库表字段userId设置了不能为null，但写入数据时userId的值为null，导致报错。（1）写数据不变，数据库表字段username设置为允许为null。（2）数据库表字段不变，写数据是username的值不为null。name的值不为null。
Field ‘userID‘ doesn‘t have a default value
热门推荐
niaonao
09-27 8万+
Caused by: java.sql.SQLException: Field 'userID' doesn't have a default value 字段需要设置一个默认值
数据库操作出错: Field 'user_id' doesn't have a default value
最新发布
12-13
### 回答问题：`Field 'user_id' doesn't have a default value` 错误原因及解决方法 这个错误： ``` Field 'user_id' doesn't have a default value ``` 是 **MySQL 数据库**在执行 `INSERT` 操作时抛出的常见...
Cause: java.sql.SQLException: Field 'user_id' doesn't have a default value ; Field 'user_id' doesn't have a default value; nested exception is java.sql.SQLException: Field 'user_id' doesn't have a default value] with root cause
04-25
嗯，用户遇到了一个SQL异常：java.sql.SQLException: Field 'user_id' doesn't have a default value。我需要帮他找出原因和解决办法。首先，这个错误通常发生在插入数据时，某个字段没有默认值，同时插入语句又没有...
设置主键时报错1364 - Field 'id' doesn't have a default value
05-13
好的，我现在需要解决用户在设置主键时遇到的MySQL错误1364：“Field 'id' doesn't have a default value”。用户已经参考了之前的解决方案，但似乎遇到了外键约束的问题，导致无法直接修改字段为自增。我需要结合...
操作失败: Error: Field 'title' doesn't have a default value
03-23
好的，我现在需要处理用户的问题：“操作失败: Error: Field 'title' doesn't have a default value”。用户之前提供的代码中，在优化后的版本里可能出现了这个错误。我需要分析这个错误的原因，并提供解决方案。 ...
mybatisplus设置了id自增，还报错Field 'id' doesn't have a default value
08-07
当MyBatis-Plus配置了主键自增（`IdType.AUTO`）但插入数据时仍报错 **`Field 'id' doesn't have a default value`**，通常是由于数据库表结构或MyBatis-Plus配置与数据库实际行为不匹配导致的。以下是详细排查和...
数据库报错：Field ‘userid’ doesn’t have a default value Query:
Mrsun233的博客
03-09 1209
java.sql.SQLException: Field ‘userid’ doesn’t have a default value Query: INSERT INTO users(username,password,phonenumber,email) Values (?,?,?,?) Parameters: [qwe, qwe, qwe, qwe] at org.apache.com
Cause: java.sql.SQLException: Field 'user_id' doesn't have a default value
张不帅
03-08 3593
主键没有设置自动递增
Caused by: java.sql.SQLException: Field 'id' doesn't have a default value
weixin_34112208的博客
09-20 247
建表语句： create table t( id int not null primary key, name varchar(20) not null ); 原因: *.hbm.xml文件中的配置<generator class="native" /> 解决办法： 删除*.hbm.xml文件中的<generat...
Field 'id' doesn't have a default value
小鹰信息技术服务部
05-19 9319
今天仿照其他模块在写一个新增通知的功能，可是保存的时候总是b
Field 'id' doesn't have a default value问题解决方法
diandingyin9417的博客
04-27 413
Field 'id' doesn't have a default value问题解决方法 突然想温习温习对数据库的读写。于是就用mysql建了一张单独的表（见代码1），用Hibernate写了个应用，能够正常查询、改动数据了。開始时。数据是在mysql的GUI工具里手工输入的，嫌烦，于是就想到用程序批量生成一些，于是麻烦也跟着来了…… 代码1Sql代码...
laravel 中 1364 Field 'user_id' doesn't have a default value
迷失的鱼的博客
08-10 1804
protected $fillable = ['user_id'];
SSH:Field 'id' doesn't have a default value
奋斗的小鸟
04-21 1283
SSH框架版本struts2.3+hibernate4.3+spring4.0 Field 'id' doesn't have a default value 1>User类 public class User {        private Integer id;        private String username;        private String passw
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值