Hi Kamal, There's currently no jOOQ API support for specifying the transaction isolation. The relevant feature request is here: https://github.com/jOOQ/jOOQ/issues/4836
If you're backing your transaction implementation to JDBC based transactions (as opposed to JTA transactions or Spring TX, for instance), you can implement your own ConnectionProvider or DataSource, which sets the Connection.setTransactionIsolation() value right after obtaining the connection, for instance: https://docs.oracle.com/javase/8/docs/api/java/sql/Connection.html#setTransactionIsolation-int- Of course, it is perfectly possible not to use the jOOQ transaction API in case of which you would specify the isolation directly on your transaction provider, and pass jOOQ an already transacted JDBC Connection. I hope this helps, Lukas 2017-08-16 17:11 GMT+02:00 Kamal raj <[email protected]>: > Hello, > > I'm trying to start a serializable transaction in Postgres. I'm wondering > how to do this in Jooq. I could able to see only the documentation of > starting a normal transaction, however I need serializable transaction in > specific. Also, I need to understand how one can recover from the errors > during the transaction. > > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
