Tag: hibernate-mapping

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 using Hibernate 5.5.7 so I expect LocalDate to work. Answer date was not defined in the

hibernate multiple @OneToMany relationships generating more results in parent relationship

hibernate hibernate-mapping java jpa sql

I will start with the result. In the next image I am displaying the result content of company.userAccount. In the database I have only two companies assigned to the same user and 7 services attached to one of the companies. The generated query (simplified) is This will generate Expected result: I was expecting in the UserAccount to see only 2

Is possible to use an expression logic on @Formula which has a boolean field to compare dates?

hibernate hibernate-mapping java postgresql sql

I’m trying to know if the following example works with @Formula of hibernate, perhaps someone can help to solve the other ways, to use sql or queries. When I do that example get the following error: 2019-03-03 05:29:57.568 ERROR [service_a,4fedd46e4085e86f,4fedd46e4085e86f,false] 608 — [nio-8090-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: schema “table_a0_” does not exist Position: 5560 2019-03-03 05:29:57.581 INFO [service_a,4fedd46e4085e86f,4fedd46e4085e86f,false] 608 — [nio-8090-exec-1]