1. 全栈程序员必看首页

string或binary数据将被截断_字符串截断错误

全栈程序员-站长 • • 未分类 • 阅读 0

string或binary数据将被截断_字符串截断错误Hibernate:insertintodis_txtfile(delivery,postationid,sn,id)values(?,?,?,?)2012-02-2111:28:53,481[main]WARN org.hibernate.util.JDBCExceptionReporter-SQLError:0,SQLState:220012

大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。

Jetbrains全系列IDE稳定放心使用
Hibernate: insert into dis_txtfile (delivery, postationid, sn, id) values (?, ?, ?, ?)

2012-02-21 11:28:53,481 [main] WARN  org.hibernate.util.JDBCExceptionReporter – SQL Error: 0, SQLState: 22001

2012-02-21 11:28:53,481 [main] ERROR org.hibernate.util.JDBCExceptionReporter – Data truncation

2012-02-21 11:28:53,481 [main] WARN  org.hibernate.util.JDBCExceptionReporter – SQL Error: 8152, SQLState: 22001

2012-02-21 11:28:53,481 [main] ERROR org.hibernate.util.JDBCExceptionReporter – 将截断字符串或二进制数据。

2012-02-21 11:28:53,482 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener – Could not synchronize database state with session

org.hibernate.exception.DataException: could not insert: [org.eline.entity.dis.TxtFile]

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)

    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)

    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)

    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)

    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)

    at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)

    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)

    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.endTransaction(TransactionalTestExecutionListener.java:504)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener.endTransaction(TransactionalTestExecutionListener.java:277)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:170)

    at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:344)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runManaged(AbstractJUnit38SpringContextTests.java:325)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.access$000(AbstractJUnit38SpringContextTests.java:94)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests$1.run(AbstractJUnit38SpringContextTests.java:193)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runTest(AbstractJUnit38SpringContextTests.java:270)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runTestTimed(AbstractJUnit38SpringContextTests.java:228)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runBare(AbstractJUnit38SpringContextTests.java:191)

    at junit.framework.TestResult$1.protect(TestResult.java:106)

    at junit.framework.TestResult.runProtected(TestResult.java:124)

    at junit.framework.TestResult.run(TestResult.java:109)

    at junit.framework.TestCase.run(TestCase.java:120)

    at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)

    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Caused by: java.sql.DataTruncation: Data truncation

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)

    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)

    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)

    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)

    … 33 common frames omitted

2012-02-21 11:28:53,491 [main] WARN  org.springframework.test.context.TestContextManager – Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1ded4c9] to process ‘after’ execution for test: method [public void dis.TxtFileManagerTest.testSaveTxtFile() throws java.lang.Exception], instance [testSaveTxtFile(dis.TxtFileManagerTest)], exception [null]

org.springframework.dao.DataIntegrityViolationException: could not insert: [org.eline.entity.dis.TxtFile]; nested exception is org.hibernate.exception.DataException: could not insert: [org.eline.entity.dis.TxtFile]

    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:639)

    at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789)

    at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663)

    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)

    at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener$TransactionContext.endTransaction(TransactionalTestExecutionListener.java:504)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener.endTransaction(TransactionalTestExecutionListener.java:277)

    at org.springframework.test.context.transaction.TransactionalTestExecutionListener.afterTestMethod(TransactionalTestExecutionListener.java:170)

    at org.springframework.test.context.TestContextManager.afterTestMethod(TestContextManager.java:344)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runManaged(AbstractJUnit38SpringContextTests.java:325)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.access$000(AbstractJUnit38SpringContextTests.java:94)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests$1.run(AbstractJUnit38SpringContextTests.java:193)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runTest(AbstractJUnit38SpringContextTests.java:270)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runTestTimed(AbstractJUnit38SpringContextTests.java:228)

    at org.springframework.test.context.junit38.AbstractJUnit38SpringContextTests.runBare(AbstractJUnit38SpringContextTests.java:191)

    at junit.framework.TestResult$1.protect(TestResult.java:106)

    at junit.framework.TestResult.runProtected(TestResult.java:124)

    at junit.framework.TestResult.run(TestResult.java:109)

    at junit.framework.TestCase.run(TestCase.java:120)

    at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)

    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)

    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)

Caused by: org.hibernate.exception.DataException: could not insert: [org.eline.entity.dis.TxtFile]

    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)

    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2272)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)

    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)

    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)

    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)

    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)

    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)

    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)

    at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)

    … 22 common frames omitted

Caused by: java.sql.DataTruncation: Data truncation

    at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)

    at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)

    at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)

    at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)

    at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)

    at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)

    at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)

    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2252)

    … 33 common frames omitted

2012-02-21 11:28:53,498 [Thread-2] INFO  org.springframework.context.support.GenericApplicationContext – Closing org.springframework.context.support.GenericApplicationContext@1d6776d: display name [org.springframework.context.support.GenericApplicationContext@1d6776d]; startup date [Tue Feb 21 11:28:51 CST 2012]; root of context hierarchy

