For the record, and anyone finding this discussion later, jOOQ 3.13 will deploy a workaround for this ojdbc bug that can be activated / deactivated using a new flag Settings.applyWorkaroundFor7962. It is turned on by default, and affects only the ORACLE dialect.
The problem happens when using: - An INSERT statement - With Connection.prepareStatement(String, String[]), i.e. only when fetching generated keys - Using a qualified table name - Using a quoted table qualifier Any workaround that prevents any of the above (turning off fetching of generated keys, not qualifying the table name, not quoting the table identifier) will prevent the exposure of the ojdbc bug. So, a workaround can already be deployed prior to jOOQ 3.13, using relevant Settings. The above Settings.applyWorkaroundFor7962 will work around the issue by default, and can be turned off in case someone does not use a problematic ojdbc version, but needs to quote schema identifiers. For more details, see: https://github.com/jOOQ/jOOQ/issues/7962 Thanks, Lukas On Friday, September 28, 2018 at 12:42:41 PM UTC+2, Lukas Eder wrote: > > Hi Markus, > > I'm very sorry, I hadn't realised that there was still an open question in > your previous email > > On Thu, Sep 13, 2018 at 10:52 AM <[email protected]> wrote: > >> But the error still occurs. >> >> The only thing that seems to help is downgrading the jdbc driver to ojdbc6. >> After that, *all works as expected*. >> Unfortunately this is not a very robust approach, as there is no way to tell >> if the issue will reappear in other driver/db combinations. >> >> As for the other approach ("Settings.renderSchema = false"): Is this >> something I need to specify in the generator, or is this a runtime >> configuration? >> I did not find that setting anywhere in the XML schema used for configuring >> the generator. >> How would I use that? >> >> > Settings is something you pass to your jOOQ Configuration. You can find > the relevant documentation here: > > https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings > -- 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/eeaf2e43-5163-403b-9db2-0d7c1c518951%40googlegroups.com.
