Top "Jpql" questions

Adding IN clause List to a JPA Query

I have built a NamedQuery that looks like this: @NamedQuery(name = "EventLog.viewDatesInclude", query = "SELECT el FROM EventLog el WHERE …

java jpa jpql

JPQL IN clause: Java-Arrays (or Lists, Sets...)?

I would like to load all objects that have a textual tag set to any of a small but arbitrary …

sql orm jpa jpql named-query

IN-clause in HQL or Java Persistence Query Language

I have the following parametrised JPA, or Hibernate, query: SELECT entity FROM Entity entity WHERE name IN (?) I want to …

java hibernate jpa hql jpql

JPA Native Query select and cast object

I have got an Object Admin which extends User. By default both Objects are in the table User_ of my …

java sql jpa jpql

java.sql.SQLException: Fail to convert to internal representation

I'm trying execute following query: String query = "select entity, entity.id from Site entity"; List resultList = entityManager.createQuery(query).getResultList(); …

jpql

How To Define a JPA Repository Query with a Join

I would like to make a Join query using Jpa repository with annotation @Query. I have two tables: table user …

java jpa orm repository jpql

Spring Data JPA and Exists query

I'm using Spring Data JPA (with Hibernate as my JPA provider) and want to define an exists method with a …

java hibernate jpa spring-data jpql

Parameter in like clause JPQL

I am trying to write a JPQL query with a like clause: LIKE '%:code%' I would like to …

java jpa eclipselink jpql sql-like

How to create a JPA query with LEFT OUTER JOIN

I am starting to learn JPA, and have implemented an example with JPA query, based on the following native SQL …

java jpa jpql

JPA: JOIN in JPQL

I thought I know how to use JOIN in JPQL but apparently not. Can anyone help me? select b.fname, …

java jpa eclipselink jpql