Questions tagged [blaze-persistence]

30 questions
2
votes
1 answer

Entity view with a collection inside not working with Blaze persistance

I have a problem with entity views using blaze persistence library. I want to retrieve a list of Suppliers, each one with a list of Products but I'm getting an exception while creating Entity views model. Setup Blaze persistence core 1.6.6 Blaze…
1
vote
1 answer

Using database native functions in blaze persistence queries

CriteriaBuilder cb = cbf.create(em, Tuple.class); cb.from(Pets.class); cb.select("petId"); cb.orderByAsc("petId"); cb.where("petId").inExpression("select pet_id from get_authorized_pet_id(5)"); …
1
vote
1 answer

Blaze-Persistence: How to get real objects from getResultList()?

I have a nice Blaze-Persistence query with a WITH CTE, used with multiple other queries, tied together with unions. The query has the correct result (as of sql). public List getFilters(HourSearchDto hourSearchDto) { ... …
MacNetron
  • 13
  • 1
  • 6
1
vote
1 answer

Is Blaze-Persistence Querydsl integration support projections?

How to use Projections with Blaze-Persistence Querydsl? And in bellow example when criteria.getEmail() give me NullPointerException. So How I can overcome NullPointerException for more wheres? cbf.create(em, WalletReportDto.class) …
java dev
  • 313
  • 1
  • 3
  • 12
0
votes
0 answers

Blaze Persistence Graphql Query querying non selected fields

I have an entity view for a blog article like so: public interface BlogArticleView { @IdMapping UUID getId(); String getTitle(); String getSlug(); String getDescription(); String getContent(); Integer getLikes(); …
boomermath
  • 72
  • 5
0
votes
0 answers

Blaze Persistent CTE union subqueries in combination of queryDSL lead to syntax errors

I run in to a syntax problem where a union cannot be inside a union-all block when I attempt to use blaze persistence with queryDsl integration. I am trying to union the result of two tables into one. Here is my original code: blazeJPAQueryFactory …
0
votes
0 answers

Add a subquery in leftjoin querydsl query

i am trying to query the following data using querydsl. All works fine except the OneToMany properties like review.criteria. I need to leftjoin the review.criteria where review.id equals to criterion.review.id, so i suppose i need to use a subquery…
bullgr
  • 21
  • 1
  • 3
0
votes
1 answer

Collection type re-mapping with Blaze Persistence

I'm using the Entity View Module of Blaze Persistence for mapping the following Hibernate entities to DTOs. @Entity @Table(name = "configuration") public class ConfigurationEntity { @Id private UUID institution; @OneToMany(mappedBy =…
Hickory
  • 57
  • 5
0
votes
1 answer

Blaze Persistence & querydsl join subquery with CTE projections

In Blaze Persistence with querydsl integration, it supports subquery in join statement. So I wonder how to combine projects with CTE entity in a join-subquery condition. let's say I have two entities named person and pet. They are defined as…
pterogum
  • 3
  • 1
0
votes
1 answer

How can I create an EntityView that contains itself?

Basically I would like to do this but I just couldn't find the solution or the keywords. @EntityView(Location.class) public interface LocationView { @IdMapping int getId(); String getName(); LocationView getParent(); }
0
votes
0 answers

How to search in Json Hash-Map with JPQL by key or value

my entity code Is there a way i can search in the json map by a JPQL query ? I tried with Blaze-Persistence API but when i write : @EntityGraph(value = "record") @Query(value = "SELECT r from Records r WHERE JSON_GET(r.data , '123') =…
0
votes
0 answers

Using multiple CTE with Blaze Persistence and H2

I am trying to implement a search that considers two different entities. These entities (Article, Story) have two fields in common: id status_changed_at Due to their differences, I map the user's search request to javax.persistence.Predicate per…
0
votes
1 answer

How to deserialize blaze persistence entity view from JSON programatically?

Is there a way to programatically deserialize JSON to blaze-persistence entity view? When I'm using standard jackson object mapper, and trying to do mapper.readValue(serializedJSON, EntityViewImpl.class); where serializedJSON is string…
0
votes
1 answer

Blaze persistence - Attribute 't' not found on type 'X'

I am trying to make a recursive query using blaze persistence lib. I have two tables (a and a_temp) and entities (A and ATemp respectively) that represent them. ATemp is almost like an entity view to the A class, but its table serves to temporary…
0
votes
1 answer

Blaze persistence UpdatableEntityView as spring boot request body

I am trying to use blaze persistence UpdatableEntityView as the request body with spring boot. Following is the code for UpdatableEntityView @UpdatableEntityView @EntityView(DealListing.class) public interface DealListingUpdateView { @IdMapping …
Mayuran
  • 669
  • 2
  • 8
  • 39
1
2