Digest for jooq-user@googlegroups.com - 3 updates in 1 topic

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Digest for jooq-user@googlegroups.com - 3 updates in 1 topic

http://groups.google.com/group/jooq-user/topics mailing list
[hidden email]: Sep 28 08:51AM -0700

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:
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.
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:
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.
Rob Sargent <[hidden email]>: Sep 28 04:04PM -0600

Perhaps the jooq user doesn’t have permission to see the core table(s)
[hidden email]: Sep 29 01:39AM -0700

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)
I think it might be a bug in the Derby integration... If I set
... the problem goes away. I think Derby might be getting upset with the
level of quoting that jooq uses by default.
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].