Re: [h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-11-18 Thread Noel Grandin
On 2013-11-18 09:44, Noel Grandin wrote: litailang, I can't find anywhere where it says that Derby supports this syntax. Ah, I see now. It looks like the comments in our existing code were wrong. I have no idea why we thought that Derby supported this syntax. Your patch has been applied

Re: [h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-11-17 Thread Noel Grandin
Hi litailang, I can't find anywhere where it says that Derby supports this syntax. Also, your patch contains an unrelated change to the Shell class - any idea what that was for? Regards, Noel. On 2013-11-14 18:03, litailang wrote: Hi, I wrote a patch for this issue. support DB2's isolation-

Re: [h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-11-14 Thread litailang
Hi, I wrote a patch for this issue. support DB2's isolation-clause and lock-request-clause. litailang 2013/10/26 Lukas Eder : > 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

Re: [h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-10-26 Thread Lukas Eder
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/info

Re: [h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-10-25 Thread 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 Re

[h2] DB2 Mode Support WITH UR syntax (uncommitted read)

2013-10-02 Thread Bert Roex
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 Databa