Hi Emrul, Indeed, ExecuteListener.start() and end() events would be good places to hook into, if you want these statements to be run on a per-statement basis. Another option is to implement your own TransactionProvider and then run these statements on a per-transaction basis, if you're using jOOQ's transaction API. You can also do both, of course, and put a flag in Configuration.data() to check if you're already in a "session authorisation context".
Hope this helps, Lukas 2016-05-08 19:50 GMT+02:00 Emrul Islam <[email protected]>: > Hi, > > Is there any way to wrap 'SET SESSION AUTHORIZATION' and 'RESET SESSION > AUTHORIZATION' statements around jOOQ queries? > > I'm using Postgres - > http://www.postgresql.org/docs/9.5/static/sql-set-session-authorization.html > and guessing I need to do something with ExecuteListener but can anyone > confirm? > > -- > 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.
