Unable to translate SQLException with Error code ‘0‘, will now try the fallback translator

原创 已于 2022-02-12 18:25:53 修改 · 5k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#Transaction注解

于 2022-02-10 22:47:28 首次发布
博客内容讨论了在Java中遇到的无法翻译SQLException错误，该错误与设置事务为只读有关。在Service层添加了@Transactional(readOnly=true)导致更新操作失败，因为未将只读属性设为false。解决方案在于正确管理和切换事务的只读状态。

Unable to translate SQLException with Error code '0', will now try the fallback translator

发生了这个报错，原因是 jdbc read only，因为在 Service 上增加了：

@Transactional(readOnly = true)

而在更新方法没有增加让只读为 false

图片

解决12899报错
D_johnie的博客
12-08 680
　　出现ORA-12899,是字符集引起的,中文在UTF-8中占3个字节,ZHS16GBK中占2个字节,而源dmp文件字符集是ZHS16GBK库里倒出来的数据,现在要导入到目标字符集为UTF-8的库里,所以会出现ORA-12899 　　解决：可以将字符集转换成ZHS16GBK，下面是具体的方法。不过我这个数据库里当时没有文件，我是在将.dmp数据文件导入本地电脑时报12899的，所以要是...
解决 Unable to translate SQLException with Error code ‘17059‘, will now try the fallback translator
热门推荐
愿我如星君如月 ... 夜夜流光相皎洁 ...
04-13 5万+
1.报错：Unable to translate SQLException with Error code '17059', will now try the fallback translator 报错如下： 2. 原因和解决： 在网上查到这个错是有结果返回，但是在装入resultMap的时候有问题。 我只是执行一个简单的查询sql。 我的情况是：有个字段
Unable to translate SQLException with Error code '0', will now try the fallback translator
zhanghaisong_2015的博客
07-19 1万+
 Unable to translate SQLException with Error code '0', will now try the fallback translator resultMap对应的实体类和xml对应的列数据类型不匹配导致数据装不下!
