Perhaps the jooq user doesn’t have permission to see the core table(s) > On Sep 28, 2019, at 9:51 AM, [email protected] wrote: > > Hello. > > I have the following test program that creates a Derby database, creates > a schema, creates a table in that schema, and then inserts a few values > into it. I'm able to query that table using raw SQL successfully, but JOOQ > seems to generate SQL that Derby doesn't like: > > https://gist.github.com/io7m/8fb4d8c8b3905234d837f68f0b6c4320 > > Exception in thread "main" org.jooq.exception.DataAccessException: SQL > [select "x" from "core"."example"]; Schema 'core' does not exist > at org.jooq_3.12.1.DERBY.debug(Unknown Source) > at org.jooq.impl.Tools.translate(Tools.java:2717) > at > org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:755) > at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:383) > at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:501) > at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:470) > at > org.jooq.impl.AbstractResultQuery.fetchStream(AbstractResultQuery.java:441) > at org.jooq.impl.SelectImpl.fetchStream(SelectImpl.java:2724) > at SchemaIssue.main(SchemaIssue.java:54) > > Any assistance would be appreciated. I'm not using code generation, > so I'm assuming that I need to tell JOOQ more information than I've > given it. > > -- > 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] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/abde1207-07ea-4686-b5b9-29594a4d8ac0%40googlegroups.com > > <https://groups.google.com/d/msgid/jooq-user/abde1207-07ea-4686-b5b9-29594a4d8ac0%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/6B5E6F7F-F2D8-40DB-9A8A-698B6FC6CA0A%40gmail.com.
