Hi Bert-Jan, I'm assuming this is a runtime query, not a code generation query? Have you configured your Configuration with the correct (versioned) SQLDialect? jOOQ 3.19 has started supporting SQLDialect.ORACLE23AI, so if you're using an older version (e.g. 18c), then you should configure jOOQ accordingly, using SQLDialect.ORACLE18C. See the support matrix: https://www.jooq.org/download/support-matrix
I hope this helps, Lukas On Fri, Jun 21, 2024 at 6:14 PM Bert-Jan de Gier <[email protected]> wrote: > Hello, > > We've recently upgraded from jOOQ 3.18 to 3.19, but now we are having a > problem with getting metadata (about the available columns) from a table in > an Oracle database. We get the following error message: > > org.jooq.exception.DataAccessException: SQL [select null catalog_name, > t.OWNER, t.TRIGGER_NAME, null table_catalog_name, t.TABLE_OWNER, > t.TABLE_NAME, case when t.TRIGGERING_EVENT like '%INSERT%' then true when > not (t.TRIGGERING_EVENT like '%INSERT%') then false end i, case when > t.TRIGGERING_EVENT like '%UPDATE%' then true when not (t.TRIGGERING_EVENT > like '%UPDATE%') then false end u, case when t.TRIGGERING_EVENT like > '%DELETE%' then true when not (t.TRIGGERING_EVENT like '%DELETE%') then > false end d, case when t.TRIGGER_TYPE like '%EACH ROW%' then 'FOR_EACH_ROW' > when t.TRIGGER_TYPE like '%STATEMENT%' then 'FOR_EACH_STATEMENT' end > action_orientation, case when t.TRIGGER_TYPE like '%BEFORE%' then 'BEFORE' > when t.TRIGGER_TYPE like '%AFTER%' then 'AFTER' when t.TRIGGER_TYPE like > '%INSTEAD OF%' then 'INSTEAD_OF' end action_timing, t.WHEN_CLAUSE, 0 > action_order, t.TRIGGER_BODY from SYS.ALL_TRIGGERS t where (t.OWNER in (?) > and t.BASE_OBJECT_TYPE in ('TABLE', 'VIEW')) order by t.OWNER, > t.TRIGGER_NAME]; ORA-00904: "FALSE": invalid ID > > Am I doing something wrong or is this an issue that was introduced in > version 3.19? Any input is appreciated. Thanks in advance. > > Best regards, > Bert-Jan de Gier > > -- > 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/f90bfa22-a49e-4463-91b3-06b10b9cc24dn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/f90bfa22-a49e-4463-91b3-06b10b9cc24dn%40googlegroups.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/CAB4ELO6wdfrFsC7otgCmt2sKxd9yRC3RQhdSop7w8wUzjAKPoQ%40mail.gmail.com.
