java - Criteria.list() 以 BatchUpdateException : Data truncation 结尾-6ren

java - Criteria.list() 以 BatchUpdateException : Data truncation 结尾

转载作者：行者123 更新时间：2023-11-29 12:20:26

一些遗留代码表现出奇怪的行为。我有一个 Hibernate 标准:

Session session = em.unwrap(Session.class);
Criteria crit = session.createCriteria(Db.ZIPCODE_REF.CLASS);

crit.add(Restrictions.eq(Db.ZIPCODE_REF.ZIP_MIN, zipRef.getZipMin()));
crit.add(Restrictions.eq(Db.ZIPCODE_REF.ZIP_MAX, zipRef.getZipMax()));
crit.add(Restrictions.eq(Db.ZIPCODE_REF.REFERENTIEL, zipRef.getReferentiel()));

List<ZipcodeRef> list = crit.list();

list() 方法因以下异常而结束:

java.sql.BatchUpdateException: Data truncation: Data too long for column 'COMMUNE' at row 1
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:134)
    at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)
    at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    at com.sun.proxy.$Proxy222.executeBatch(Unknown Source)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:162)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:357)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:276)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
    at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:59)
    at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1099)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1528)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at fr.chronopost.majrouting.managers.impl.ZipcodeRefManagerImpl.zipExists(ZipcodeRefManagerImpl.java:254)
    at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
    at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
    at com.sun.proxy.$Proxy222.executeBatch(Unknown Source)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161)
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:162)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:357)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:276)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
    at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:59)
    at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1099)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1528)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
    at fr.chronopost.majrouting.managers.impl.ZipcodeRefManagerImpl.zipExists(ZipcodeRefManagerImpl.java:254)
    at sun.reflect.GeneratedMethodAccessor180.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy199.zipExists(Unknown Source)
    at fr.chronopost.majrouting.managers.impl.injection.HexaposteInjectionDAOImpl.createZip(HexaposteInjectionDAOImpl.java:455)
    at com.sun.proxy.$Proxy199.zipExists(Unknown Source)
    at fr.chronopost.majrouting.managers.impl.injection.HexaposteInjectionDAOImpl.createZip(HexaposteInjectionDAOImpl.java:455)
    at fr.chronopost.majrouting.managers.impl.injection.HexaposteInjectionDAOImpl.injectIntoReferential(HexaposteInjectionDAOImpl.java:216)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at fr.chronopost.majrouting.managers.impl.injection.HexaposteInjectionDAOImpl.injectIntoReferential(HexaposteInjectionDAOImpl.java:216)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy207.injectIntoReferential(Unknown Source)
    at fr.chronopost.majrouting.handlers.injection.HexaposteInjectionHandler.injectIntoReferential(HexaposteInjectionHandler.java:45)
    at fr.chronopost.majrouting.services.impl.injection.InjectionServiceImpl.execute(InjectionServiceImpl.java:58)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy207.injectIntoReferential(Unknown Source)
    at fr.chronopost.majrouting.handlers.injection.HexaposteInjectionHandler.injectIntoReferential(HexaposteInjectionHandler.java:45)
    at fr.chronopost.majrouting.services.impl.injection.InjectionServiceImpl.execute(InjectionServiceImpl.java:58)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy208.execute(Unknown Source)
    at fr.chronopost.majrouting.controllers.referentiel.ReferentielImportController.importFile(ReferentielImportController.java:124)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy208.execute(Unknown Source)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at fr.chronopost.majrouting.controllers.referentiel.ReferentielImportController.importFile(ReferentielImportController.java:124)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'COMMUNE' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3885)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2141)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
    ... 96 more
[WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  SQL Error: 1406, SQLState: 22001
[ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper  Data truncation: Data too long for column 'COMMUNE' at row 1
[ERROR] org.hibernate.engine.jdbc.batch.internal.BatchingBatch  HHH000315: Exception executing batch [Data truncation: Data too long for column 'COMMUNE' at row 1]
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'COMMUNE' at row 1
    at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)
    at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)

查看 Hibernate 日志，它似乎在以下查询上崩溃:

update ZIPCODE_REF set BU_ID=?, COMMUNE=?, DESCRIPTION=?, PAYS_ID=?, REFERENTIEL_ID=?, ZIP_MAX=?, ZIP_MIN=?, PARENT_ID=? where ID=?

这对我来说完全没有意义。我正在尝试根据条件获取对象列表，而不是更新任何内容。有什么想法吗？

编辑:这似乎是在选择之前进行的一些缓存刷新。很难找到错误更新的位置。如果有人至少可以解释我如何查看更新的参数值，那将是一个很大的帮助。

最佳答案

在执行 Criteria 查询之前，必须执行一条更新语句(但尚未提交到数据库)。如果查看 stackstrace，您可以看到查询导致刷新

at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1099)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1528)

刷新然后会导致 hibernate 将更新实际写入数据库。此时数据库会提示某个值对于列而言太大。

因此，您必须在执行 Criteria 查询之前检查正在运行的代码。

关于java - Criteria.list() 以 BatchUpdateException : Data truncation 结尾，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/29096617/

文章推荐： postgresql - Postgres 在查询计划中使用了错误的索引

文章推荐： c# - 无法连接到在线Mysql数据库(c#)

文章推荐： php - 如何在 SphinxQL 中使用 CASE WHEN 创建条件？

文章推荐： php - 创建事件时语法错误；查询独立工作正常

