JOOQ's nesting subselects in derived tables makes query lose connection to outer query

2017-01-20 Thread Eelco Hillenius
Hi, I converted the equivalent to this query to JOOQ: select a.mediaId from contentApplication a join mediaRelationship r on r.childId = a.mediaId join module md on md.mediaId = r.parentId where md.mediaId = 'xyz' and exists ( select 1 from sync_content as sc join

Re: How to implement order by field value with jOOQ's dynamic queries

2015-02-16 Thread Eelco Hillenius
( MyDSL.field(BAR.FOO, value1, something-else, value3) ); 2015-02-14 15:50 GMT+01:00 Eelco Hillenius eelco.h...@gmail.com javascript:: Hi, I'm trying to get this : select foo from bar order by field(foo, 'value1', 'something-else', 'value3') into a select query, but can't figure out

How to implement order by field value with jOOQ's dynamic queries

2015-02-14 Thread Eelco Hillenius
Hi, I'm trying to get this : select foo from bar order by field(foo, 'value1', 'something-else', 'value3') into a select query, but can't figure out how to translate the 'field' function in the context of order by. Any idea how to do this? Eelco btw, I also posted this question to

transaction handling eats exceptions

2014-10-27 Thread Eelco Hillenius
Hi, I love that jOOQ has integrated transaction handling now. One of the rough spots I found however is that when an exception happens during a transaction and the rollback that jOOQ then tries to perform fails, it'll 'eat' the exception that caused it. I'm not sure why the rollback fails in