Can't get metadata for table from Oracle database due to malformed query

[Bert-Jan de Gier]

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

[Lukas Eder]

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

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/f90bfa22-a49e-4463-91b3-06b10b9cc24dn%40googlegroups.com.

[Bert-Jan de Gier]

Hi Lukas,

Thanks for the very quick reply. Yes, that did the trick! Thanks and have a great weekend.

Best regards,

Bert-Jan