c - 如果字符串数组在 C 中以 null 结尾，为什么其他数据类型的数组不以 null 结尾？
C 中的字符串或字符数组必须以空字符结尾才能知道它们在哪里结束。为什么相同的规则不适用于其他类型的数组？例如。计算机如何知道整数数组在哪里结束？整数/浮点数/ double 数组在内存中的表示方式有
vim - 如何在 Vim 中编辑文件，所有行都以 ^M 结尾，但最后一行以 ^M^J 结尾
我有一堆文件需要查看。这些文件中的所有行都以 ^M (\x0D) 结尾，但最后一行以 ^M^J (\x0D\x0A) 结尾。显然，Vim 将文件类型确定为 DOS，效果是文件的整个内容是显示在一行
ruby - 这段 Ruby 代码的作用是什么？ : def self. 元类；类<< self ；自己;结尾;结尾
以下是来自 Why's Poignant Guide to Ruby Chapter 6 的 Ruby 代码片段，他试图在 Ruby 中演示元编程: # Get a metaclass for thi
检查目录路径以 "."、 ".."结尾
我有一个编程问题，希望有人能帮我解决。我正在尝试为一项工作任务学习 C 编程，我为自己设定了一个小项目，其中包括读取文件树，其中包括获取有关每个文件的信息的所有子目录。我遇到的问题是我的程序不会忽略
react高效高质量搭建后台系统系列——结尾
其他章节请看： react 高效高质量搭建后台系统系列尾篇本篇主要介绍表单查询、表单验证、通知（WebSocket）、自动构建
评估链式过滤器时忽略过滤器分号的 FFmpeg 结尾
我是 FFmepg 的新手，所以如果术语有误，请原谅我。我想将文本和音频添加到现有的视频文件中。我链接在一起 2 drawText s，然后在不同的过滤器中，我想合并原始源视频的音轨和一些背景音乐。
ripgrep - 使用ripgrep搜索单词的开头/结尾
使用grep我可以使用以下命令搜索单词的开头和结尾 grep -e '\' 这将找到I have a leg.，但找不到play allegro here。 Ripgrep(0.10.0)似乎不支持
javascript - 为什么ajax调用url以#结尾？
$.ajax({ type:'GET', cache: 'false', url:"/foo/", data:{"id": pid}, success:func
iphone - UIGestureRecognizer 结尾
我想在我的 iPhone 应用程序中处理旋转手势并在此期间旋转 imageView。在手势结束时，我想将 imageView 旋转到固定位置。所以，即。如果我将 imageView 从 0 弧度旋转到
c# - 在运行时动态地将代码添加到方法的开头/结尾
我知道检测是一种将跟踪代码动态添加到方法中以启用跟踪和调试的技术。我想知道这是否只是一个“跟踪”选项，硬编码到 CLR 中以仅添加跟踪代码，或者是否能够向方法添加任何代码？例如，我想检查某个类中每
c - 为什么C文件会以/*[]*/结尾
我正在查看一些专有源代码:使用库的示例程序。代码是用 C 和 C++ 编写的，使用 make 构建系统。每个文件都以注释掉的 [] 结尾:/*[]*/ 源文件和 #[]#对于生成文件。这可能是什么
c# - 检测文件的每一行如何以 C# 结尾
是否可以循环文件中的每一行并检查它是如何结束的(LF/CRLF): using(StreamReader sr = new StreamReader("TestFile.txt")) { st
JSF 仅适用于 .xhtml 结尾
我从 JSF 网站的编程开始。目前所有文件都以 .xhtml 结尾。当我去http://localhost:8080/myProject/start.jsf一切正常。但是当我将文件从 start.xh
.htaccess - 如何强制某些页面以斜杠[.htaccess]结尾
这是一个多站点问题。我有很多网站都带有.htaccess文件，其中包含多行，类似于: rewriterule ^(page-one|page-two|page-three)/?$ /index.php
Vim - 如何跳转到段落的开头/结尾(适用于所有情况)
真的没有简单的映射来跳转到段落的第一行或最后一行吗？ { 和 } 是“独占”命令，因此它们会跳转到段落前后的空行如果有的话，但对于段落的实际第一行或最后一行(即，当段落位于缓冲区的顶部或底部时)。这
android - 改造 - 基本网址必须以/结尾
我已经尝试了该站点上所有可能的解决方案。我以前使用过改造，过去已经解决了这个问题，但这次我无法解决。我正在使用 StackOverflow API 来获取问题及其详细信息。 API : https:/
perl - PERL 中的模式匹配以句点 "."结尾
我正在做模式匹配如下。但我没有得到正确的输出。请建议正确的代码以获得正确的输出。代码 #! /usr/bin/perl -w my $subString = "1.3.6.1.2.1.26.2.1.
javascript - 检查整数是否以 0 结尾
如何创建 if 语句以检查整数是否以 0 结尾？例如，我想要一个这样的 if 语句: var test = 107; //107 is an example it'should some unkno
javascript - 检查数字是否以 00 结尾
这个问题已经有答案了: javascript how to tell if one number is a multiple of another (6 个回答) 已关闭 3 年前。每当秒 var
BASH 测试文件名是否以 .dylib 结尾
我正在遍历文件树以识别所有 .DYLIB 文件。 #!/bin/bash #script to recursively travel a dir of n levels function traver

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

java - Criteria.list() 以 BatchUpdateException : Data truncation 结尾