You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Mark Struberg <st...@yahoo.de.INVALID> on 2023/04/16 10:17:30 UTC
Re: Loading relations
Can you probably create a small sample project with the entities + a small unit test?
That way we can make sure to really talk about exactly the same scenario.
txs and LieGrue,
strub
> Am 23.03.2023 um 18:16 schrieb Marco DE BOOIJ <ma...@debooy.eu>:
>
> I searched on the web but cannot filter out the solution. I get pointed to Spring and Hibernate but I am only interested in the solution with OpenJPA.
> I have a table in which I store the taxonomy tree. The key is the TAXON_ID and it is linked with its parent through the PARENT_ID. I created the following DTO named TaxonDto (I left out the fields that are of no importance):
>
> @Column(name="PARENT_ID")
> private Long parentId;
> @Column(name="RANG", length=3, nullable=false)
> private String rang;
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> @Column(name="TAXON_ID", nullable=false, unique=true, updatable=false)
> private Long taxonId;
>
> @OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER, targetEntity=TaxonnaamDto.class, orphanRemoval=true)
> @JoinColumn(name="TAXON_ID", nullable=false, updatable=false, insertable=true)
> @MapKey(name="taal")
> private Map<String, TaxonnaamDto> taxonnamen = new HashMap<>();
>
> @OneToOne(cascade=CascadeType.ALL, fetch=FetchType.LAZY, targetEntity=TaxonDto.class, orphanRemoval=true)
> @JoinColumn(name="PARENT_ID", referencedColumnName="TAXON_ID", updatable=false, insertable=false)
> private TaxonDto parent;
>
> My problem lies in the @OneToOne. I did a test with FetchType.EAGER but then the size of the returned data is 3x bigger as with LAZY since I get all parents below the taxon. What I want is that the parent is fetched when the rang is a specific value namely 'oso'. I can live with a solution where the parent is not recursivly filled, the parent of the parent in this DTO must be null.
>
> Is this possible and if so how can I do this? I have seen discriminators, fetchgroup and subclass DTO but it leaves me clueless.
>