Skip to content

Tag: hibernate

Spring boot and jpa query @P0

I’m trying to run the following query but I keep getting the syntax error @P0, I also tried not to use parameters but “?” and still not working, my guess is that the string is not placed under ” and it ends up just next to bulk, but as soon as I place the single quote I get the error

Undefined filter parameter in Hibernate

I am trying to map a LocalDate to a SQL Date, but am receiving this error: java.lang.IllegalArgumentException: Undefined filter parameter [afterDateLocal] I can’t provide a reproducible example, but here’s the code of the ListingRepositoryImpl: And the filters defined on the entity listing: I am u…

Order by 2 columns with case

I have a query that searches for user in 2 colums firstUser and secondUser and orders them by first and last name: But this first orders the cases when user is at first user then it orders the case when user is secondUser. Is ther a way to order the whole data by first name and last name no matter