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

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.
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)
 
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 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].