Allow a way to set the transaction isolation level.

[dc-dream11]

Right now I am achieving it by passing sessionVariables=tx_isolation='READ-COMMITTED' in connection string. It would be great if lib provides a way

[vietj]

@dc-dream11 which database are you talking about ?

[gavinking]

Isn't this issue a dupe? I think we already have an issue requesting this feature (it's one we want too).

[gavinking]

It's #432 I guess.

[dc-dream11]

Thanks for the quick reply, Is there a tentative date by which this feature will be released? Also, is there any way currently by which we can set the isolation level?

[dc-dream11]

@dc-dream11 which database are you talking about ?

@vietj I am talking about MySQL database

[vietj]

is setting isolation level something that is specific to each database or is there a common way of changing it ?

[dc-dream11]

I am not really sure about this.

[gavinking]

is setting isolation level something that is specific to each database or is there a common way of changing it ?

@vietj see https://github.com/eclipse-vertx/vertx-sql-client/issues/432#issuecomment-628667597

[gavinking]

For reference, this is the corresponding issue on HR: https://github.com/hibernate/hibernate-reactive/issues/875