Hello, The DB2 isolation-clause is currently not supported in jOOQ. I have created a feature request for this: https://github.com/jOOQ/jOOQ/issues/2537
I might not be able to integrate such a change any time soon, as I currently cannot integration test DB2 extensions on my Windows 8 machine. Indeed, the most "elegant" solution for you to implement right now would be to create an ExecuteListener patching the rendered SQL statement on the renderEnd() event. ExecuteListeners are documented here - http://www.jooq.org/doc/3.0/manual/sql-execution/execute-listeners/ - http://www.jooq.org/javadoc/latest/org/jooq/ExecuteListener.html You could then hook this ExecuteListener into those Configurations that should generate this clause. Cheers Lukas 2013/6/21 <[email protected]> > DB2 allows the specification of an 'isolation-clause' on the select > statement. Our DBAs has requested us to use this clause on many select > statements so that DB2 won't escalate a lock to a table lock. (These > queries are mainly used to select data for some of our reports that we have > to generate from a batch job). > > I haven't figured out how to specify it with jOOQ. > > > Specifically, we have to add ' WITH UR' at the end of the sql statement > (UR = uncommittted read). > > I am using a SelectQuery object to dynamically build the query. Obviously > I can get the SQL string when the query is build & append it myself; but I > was hoping for a more elegant solution. > > Would creating a custom QueryPart be the way to accomplish what i need? > > -- > 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/groups/opt_out. > > > -- 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/groups/opt_out.
