Hi Julian, Thanks for your message.
I wonder if you really want to nest your table? This is a feature that a lot of users by accident: https://www.jooq.org/doc/latest/manual/sql-building/sql-statements/select-statement/select-clause/select-clause-table/ I mean, you can, and in this particular case, override the Settings.namePathSeparator to something else, e.g. "__". But perhaps you'll prefer using a flat projection, such as jooq.select(TABLE.fields()).select(someCustomColumn)? I hope this helps, Lukas On Tue, Sep 24, 2024 at 2:54 PM Julian Backes <[email protected]> wrote: > Dear all, > > we are using jOOQ Pro with Oracle and so far, it has been an > amazing experience! Unfortunately, we needed to set withRenderQuotedNames > to RenderQuotedNames.EXPLICIT_DEFAULT_UNQUOTED because we are using > multiple different DBMs (Oracle, postgres, SQLServer) with, let's say, > heterogenous naming schemes (please don't ask why). So it's not jOOQs fault > but our technical debt. This was working fine until now: > When executing a simple query like jooq.select(TABLE).from(TABLE).fetch() > we get an Oracle (19C) error saying the from-clause is wrong. When looking > at the query generated by jOOQ we have something like "select table.column1 > table.column1, table.column2 table.column2... from table", i.e. the aliases > for the columns contain dots which seem to be invalid for unquoted names. > When using jooq.selectFrom(TABLE) it works fine (there are no aliases) but > in this case, we need to add a computed column like jooq.select(TABLE, > someCustomColumn).from(TABLE) so we can't use selectFrom. > Is this a bug? Are we doing something wrong? Is there a workaround? > > Thanks in advance > Julian > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/CAPv0rXGH6iGToufybkC%2BHucf_q7v5W6BUcRoO%3DFRCPAv5ZzaGA%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAPv0rXGH6iGToufybkC%2BHucf_q7v5W6BUcRoO%3DFRCPAv5ZzaGA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4f7%3DhaCBQLaGgKzvq0SMwm87ZAiM6s47bWN%3Dq3QHugAw%40mail.gmail.com.
