Support transaction with different isolation level #2147

Open
opened 2022-05-27 07:37:34 +00:00 by davies · 4 comments

Also read-only transaction

Also read-only transaction
Owner

Could you give some examples?

Could you give some examples?
Author

For long running read-only transactions, we would like it to be repeatable-read:

var opt = sql.TxOptions{
		Isolation: sql.LevelRepeatableRead,
		ReadOnly:  true,
}
session.BeginTx(&opt)
// some query
session.Rollback()
For long running read-only transactions, we would like it to be repeatable-read: ``` var opt = sql.TxOptions{ Isolation: sql.LevelRepeatableRead, ReadOnly: true, } session.BeginTx(&opt) // some query session.Rollback() ```

借楼同问,xorm是否支持设置指定的隔离级别:RC、RR等

借楼同问,xorm是否支持设置指定的隔离级别:RC、RR等
Owner

借楼同问,xorm是否支持设置指定的隔离级别:RC、RR等

Haven't supported.

> 借楼同问,xorm是否支持设置指定的隔离级别:RC、RR等 Haven't supported.
Sign in to join this conversation.
No Milestone
No Assignees
3 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#2147
No description provided.