什么是Jooq事务隔离级别?脏读会发生吗? [英] What is Jooq Transaction isolation level? Can dirty read happen?

问题描述

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

Based on comments in https://www.jooq.org/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.

这篇关于什么是Jooq事务隔离级别?脏读会发生吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！