解决EF Core 8.0.2中IQueryable.Concat的5个隐藏陷阱
gitblog_00989的博客
09-10 418
你是否在使用EF Core 8.0.2时遇到过`IQueryable.Concat`操作失败的情况？明明在内存中运行正常的代码，一到数据库查询就抛出异常？本文将揭示这个高频使用API的5个关键限制，并提供经过验证的解决方案，让你彻底摆脱"本地能跑，生产报错"的困境。 ## 限制1：类型兼容性验证缺失 EF Core要求Concat操作的两个序列必须具有完全相同的实体类型和形状，但框架不会在编译...
iBatis resultMap报错　nullValue完美解决
一个老码农
03-31 1万+
错误信息：SQLErrorCodesFactory - Database product name cached for DataSource [org.apache.commons.dbcp.BasicDataSource@19c5048]: name is MySQLSQLErrorCodesFactory - SQL error codes for MySQL foundSQLE
数据库插入数据显示Extracted SQL state class '22' from value '22001'和Error code '0', will now try the falback
波波的博客
08-14 2928
最近在写一个个人博客项目的时候，在管理员页面保存新增的文章的时候，控制台报错 Unable to translate SQLException with Error code '0', will now try the fallback translator Extracted SQL state class '22' from value '22001' 然后百度了一下第一个错是 res...
java.sql.SQLException: 无法转换为内部表示
ilemon
02-28 4563
报错如下： unable to translate sqlexception with error code '17059' 出错原因：同一个字段在数据库与程序中不一致造成的。
【DB2】DB2错误号汇总
临渊羡鱼
01-17 8651
sqlcode sqlstate DB2错误信息（按sqlcode排序） 000 00000 SQL语句成功完成 01xxx SQL语句成功完成，但是有警告 +012 01545 未限定的列名被解释为一个有相互关系的引用 +098 01568 动态SQL语句用分号结束 +100 02000 没有找到满足SQL语句的行 +110 01561 用DATA CAPTURE定义
[DEBUG]|2025-08-28 15:48:50,282|method:org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:281)Unable to translate SQLException with Error code '823', will now try the fallback translator
08-29
Unable to translate SQLException with Error code '823' ... [DEBUG] ... Extracted SQL state class 'S0' from value 'S0002' ... 然后连接被关闭，并且在关闭语句时又抛出了“该连接已关闭”的异常。 解决...
[DEBUG]|2025-08-28 15:48:50,282|method:org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:281)Unable to translate SQLException with Error code '823', will now try the fallback translator [DEBUG]|2025-08-28 15:48:50,283|method:org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:96)Extracted SQL state class 'S0' from value 'S0002' [DEBUG]|2025-08-28 15:48:50,284|method:org.mybatis.spring.SqlSessionUtils.closeSqlSession(SqlSessionUtils.java:173)Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@782669c3] [DEBUG]|2025-08-28 15:48:50,284|method:org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:327)Returning JDBC Connection to DataSource [DEBUG]|2025-08-28 15:48:50,286|method:com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:98)close statement error com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
08-29
if (e.getErrorCode() == 823 || e.getMessage().contains("连接已关闭")) { retries++; System.out.println("连接失败，正在重试第 " + retries + " 次..."); try { Thread.sleep(2000); // 等待 2 秒后重试 ...
: Connection released: [id: 0][route: {}->http://192.168.12.59:6041][total kept alive: 1; route allocated: 1 of 20; total allocated: 1 of 200] 2025-08-29 09:54:39.783 DEBUG 21556 --- [ main] org.mybatis.spring.SqlSessionUtils : Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68212585] 2025-08-29 09:54:39.925 DEBUG 21556 --- [ main] o.s.b.f.xml.XmlBeanDefinitionReader : Loaded 11 bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml] 2025-08-29 09:54:39.933 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'DB2' 2025-08-29 09:54:39.965 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Derby' 2025-08-29 09:54:39.968 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'H2' 2025-08-29 09:54:39.970 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'HDB' 2025-08-29 09:54:39.977 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'HSQL' 2025-08-29 09:54:39.979 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Informix' 2025-08-29 09:54:39.980 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'MS-SQL' 2025-08-29 09:54:39.983 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'MySQL' 2025-08-29 09:54:39.985 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Oracle' 2025-08-29 09:54:39.988 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'PostgreSQL' 2025-08-29 09:54:39.991 DEBUG 21556 --- [ main] o.s.b.f.s.DefaultListableBeanFactory : Creating shared instance of singleton bean 'Sybase' 2025-08-29 09:54:39.994 DEBUG 21556 --- [ main] o.s.jdbc.support.SQLErrorCodesFactory : Looking up default SQLErrorCodes for DataSource [com.depower.datasource.config.DynamicDataSource@3596a9d5] 2025-08-29 09:54:39.994 DEBUG 21556 --- [ main] o.s.jdbc.datasource.DataSourceUtils : Fetching JDBC Connection from DataSource 2025-08-29 09:54:39.997 DEBUG 21556 --- [ main] o.s.jdbc.support.SQLErrorCodesFactory : SQL error codes for 'TDengine' not found 2025-08-29 09:54:39.998 DEBUG 21556 --- [ main] o.s.jdbc.support.SQLErrorCodesFactory : Caching SQL error codes for DataSource [com.depower.datasource.config.DynamicDataSource@3596a9d5]: database product name is 'TDengine' 2025-08-29 09:54:40.007 DEBUG 21556 --- [ main] s.j.s.SQLErrorCodeSQLExceptionTranslator : Unable to translate SQLException with Error code '537', will now try the fallback translator 2025-08-29 09:54:40.020 DEBUG 21556 --- [ main] c.d.datasource.aspect.DataSourceAspect : clean datasource
08-30
try (SqlSession session = sqlSessionFactory.openSession()) { MyMapper mapper = session.getMapper(MyMapper.class); List<User> users = mapper.selectAllUsers(); } ``` ### 3. `SQLErrorCodesFactory` ...
2025-09-18 15:29:33.615 [reactor-http-nio-5] DEBUG reactor.netty.http.server.HttpServerOperations - [a0e83397, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] New http connection, requesting read 2025-09-18 15:29:33.615 [reactor-http-nio-5] DEBUG reactor.netty.transport.TransportConfig - [a0e83397, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] Initialized pipeline DefaultChannelPipeline{(reactor.left.httpCodec = io.netty.handler.codec.http.HttpServerCodec), (reactor.left.httpTrafficHandler = reactor.netty.http.server.HttpTrafficHandler), (reactor.right.reactiveBridge = reactor.netty.channel.ChannelOperationsHandler)} 2025-09-18 15:29:33.616 [reactor-http-nio-5] DEBUG reactor.netty.http.server.HttpServerOperations - [a0e83397, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] Increasing pending responses, now 1 2025-09-18 15:29:33.616 [reactor-http-nio-5] DEBUG reactor.netty.http.server.HttpServer - [a0e83397-1, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@250c00e8 2025-09-18 15:29:33.617 [reactor-http-nio-5] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [a0e83397-4] HTTP PUT "/master/shipper/update" 2025-09-18 15:29:33.617 [reactor-http-nio-5] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [a0e83397-4] Mapped to com.hvlink.controller.ShipperController#updateShipper(ShipperDTO) 2025-09-18 15:29:33.617 [reactor-http-nio-5] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [a0e83397-4] Content-Type:application/json 2025-09-18 15:29:33.617 [reactor-http-nio-5] DEBUG o.s.w.r.r.m.a.RequestBodyMethodArgumentResolver - [a0e83397-4] 0..1 [com.hvlink.entity.dto.master.ShipperDTO] 2025-09-18 15:29:33.618 [reactor-http-nio-5] DEBUG reactor.netty.channel.FluxReceive - [a0e83397-1, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] [terminated=false, cancelled=false, pending=0, error=null]: subscribing inbound receiver 2025-09-18 15:29:33.618 [reactor-http-nio-5] DEBUG o.s.http.codec.json.Jackson2JsonDecoder - [a0e83397-4] Decoded [ShipperDTO(id=29, companyCode=null, supplierCode=null, supplierName=0012000048 - 上海信耀电子有限公司, shipper (truncated)...] 2025-09-18 15:29:33.618 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [com.hvlink.service.impl.ShipperServiceImpl.updateShipper]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT 2025-09-18 15:29:33.618 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [ConnectionID:1 ClientConnectionId: 832daba7-ee0b-4bc1-9a5c-db187f8edc8d] for JDBC transaction 2025-09-18 15:29:33.618 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [ConnectionID:1 ClientConnectionId: 832daba7-ee0b-4bc1-9a5c-db187f8edc8d] to manual commit 2025-09-18 15:29:33.628 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-09-18 15:29:33.628 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] 2025-09-18 15:29:33.629 [reactor-http-nio-5] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 832daba7-ee0b-4bc1-9a5c-db187f8edc8d] will be managed by Spring 2025-09-18 15:29:33.629 [reactor-http-nio-5] DEBUG c.h.mapper.master.ShipperMapper.existsOtherDefault - ==> Preparing: SELECT CASE WHEN EXISTS ( SELECT 1 FROM tm_shipper WHERE is_default = '是' ) THEN 1 ELSE 0 END 2025-09-18 15:29:33.629 [reactor-http-nio-5] DEBUG c.h.mapper.master.ShipperMapper.existsOtherDefault - ==> Parameters: 2025-09-18 15:29:33.644 [reactor-http-nio-5] DEBUG c.h.mapper.master.ShipperMapper.existsOtherDefault - <== Total: 1 2025-09-18 15:29:33.644 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] 2025-09-18 15:29:33.644 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] from current transaction 2025-09-18 15:29:33.644 [reactor-http-nio-5] DEBUG c.hvlink.mapper.master.ShipperMapper.updateShipper - ==> Preparing: UPDATE tm_shipper SET company_code = ?, supplier_code = ?, shipper_name = ?, address = ?, contact_person = ?, contact_tel = ?, contact_mobile = ?, is_default = ? WHERE id = ? 2025-09-18 15:29:33.645 [reactor-http-nio-5] DEBUG c.hvlink.mapper.master.ShipperMapper.updateShipper - ==> Parameters: null, null, 发货方AC(String), null, 1(String), null, null, 否(String), 29(Integer) 2025-09-18 15:29:33.660 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] 2025-09-18 15:29:33.660 [reactor-http-nio-5] DEBUG o.s.j.support.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '515', will now try the fallback translator 2025-09-18 15:29:33.660 [reactor-http-nio-5] DEBUG o.s.jdbc.support.SQLStateSQLExceptionTranslator - Extracted SQL state class '23' from value '23000' 2025-09-18 15:29:33.661 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] 2025-09-18 15:29:33.661 [reactor-http-nio-5] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f745882] 2025-09-18 15:29:33.661 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback 2025-09-18 15:29:33.661 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [ConnectionID:1 ClientConnectionId: 832daba7-ee0b-4bc1-9a5c-db187f8edc8d] 2025-09-18 15:29:33.679 [reactor-http-nio-5] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [ConnectionID:1 ClientConnectionId: 832daba7-ee0b-4bc1-9a5c-db187f8edc8d] after transaction 2025-09-18 15:29:33.680 [reactor-http-nio-5] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [a0e83397-4] Using 'application/json' given [application/json, text/plain, */*] and supported [application/json, application/*+json, application/x-ndjson, text/event-stream] 2025-09-18 15:29:33.680 [reactor-http-nio-5] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [a0e83397-4] 0..1 [com.hvlink.common.Result<java.lang.String>] 2025-09-18 15:29:33.680 [reactor-http-nio-5] DEBUG o.s.http.codec.json.Jackson2JsonEncoder - [a0e83397-4] Encoding [Result(status=500, msg=<EOL><EOL>### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServer (truncated)...] 2025-09-18 15:29:33.681 [reactor-http-nio-5] DEBUG reactor.netty.http.server.HttpServerOperations - [a0e83397-1, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] Detected non persistent http connection, preparing to close 2025-09-18 15:29:33.681 [reactor-http-nio-5] DEBUG reactor.netty.http.server.HttpServerOperations - [a0e83397-1, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] Last HTTP packet was sent, terminating the channel 2025-09-18 15:29:33.681 [reactor-http-nio-5] DEBUG reactor.netty.channel.ChannelOperations - [a0e83397-1, L:/192.168.10.122:9000 - R:/192.168.10.221:51066] [HttpServer] Channel inbound receiver cancelled (operation cancelled). 2025-09-18 15:29:33.681 [reactor-http-nio-5] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [a0e83397-4] Completed 200 OK
最新发布
09-19
2025-09-18 15:29:33.660 [reactor-http-nio-5] DEBUG o.s.j.support.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '515' 2025-09-18 15:29:33.660 [reactor-http-nio-5...
ibatis+mysql出错
阿炳のblog
12-10 752
Unable to translate SQLException with Error code '911', will now try the fal -----经检查是卸载ibatis中的语句语法错误。比如sql末尾添加了“;” 而ibatis中不能有";"结尾
项目中Spring 声明式事务使用的一些坑点分析01
QiuRiMangCao
05-04 1324
项目中Spring 声明式事务使用的一些坑点分析         事务的中重要性我在这就不用提了，10个系统基本10个都需要用到事务；事务从早期的存储过程代码中手动提交事务和回滚事务、Spring早期的编程事务管理到现在的声明事务管理，事务处理越来越简单化，可能...
SQL Error: 1406, SQLState: 22001
走在bug的路上
07-14 1万+
SQL错误代码1406和SQLState 22001通常表示“列数据过长”错误。这意味着尝试插入或更新列中的值，但该值的长度超过了该列允许的最大长度。
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

码农UP2U

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值