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.
