jpqlopenjpa
OpenJPA query validation error
I'm running the following query:
SELECT new com.acme.Rooms.RoomStatistics(r.floor.floorId ,SUM(r.roomCapacity), COUNT(DISTINCT r.roomType.roomTypeId), COUNT(r.roomId)) FROM Room r where r.disabled = 0 group by r.floor.floorId
My RoomStatistics constructor's signature is
(int, long, long, long)
I've noted the similar questions (where COUNT(AppleTree) should be replaced with COUNT(AppleTree.id)). But it looks a bit different.
I have the following error in markers view:
No constructors can be found that match the argument types.
What's the reason of this error? Is there a way I can debug it?
Solution
I've disabled JPA validation. It compiles good and runs as expected without the validation. Sort of workaround, but I was unable to find better solution.
- How to select from subclass entity property using Spring Data / JPQL?
- Convert JPA query.getResultList() to MY Objects
- Casting Integer to String in JPQL
- JPQL Create new Object In Select Statement - avoid or embrace?
- Is Select EXISTS() possible in JPQL?
- What is the BINARY operator equivalent in JPQL？
- NamedBasicTypeImpl EntityValuedModelPart are in unnamed module of loader 'app'
- Spring Data JPA/Hibernate: JPQL constructor expressions- difference between using "new(..)" and not using it
- JPA: Query that returns multiple entities
- Finding items with a set containing all elements of a given set with jpql
- Upgrade from hibernate 5 to hibernate 6.4 causes a wrong generated SQL statement with a strange case when condition
- Why does one delete statement cascade, but not the other?
- Error: Parameter value did not match expected type
- Combining DISTINCT and ORDER BY when ordering by nested property with JPA
- JPQL and list of tuples as parameter for SELECT IN statements
- Collation in Hibernate v6 for ORDER BY clause of JPQL
- How to use multiple JOIN FETCH in one JPQL query
- Update value with join
- Error on compiling query: The abstract schema type 'entity' is unknown
- Is it possible to create a dynamic JPQL query?
- No converter found capable of converting from Integer type to CustomType entity
- JPA native query join returns object but dereference throws class cast exception
- How to join tables efficiently?
- How to fetch a OneToMany relation between two entities that are both ManyToOne-related to the root entity
- spring boot 3 - hibernate 6.1 - group by error with constructor expression query
- How to create an 'instance of' -like query in JPA 2.0?
- How to count row table in JPA Query
- How to escape '_' and '%' wildcards in Spring Data JPQL LIKE query?
- Missing IN or OUT parameter at index:: 5, jdbc and oracle in a java application
- Problems with making a query when using Enum in entity