Top "Jpql" questions

Spring Boot & JPA: Implementing search queries with optional, ranged criteria

This is an SSCCE, shows research, isn't a dupe and is on topic!!! Spring Boot REST service and MySQL here. …

spring-boot spring-data-jpa jpql querydsl query-by-example

JPQL ORDER BY clause with parameter

I'm trying to write a JPQL Query with an ORDER BY clause: query = "SELECT c FROM item ORDER BY c.…

hibernate orm jpa sql-order-by jpql

JPQL / QueryDSL: join subquery and get aliased column

I'm trying to get an average for a count on a groupBy by joining with a subquery. Don't know if …

subquery jpql querydsl

What to use: JPQL or Criteria API?

My Java application is using JPA for object persistence. The business domain is very simple (just three classes are persistent, …

java jpa jpa-2.0 jpql criteria-api

How to get the database time with JPQL?

with native SQL I get the database time with a statement like: SELECT CURRENT_TIMESTAMP with JPQL I get the …

java hibernate orm jpa jpql

Casting Integer to String in JPQL

I want to have a JPQL query that may look like: entityManager.createQuery("Select a.* from A a WHERE CAST(…

jpa jpa-2.0 jpql

org.hibernate.QueryException: JPA-style positional param was not an integral ordinal

I have the following JPQL request; @Query(value = "select req_t " + "from TransactionRelation tr " + "inner join tr.requestTransaction req_t " + "…

java hibernate jpa hql jpql

QueryDSL / JPQL : how to build a join query?

I've tried to read through the QueryDSL docs but I am still very confused. I'm accustomed to writing a lot …

jpa jpql querydsl

How to use JPA Enum in a JPQL where clause?

I have an enum as an attribute of an Entity. When I try to use the enum in a JPQL …

jpa jpql

Select nvl(max(c.EmployeeId),0) in JPQL?

I'm using oracle10g database and eclipselink, I need to obtain the last inserted key from the table so i've …

java persistence jpql ejbql