Hey Lukas,
On Friday, 31 August 2012 09:03:37 UTC+1, Lukas Eder wrote:
>
> Have you had any further success with your tweak?
Sorry about not following up with this.
So, yes, the following tweak works on HSQL, MySQL and Oracle:
val spacePath =
Factory.groupConcat(SPACES.NAME).orderBy(SPACES.ID).separator("/")
val space = t.select(SPACE_PATHS.as("d").DESCENDANT).
select(spacePath.as("path")).
from(SPACE_PATHS.as("d")).
join(SPACE_PATHS.as("a")).
on(SPACE_PATHS.as("a").DESCENDANT.equal(SPACE_PATHS.as("d").DESCENDANT)).
join(SPACES).
on(SPACES.ID.equal(SPACE_PATHS.as("a").ANCESTOR)).
where(SPACE_PATHS.as("d").ANCESTOR.equal(0)).
and(SPACE_PATHS.as("d").ANCESTOR.notEqual(SPACE_PATHS.as("d").DESCENDANT)).
groupBy(SPACE_PATHS.as("d").DESCENDANT).
having(spacePath.like(ROOT_SPACE.name + "/" + path)).
fetchOne()
>
> Note, since you're using jOOQ in Scala, I'd like to ask you for some
> feedback on this thread here:
> https://groups.google.com/forum/#!topic/jooq-user/rFN1oC2oL_U/discussion
>
> You can greatly influence a future jOOQ-Scala integration!
>
>
OK, I check that post out.
Cheers,
Ben
