Hi, I wrote a patch for this issue. support DB2's isolation-clause and lock-request-clause.
litailang 2013/10/26 Lukas Eder <[email protected]>: > I've been reasoning about this syntax as well for jOOQ, recently. Here are > the relevant DB2 manual pages: > > - > http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0059221.html > (isolation-clause) > - > http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0059222.html > (lock-request-clause) > > isolation-clause: > >>>-WITH--+-RR--+---------------------+-+----------------------->< > | '-lock-request-clause-' | > +-RS--+---------------------+-+ > | '-lock-request-clause-' | > +-CS--------------------------+ > '-UR--------------------------' > > > lock-request-clause: > >>>-USE AND KEEP--+-SHARE-----+--LOCKS-------------------------->< > +-UPDATE----+ > '-EXCLUSIVE-' > > > Since there's no syntactic magic in all of this, and if only the syntax > should be supported, not the locking, I think it might make sense to support > it completely, not just UR. > > Hope this helps, > Lukas > > Am Freitag, 25. Oktober 2013 15:00:02 UTC+2 schrieb Thomas Mueller: >> >> Hi, >> >> If you just need support for the syntax, but don't actually need the >> database to use uncommitted reads (because that would be hard to achieve), >> it should be relatively easy to add support for this in the parser >> (Parser.java). See also >> http://h2database.com/html/build.html#providing_patches >> >> Regards, >> Thomas >> >> >> >> On Wed, Oct 2, 2013 at 2:43 PM, Bert Roex <[email protected]> wrote: >>> >>> The DB2 Mode in H2 is quite complete although we use the WITH UR syntax >>> in some queries which does not seem to be supported. >>> >>> Could you please expand the DB2 Mode to allow the use of the WITH UR DB2 >>> syntax? >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "H2 Database" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> To post to this group, send email to [email protected]. >>> >>> Visit this group at http://groups.google.com/group/h2-database. >>> For more options, visit https://groups.google.com/groups/opt_out. >> >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
h2.patch.gz
Description: GNU Zip compressed data
