That's a feature not a bug! :) jOOQ by default quotes all identifiers. That's useful to support all the edge cases of case sensitive identifiers, or identifiers containing special characters by default (other ORMs have a lot of trouble with these). It also protects against SQL injection, if users forget to sanitise their inputs to DSL.name().
The problem in your case is that you're creating your objects using JDBC directly, using Derby's default case (UPPER CASE), and then request data from quoted "lower case" identifiers. You have several ways to work around this: - Create the schema using jOOQ API as well. We support a lot of DDL statements that you could use - Use the code generator - Use DSL.unquotedName() - Use RenderNameStyle - as you did - Use the plain SQL API (DSL.field(String), instead of DSL.field(Name)) I hope this helps, Lukas On Sun, Sep 29, 2019 at 10:39 AM <[email protected]> wrote: > On Saturday, September 28, 2019 at 10:04:13 PM UTC, Rob Sargent wrote: >> >> Perhaps the jooq user doesn’t have permission to see the core table(s) >> > > Hello! > > I think it might be a bug in the Derby integration... If I set > > withRenderNameStyle(RenderNameStyle.AS_IS) > > ... the problem goes away. I think Derby might be getting upset with the > level of quoting that jooq uses by default. > > > -- > 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/0e98b093-f88e-4829-8b94-8c3e1efd38ba%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/0e98b093-f88e-4829-8b94-8c3e1efd38ba%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/CAB4ELO4RT46sWjNOWOYpSx%3DTxF-ONx0_bspSq2f2vhitJr9guw%40mail.gmail.com.
