Data truncation: Data too long for column 'contents_o' at row 1 报错原因

最新推荐文章于 2023-11-12 13:34:03 发布
最新推荐文章于 2023-11-12 13:34:03 发布
阅读量1.9k 收藏
点赞数
分类专栏： javaWeb开发遇到的困难 文章标签： spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sinat_33536912/article/details/52037089
版权

Struts Problem Report

Stacktraces

org.springframework.dao.DataIntegrityViolationException: could not insert: [com.pb.entity.Alarm]; SQL [insert into ALARM (ALARM_STCD, ALARM_ID, CLASS_ID_O, TEXT_O, DATE_O, JUMP_IP_O, CONTENTS_O, ISSUE_P_O, TYPE_NM_O, TYPE_ID_O, ISSUE_CO_O, CLASS_NM_O, ISSUE_CT_O, CLASS_ID_T, TEXT_T, DATE_T, JUMP_IP_T, CONTENTS_T, ISSUE_P_T, TYPE_NM_T, TYPE_ID_T, ISSUE_CO_T, CLASS_NM_T, ISSUE_CT_T) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.pb.entity.Alarm] 
    org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648)
    org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
    org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:683)
    com.pb.dao.impl.AlarmDaoImpl.save(AlarmDaoImpl.java:13)
    com.pb.dao.impl.AlarmDaoImpl.save(AlarmDaoImpl.java:1)
    com.pb.service.impl.AlarmServiceImpl.save(AlarmServiceImpl.java:33)
    com.pb.service.impl.AlarmServiceImpl.save(AlarmServiceImpl.java:1)
    com.pb.action.DataAction.data(DataAction.java:298)
    sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450)
    com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)
    org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:167)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
    org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:239)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
    com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:161)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:563)
    org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
    org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
    org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
    org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
    org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
    org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
    org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
    org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
    org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    java.lang.Thread.run(Unknown Source)
org.hibernate.exception.DataException: could not insert: [com.pb.entity.Alarm] 
    org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
    org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
    org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2327)
    org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2834)
    org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)

一般包这样的错误有一下几个原因：
      1.可能是因为数据库里的表设置的字符集不相同。
      2.在同一个数据库中，存在utf8的表，也存在gbk_chinese_ci的表。
      解决办法：alter table `cms_activity_test` convert to character set gbk collate gbk_chinese_ci;(单独修改指定表的字符集)
      补充：通过在网上查找资料，一般都是修改数据库Mysql的默认字符集和修改单个数据库的字符集
     
      
（1）。 在Mysql数据库目录下找到my.ini文件,然后Ctrl+F查找character-set,修改

   
   

    
    
[client]
port=3306
[mysql]
default-character-set=utf8

    
    

     
     

    
    

   
   
（2）. 修改单个数据库字符集,data目录下找到db.opt文件,然后修改

   
   

    
    
default-character-set=gbk
default-collation=gbk_chinese_ci



   
   
（3）. 用命令设置

   
   

    
    
mysql> SET character_set_client = utf8 ;
mysql> SET character_set_connection = utf8 ;
mysql> SET character_set_database = utf8 ;
mysql> SET character_set_results = utf8 ;
mysql> SET character_set_server = utf8 ;
mysql> SET collation_connection = utf8 ;
mysql> SET collation_database = utf8 ;
mysql> SET collation_server = utf8 ;

   
   
 （4）. 如果还嫌太麻烦了，就用一个蠢办法，如果整个数据库表不多且数据量不大的情况下，就将整个库导出，然后再去修改文件中字符集不一的表，最后再导入数据库。。。

      3.也可能真是数据库字段里数据库确实过长(我是遇到的这种情况)。我也遇到过此类情况
      4.还有可能是在设定数据库时，设定的某一些字段的大小的问题，如果过小也是这个为题。

 

Struts has detected an unhandled exception:

