Hm, I actually tried .field(), .inline(), .value() - none of them worked out.
On Mon, Mar 23, 2015 at 5:25 PM, Lukas Eder <[email protected]> wrote: > > > 2015-03-23 15:06 GMT+01:00 Oleg <[email protected]>: > >> Yes, it is Oracle. >> >> By the way, is there a way to override JOOQ behavior for such situations >> in the future? >> > > In this particular case, the "dequalifying" of the column reference is > hard-wired in jOOQ's internals (in org.jooq.impl.SelectQueryImpl) and > cannot be overridden, although as I mentioned in my previous E-Mail, > DSL.field(String) should work, as that's how you can inject "plain SQL" > into jOOQ ASTs (Abstract Syntax Trees). Here's some additional info on > "plain SQL" from the manual: > http://www.jooq.org/doc/latest/manual/sql-building/plain-sql/ > > I expected that DSL.inline() will help and output as is, but Jooq tries to >> wrap it with "" anyway >> > > DSL.inline() is used for inline bind variables / constants. If they're > String constants, they have to be wrapped with apostrophes. > > >> - it would be great if I could fix it until bug or problem is fixed. >> > > We'll certainly look into this pretty soon for jOOQ 3.6.0 and probably > also for 3.5.4. Do note that we deliver the sources and grant the right to > modification to our customers when you purchase the jOOQ Professional > Edition license as some of our customers need to be able to fix issues very > quickly themselves. Let me know if you are interested in more details about > our commercial licensing terms. > > Looking forward to hearing from you again, > Lukas > > -- > You received this message because you are subscribed to a topic in the > Google Groups "jOOQ User Group" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/jooq-user/WDAsX3ySbeQ/unsubscribe. > To unsubscribe from this group and all its topics, 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.