2012-02-21 11:28:53,502 [Thread-2] INFO  org.springframework.beans.factory.support.DefaultListableBeanFactory – Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1774b9b: defining beans [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,resourceDao,userDao,realLogManager,realManager,realTranManager,businessManager,apporderManager,goodsdetailManager,imgorderManager,apprealManager,arrearManager,assessManager,backgoodsManager,backstationManager,bankManager,carrygoodsManager,carrygoodsWarinManager,carryManager,disBoxManager,disgoodsManager,disoverManager,goodsManager,lineAccManager,lineDetailsManager,lineManager,linenoManager,lineStationManager,lineSuperinManager,lineWcManager,numManager,ODManager,ordergatherManager,ordergoodsGatherManager,orderGoodsManager,orderGoodszManager,orderLineManager,orderManager,pickupManager,printWarManager,reportManager,salesManager,salestatusManager,simulatorManager,stocktakeDetailsManager,stocktakeManager,superinManager,superonlygoManager,superoutManager,supplierManager,txtFileManager,userLineManager,warehouseManager,warinManager,warLogManager,warManager,wcManager,stationManager,actionManager,regionManager,resourceManager,roleManager,userManager,org.springframework.context.annotation.internalPersistenceAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,dataSource,sessionFactory,transactionManager,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,org.spring.SpringContextHolder#0]; root of factory hierarchy

2012-02-21 11:28:53,505 [Thread-2] INFO  org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean – Closing Hibernate SessionFactory

看上去， 可能是 某一列 字符串类型的数据， 长度太长了。
也就是 Java 程序那里，先尝试看看，所有的 String 类型的数值，先不要填写，或者只填写1-2个字母看看，是否能正确运行。
如果能够正常运行的话，你再去看看，出错的时候，传入的参数，都是些什么，再和数据库中的 字段长度对比一下，看看到底是哪些字段定义的太短了。

版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。

发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/185052.html原文链接：https://javaforall.net

赞 (0)
全栈程序员-站长的头像全栈程序员-站长
0 0


相关推荐

  • [图文教程] 手把手教你安装Android SDK

    [图文教程] 手把手教你安装Android SDK

    [图文教程] 手把手教你安装Android SDK配置环境总是痛苦的，不断地找教程，寻方法……在不断犯错的道路上跌跌撞撞……有点收获还好但是！几百年不配置一次环境，要这经验值何用？记录下来吧，以后也可以傻瓜式跟着教程走我已经下载并安装了AndroidStudio没有下载安装的可移步————>AndroidStudio官网下载开始下载AndroidSDK不用跑了——》AndroidSDK免费下载安装地址不让改不是…下一步吧安装权限……好像问题不大，下一步安装位置……可以更改…

    全栈程序员-站长的头像 全栈程序员-站长
    2022年7月21日
  • array去重 java_java 数组去重[通俗易懂]

    array去重 java_java 数组去重[通俗易懂]

    array去重 java_java 数组去重[通俗易懂]uniq.javaimportjava.util.Arrays;importjava.util.ArrayList;importjava.util.List;publicclassuniq{publicstaticvoidmain(String[]args){ArrayListoList=newArrayList<>(Arrays.asList(newOb…

    全栈程序员-站长的头像 全栈程序员-站长
    2022年6月14日
  • 怎么理解JS Promise

    怎么理解JS Promise

    怎么理解JS Promise      由于昨天发了一篇关于setTimeout的文章，里面提到了Promise，那篇文章里没有解释Promise的用法和含义，因为昨天的我还没太懂Promise，所以没有在那篇文章继续解释Promise，然后今天的我总算是对Promise有所理解了，然后我来谈谈我学到的Promise的知识，因为是个人的理解，所以会不全面，请多包涵。一、何为Promise在MDNwebdo…

    全栈程序员-站长的头像 全栈程序员-站长
    2022年6月11日
  • 4.pycharm添加第三方库[通俗易懂]

    4.pycharm添加第三方库[通俗易懂]

    4.pycharm添加第三方库[通俗易懂]网络爬虫的第一步就是根据URL，获取网页的HTML信息。在Python3中，可以使用urllib.request和requests进行网页爬取。（1）准备所需库我们需要准备一款名为BeautifulSoup（网页解析）的开源库，用于对下载的网页进行解析，我们是用的是PyCharm编译环境所以可以直接下载该开源库。urllib库是python内置的，无需我们额外安装，只要安装了Python就可以使用这个库。requests库是第三方库，需要我们自己安装。第三方库安装步骤如下：选择File-&g

    全栈程序员-站长的头像 全栈程序员-站长
    2022年8月29日
  • cns服务搭建+手机ml,百度直连「建议收藏」

    cns服务搭建+手机ml,百度直连「建议收藏」

    cns服务搭建+手机ml,百度直连「建议收藏」1买个服务器，阿里云或腾讯云2执行代码GitHub：githubLinux一键:安装:`typecurl&>/dev/null&&echo’curl-O’||echo’wget-Ocns.sh’`http://pros.cutebi.taobao69.cn:666/cns/cns.sh&&shcns.sh卸载:`typecurl&>/dev/null&&echo’curl-

    全栈程序员-站长的头像 全栈程序员-站长
    2022年10月28日
  • C# Sort排序

    C# Sort排序

    C# Sort排序List的Sort方法排序有三种结果1,0，-1分别表示大于，等于，小于。1.对于数值类型的List(List)，直接使用Sort进行排序。ListscoreList=newList(){89,100,78,23,67};scoreList.Sort();//默认按升序排列，相当于：scoreList.Sort((x,y)=>x.CompareTo(y))scoreLis

    全栈程序员-站长的头像 全栈程序员-站长
    2022年7月15日

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

关注全栈程序员社区公众号