Hi Ben, Hmm, I thought that this was indeed a queue implementation. Very sophisticated, with recursive SQL. I'm personally curious (having recently written a somewhat controversial article on the subject: http://blog.jooq.org/2014/09/26/using-your-rdbms-for-messaging-is-totally-ok/). Were you at the point where you also evaluated the performance and locking implications of your implementation? It looks like you have implemented something similar to Oracle's magical FOR UDPATE SKIP LOCKED clause, which is the implementation basis of Oracle AQ that has been made public (= documented) with Oracle 10g, I believe.
Cheers, Lukas 2014-11-24 15:34 GMT+01:00 Ben Hood <[email protected]>: > On Mon, Nov 24, 2014 at 8:28 AM, Lukas Eder <[email protected]> wrote: > > OK, so that's clear now. However, you currently can't use that syntax in > > jOOQ. jOOQ cannot reason about DSL.field("x") being really a row with its > > nested columns. > > Good to know. > > > As you can see, the function call really returns an org.jooq.Table > instance > > with column references that you can use. This is now supported for SQL > > Server (jOOQ 3.3), PostgreSQL (jOOQ 3.5), and Firebird (jOOQ 3.5). > > > > Let me know if you want to go further into writing this query with jOOQ > > That's a very cool construct. Unfortunately I've just learned today > that the underlying business driver behind this "database as a queue" > solution has evaporated, so I'm going to have to put this example into > my JOOQ toolbox, ready for the next SQL battle. > > Cheers, > > Ben > > -- > 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.
