python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - jpql

CriteriaAPI + subquery creates wrong SQL (invalid identifier)

Not sure what I'm dong wrong so I'm guessing this is a bug. I'm trying to create a simple subquery but Eclipselink produces wrong SQL so the execution fails. Error message [EL Warning]: 2022-01-17 17:...
test-img

jansohn

jpa

eclipselink

jpql

criteria-api

Votes: 0

Answers: 0

How to write "JPQL" query with "IN" between SELECTs?

I wrote this JPQL query and expect a result as List<Question>: @Query("SELECT q FROM Question q WHERE q.id IN (SELECT qc.questions FROM QCard qc WHERE qc.id IN (SELECT ct.qCards FROM CTest ...
test-img

G T

java

spring-boot

spring-data

jpql

Votes: 0

Answers: 3

Latest Answer

Test your SQL query in an SQL-client (e.g. Squirrel, DbVisualizer, etc.). Assuming your foreign keys are named: question_id in table QCard card_id in table CTest you could have an SQL with subselect...
test-img

hc_dev

How can I retrieve all the children of a record in this Hibernate @ManyToOne relation?

I am working on a Spring Boot project using Spring Data JPA and Hibernate mapping. I have the following doubt about how can I implement the following query. I have an User entity class like this: @Ent...
test-img

AndreaNobili

spring-boot

hibernate

spring-data-jpa

jpql

hibernate-mapping

Votes: 0

Answers: 2

Latest Answer

You can do this List<User> findByParent_Id(Integer id); Or you can do this @Query("SELECT u FROM User u WHERE u.id = ?1") List<User> getReferredUsers(Integer id);
test-img

shazin

How to join on unnest columns using JPQL?

I have a simple query that I'd like to translate to JPQL / Hibernate. I'm using Postgres 14. select unnest(cast('{hello, world}' as text[])); The real query is a bit more complicated and will use the...
test-img

zemirco

sql

postgresql

hibernate

jpa

jpql

Votes: 0

Answers: 1

Latest Answer

i had the same problem as you but with a List<Integer> , the only solution that worked for me is to transform the List<Integer> to a String then in the native query i used unnest(string_to...
test-img

Lizinh

Posts

Questions

Blogs

Jobs