Digest for jooq-user@googlegroups.com - 3 updates in 2 topics

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 2 topics

http://groups.google.com/group/jooq-user/topics mailing list
Lukas Eder <[hidden email]>: Oct 17 01:20PM +0200

Hi Vishwanath
 
(I've noticed, this discussion accidentally went off-list. Putting the
mailing list in CC again, redacting the content)
 
Indeed, the auto-generation of an alias for derived tables in
SelectQueryImpl.asTable() should be faster. I thought there was a pending
issue to fix this, but I cannot seem to find it. I've added an issue here:
https://github.com/jOOQ/jOOQ/issues/6714
 
The problem is, we need an alias for derived tables, and if you don't
provide it explicitly, that's probably the best way to go right now
(discussion will be in #6714)
 
You can always work around this problem by creating an explicit alias for
your subquery, e.g. by calling Select.asTable("alias") or
table(select).as("alias").
 
I hope this helps,
Lukas
 
2017-10-17 13:03 GMT+02:00 Vishwanath M:
 
Buddhika Ekanayake <[hidden email]>: Oct 16 11:40PM -0700

Hi Lukas, Thanks very much for your response.
 
Could you please provide more details how to do this with a Firebird view
? lets say I have a view called TEST and ID_TEST will be the syntetic
primary key, How should I pass this to code gen. via Maven ?
 
<configuration>
<generator>
<database>
<syntheticPrimaryKeys>???????</syntheticPrimaryKeys>
</database>
</generator></configuration>
 
 
BR,
Buddhika E.
 
 
On Monday, 16 October 2017 03:15:33 UTC+5:30, Lukas Eder wrote:
Lukas Eder <[hidden email]>: Oct 17 09:50AM +0200

Hi Buddhika,
 
In short, these configurations always do the same thing. They're regular
expressions matching things, in this case, you have to match TEST\.ID_TEST.
 
If you're using another database that supports schemas and/or catalogs,
you'd have to prepend those as well, e.g. by matching all schemata:
(.*?\.)?TEST\.ID_TEST
 
And if you want to stay on the safe side, you can make your regex case
insensitive: (?i:TEST\.ID_TEST)
 
And yes, this is the ordinary code generator <configuration> element, which
you may use in standalone code generator configurations, or with maven, etc.
 
Hope this helps,
Lukas
 
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].