Hey Nkolay, On Tue, Sep 10, 2013 at 5:41 PM, Nicholas Ustinov <[email protected]> wrote: > So at all: does JOOQ support CTE (it may be useful in oracle too for other > reasons than hierarchical queries), recursive CTE or another syntax for > hierarchical queries in other databases than Oracle? (for now I need > PostgreSQL and MSSQL Server)
FWIW we had a requirement to support cross database hierarchical queries with JOOQ. We ended up taking a closure tree approach, which doesn't take advantage of any native DB support for hierarchical queries and forced us to redesign the the layout of the affect tables. But it is portable and appears to scale (at least for our workloads). HTH, 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/groups/opt_out.
