users@jpa-spec.java.net

[jpa-spec users] Re: JPA support for recursive data structures / object graphs

From: Heiko Wagner <heiko.wagner_at_apis.de>
Date: Tue, 26 Jan 2016 13:34:24 +0100

 

Hello Christian,

thanks for your reply. Glad to hear that I am not the only one with this
problem. Did you already approach the JPA spec lead/team, what they
think about adding CTE query support to JPAQL? I know that current RDBMS
support for CTEs strongly varies among the different vendors, which
makes implementing a proper portable abstraction a real pain.

I will take a closer look at your project soon. I am currently using
EclipseLink. From the quick look at the github page, I am assuming there
is also support for EclipseLink?

Regards,

Heiko

Am 2016-01-26 12:36, schrieb Christian Beikov:

> Hello,
>
> I had the same problem as you did, missing support for CTEs.
> That's one reason why I created blaze-persistence[1 [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 [1]
>
> 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?
 

Links:
------
[1] https://github.com/Blazebit/blaze-persistence