Messages:
  1. Data truncation: Data too long for column 'contents_o' at row 1
  2. could not insert: [com.pb.entity.Alarm]
  3. could not insert: [com.pb.entity.Alarm]; SQL [insert into ALARM (ALARM_STCD, ALARM_ID, CLASS_ID_O, TEXT_O, DATE_O, JUMP_IP_O, CONTENTS_O, ISSUE_P_O, TYPE_NM_O, TYPE_ID_O, ISSUE_CO_O, CLASS_NM_O, ISSUE_CT_O, CLASS_ID_T, TEXT_T, DATE_T, JUMP_IP_T, CONTENTS_T, ISSUE_P_T, TYPE_NM_T, TYPE_ID_T, ISSUE_CO_T, CLASS_NM_T, ISSUE_CT_T) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [com.pb.entity.Alarm]
File:com/mysql/jdbc/MysqlIO.java
Line number:3,607
猪猪侠大战奥特曼
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
SQL*Loader Messages 报错
luobotoutou123的博客
11-12 3964
SQL*Loader Messages This chapter lists messages you might see when using SQL*Loader. SQL*Loader messages take the form: SQL*Loader-code number: message text Along with its own messages, SQL*Loader sometimes displays related messages issued by the
sql server 缓存_深入了解SQL Server缓冲区缓存
culuo4781的博客
07-18 3291
sql server 缓存 When we talk about memory usage in SQL Server, we are often referring to the buffer cache. This is an important part of SQL Server’s architecture, and is responsible for the ability ...
MySql的Blob字段报错：Data truncation: Data too long for column 'CONTENT' at row 1
热门推荐
linshenshijianlu的博客
08-29 4万+
总结来说， Data truncation: Data too long for column 'CONTENT' at row 1问题的出现主要是以下几个原因：          1、可能 数据库中的字符集的编码与写代码的页面的编码不相符合；（一般为utf-8）          2、可能数据库字段的长度太小，不满足要求；（有时可能默认的为零，自己没有注意到，要好好检查一下）      
Data truncation: Data too long for column ‘content‘ at row 1（存大数据进数据库时报错）
diaolove的博客
12-18 4581
项目场景： 问题描述： 数据超出长度，是Mysql根据配置文件限制Server接受数据包大小,有时候大的插入和更新会受max_allowed_packet参数限制，导致写入或者更新失败。 原因分析： 你数据多与你选用的存储类型不符合 解决方案： 把varchar改为 longtext 然后就可写入成功了！ 总结：每次遇到问题解决了都不总结，印象不深，实在难搞，做个笔记记一记下次也不会太乱！ ...
java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
ZKLxuankai的专栏
06-28 9822
-----------------------------------------------------------     mysql5.0+myeclipse4.1+tomcat5.0   全部使用默认编码方式     1：插如数据到mysql中：           在页面上加入本页的编码方式                     把你要插入的中文文字由gb2312
Mysql提示插入数据提示Data truncation: Data too long for column 'content' at row 1
惚如远行客的博客
09-08 4139
如果varchar小于255，则将字段长度设置长一下 如果是设置成了255还是报错，则去mysql配置文件里 设置default-character-set=gbk 之后重启mysql服务即可解决
mysql 数据库 错误 Data truncation: Data too long for column 'name' at row 1
hanmartin的专栏
04-03 3178
Data truncation: Data too long for column 'name' at row 1      网上有很多对这类问题的解决方法。只是说我的经历的总结。这类问题也不能算是什么大的问题，但是有时候重装了Mysql数据库以后，编码没有注意用到中文。。没有什么可视化的工具 创建的一些表会出现这样的问题：英文插入到表中没有任何问题。但是插入中文的时候就出现 Data
12C ORA 错误汇总18 ORA 57000 to ORA 65535 EXP 00000 to EXP 00114
ugghhj的博客
11-07 2442
12C ORA 错误汇总18 ORA 57000 to ORA 65535 EXP 00000 to EXP 00114
MySql jdbc 连接参数
java12345678
12-22 2598
  jdbc:mysql://192.168.1.25:3306/test?useUnicode=true&amp;characterEncoding=UTF-8    见官网： http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html 5.1 Dr...
CVPR2017论文摘要汇总
super_chicken的博客
04-09 1万+
1. Exclusivity-Consistency Regularized Multi-view Subspace Clustering Abstract: Multi-view subspace clustering aims to partition a set of multi-source data into their underlying groups. To boost the ...
Data truncation: Data too long for column ‘xxx‘ at row 1
酷酷的馫博客
07-25 3929
Data truncation: Data too long for column 'xxx' at row 1;
org.springframework.dao.DataIntegrityViolationException: could not insert: [com.front.model.user.Use
JEFFYU328的专栏
07-19 1万+
1、org.springframework.dao.DataIntegrityViolationException: could not insert: [com.front.model.user.User]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert:
org.springframework.dao.DataIntegrityViolationException: could not insert:
feiyan19880116的专栏
07-10 213
org.springframework.dao.DataIntegrityViolationException: could not insert: [com.kuandai.t4.pojo.TroubleInfo]; nested exception is org.hibernate.exception.ConstraintViolationException: could not ...
org.springframework.dao.DataIntegrityViolationException
a_tzluy的博客
01-18 215
去掉实体类上面对应数据库字段的注解，并在类上面加上这两个注解 @AllArgsConstructor @NoArgsConstructor
org.springframework.dao.DataIntegrityViolationException: could not execute statement； SQL [n/a]； con
最新发布
m0_48271910的博客
11-12 1947
报错：org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; con 错误提示：Duplicate entry '8' for key 'category_type' 解决方法：我数据库中设置了该字段是只能为唯一值的，而我数据库该表已有该字段为8的数据存在，导致数据添加失败，只需将该字段数据改成其他还未使用的值再重新添加运行程序即可
org.springframework.dao.DataIntegrityViolationException Could not execute JDBC batch update
再小的项目也有它的亮点
12-04 4636
org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into weixin_user_infomation (subscribe, openid, nickname, sex, city, country, province, language, headimgurl, subscribe_time, user_id) values (?, ?, ?
解决data too long for column 'name' at row 1
ddfo79355的博客
04-30 2243
最先试一试最简单的测试方式就是先修改my.ini文件中的-default-character-set = gb2312或utf8，重启mysql再输入数据,如果不行，再考虑以下办法。 在程序中写了一段代码向数据库中插入数据，出现了data too long for column 'name' at row 1的问题。在google搜了一下解决方法，真是五花八门，也逐一试了一遍，终...
Data too long for column ‘表名’ at row 1的若干解决方案（mysql编码转换的问题、中文乱码）
adi_1987的博客
12-05 5459
有经常使用表单进行传递字符串到数据库的经验的朋友可能会遇到这样一个问题：数据库获取到前台页面显示都是正常的（不是乱码），但是当使用表单传递值到执行页面插入到数据库的时候会出现无法插入，一般有如下提示：Data too long for column ‘表名’ at row 1 的提示，或者成功插入，但是显示出来中文是乱码。如果出现以上情况，，可以使用以下方法： 1、在连接数据库的代码处加上m
Data truncation: Data too long for column pk_value at row 17
08-24
- *1* [【mysql报错】Data truncation: Data too long for column ‘XXX‘ at row 1](https://blog.csdn.net/ranran0224/article/details/127571063)[target="_blank" data-report-click={"spm":"1018.2226.3001....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值