Skip to content

Tag: jpa

JPA Specification for Enum

My JPA Entity as an Enum field Where If I add a where condition with a specification what is the correct way to include Enums into Specification queries? Answer Try doing this:

JPQL issue updating records

Trying to update a record in a database but getting this error: Code below is responsible for inserting it Im not sure if there is a type issue with propId being a Long or if i have written the SQL paths wrong or both. Answer You’re trying to execute an SQL query as JPQL. There are a couple options to

Criteria API join with filter

So I am trying to replace the following native SQL with JPA Criteria Api: or The entities look a bit like this: I implemented a org.springframework.data.jpa.domain.Specification I can use together with a JpaSpecificationExecutor like: and But I only get one side of the join/select like: when I do: How do I ad…

Update statement is no query?

How do I define the update statement in the orm.xml. I have it as a named-query and everything works, but my teacher said that an update statement isn’t a query. I have tried a native query, but that wasn’t working. ORM-Type: Update Statement: Answer The term “query” is used rather amb…

Create custom finder with spring

I trying to implement a database with a many-to-many relationship.The database has been built, now we need queries to it. I’m using this article as an example: https://www.bezkoder.com/jpa-many-to-many/. When I create custom finder in Repository – server crushes at running. I have two Entity: Mass…