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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/abde1207-07ea-4686-b5b9-29594a4d8ac0%40googlegroups.com.
