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.
