什么是Jooq事务隔离级别?脏读会发生吗?

本文介绍了什么是Jooq事务隔离级别?脏读会发生吗?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

基于 www中的评论. jooq/doc/3.6/manual/sql-execution/transaction-management/似乎无法更改隔离级别.但是，尚不清楚Jooq设置的隔离级别是什么，因此我的问题是: Jooq使用的隔离级别是什么?

Based on comments in www.jooq/doc/3.6/manual/sql-execution/transaction-management/ changing isolation level doesn't seems possible with Jooq yet. However it is not clear what is the isolation level Jooq is setting, hence my question: what is the isolation level that Jooq is using?

特别是，看起来我遇到了脏读，而我需要进行事务处理来防止这种情况. 有人可以确认Jooq交易阻止了恶意读取吗?

Especially, it looks like I am experiencing dirty reads, while I need the transaction to prevent that. Can someone confirm that dirty reads are prevented by Jooq transactions?

注意:将Jooq与Mysql一起使用.该数据库是一个AWS Aurora实例.

推荐答案

jOOQ 3.9目前还不支持管理事务隔离级别.要添加对此功能的支持的相关功能请求是#4836 .

jOOQ 3.9 doesn't support managing transaction isolation levels yet. The relevant feature request to add support for this is #4836.

您将需要直接或通过连接池/数据源间接配置JDBC连接.

You will need to configure your JDBC connection directly, or indirectly via your connection pool / data source.