Hello,
I had the same problem as you did, missing support for CTEs.
That's one reason why I created blaze-persistence[1] which implements
support for CTEs for Hibernate.
Hope this library can help you to ease your pain in the meantime until
JPA gets these features.
Regards,
Christian
[1]
https://github.com/Blazebit/blaze-persistence
Am 26.01.2016 um 10:33 schrieb heiko.wagner_at_apis.de:
> Hi,
>
> I am currently working on a proof of concept Java SE application. I am
> using JPA for persintence, since I am faliliar with it from my Java EE
> project. I am trying to find out what would be a good solution to store
> directed acyclic object graphs.
>
> As far as I found out, there is no abstraction support for "CONNECT BY"
> / recursive CTEs in JPA. I could resort back to using native queries or
> drop JPA entirely in favour of a graph oriented db.
>
> Are there any condierations of providing support in JPA for this in the
> future?