Hibernate 5.6.15.Final I have 2 entities with 1-to-1 relationship, both have audit fields "createdBy", "modifiedBy", "createdDate", "modifiedDate". class ...

I'm developing a Spring Boot application with Spring Data JPA, and I need to implement a repository method that fetches a random selection of questions from a Question table, filtered by a specific ...

The following code behaves differently between Hibernate 6.1 and 6.4 on postgresql: var rows = session .createNativeQuery("SELECT CAST('[1,2,3]' as jsonb) as data, 2 as id", Object[]....

Currently I am working on giving a label to my data. I will give the label to data that marked as highest on the resulting query. the problem is the label is not only for 1 case but multiple, and also ...

i try to use native query and i get above error: column "code" is of type smallint but expression is of type bytea, does anyone know how to fix it? i tried to use CAST to numeric but it ...

I have a database with a table that contains a column of type JSON. Retrieving all data from the table using the whole entity work without problems. But in a case when I use a native query with some ...

Given: Interface projection model with String getType(); Postgres 13; Hibernate+JPA+Spring data; Query filter: " where ... " + " and (COALESCE(:types) is null or model.type in (:...

@Query(value="select * from author a where a.last_name= ?1",nativeQuery = true) What does ?1 mean in the above query?