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

2024-06-21 Thread 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.T

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

2024-06-21 Thread 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 acc

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

2024-06-21 Thread 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 On Friday, June 21, 2024 at 6:51:49 PM UTC+2 lukas...@gmail.com wrote: > Hi Bert-Jan, > > I'm assuming this is a runtime query, not a code generation query? Have > you c