jpql

相关标签：javascript jquery android 多少钱 iPhone

JPQL query: selecting a single Boolean which is the AND of two of object's fields

Suppose that I have a JPA-annotated class called MyData with a primary identifier field (BigDecimal type called \"primaryID\"), and two Boolean fields called \"fieldA\" and \"fieldB\".开发者_JAVA百科W[详细]

2023-04-07 10:15 分类：问答
JPQL distinct with string function

I have a JPQL like this one: select distinct d from Depart开发者_如何学运维ment d left join fetch d.employees[详细]

2023-04-06 04:08 分类：问答
(elegantly) Querying for number of matching days in JPQL

In one of my projects I have the following situation: I have \"Availability Objects\" that have a starting date and an end date. Users query for these by defining a date range of their own.[详细]

2023-04-06 00:47 分类：问答
Need to convert an LEFT JOIN to JPQL

immagine following problem: somebody wants to buy a basket of fruit containing green fruits from Africa and South America but no red fruits from Africa.[详细]

2023-04-05 07:31 分类：问答
How to build JPQL queries when parameters are dynamic?

I wonder if there is a good solution to 开发者_运维问答build a JPQL query (my query is too \"expressive\" and i cannot use Criteria) based on a filter.[详细]

2023-04-03 06:10 分类：问答
How to custom query a ManyToMany table using Play, MySQL and Hibernate?

I am new to Play and Hibernate and working on a project. I love it so far! I ran into a new problem recently. I have a table of people. I then have a ManyToMany relationship in that classthat referen[详细]

2023-03-30 19:11 分类：问答
Inject attribute into JPQL SELECT clause

Let\'s depict the following use case: I have a JPQL Query which on the fly creates data objects using the new keyword. In the SELECT clause I would like to inject an attribute which is not known to th[详细]

2023-03-29 03:13 分类：问答
Hibernate automatically appending 1=2 to the generated query

Hibernate is generating the SQL for the following query : select pcp.id from PersistentContentProfile pcp where pcp.service.id = :service_id and exists(select 1 from Subscription s where s.contentPro[详细]

2023-03-26 00:39 分类：问答
Convert SQL statement 'LIKE' to JPQL statement

I want to write this SQL statement in eclipse JPQL query. It works in SQL but I\'m not sure how to write it in eclipse.[详细]

2023-03-25 17:19 分类：问答
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 that the right way to go at all but I couldn\'t anything about subqueries other than the mysema doc.[详细]

2023-03-25 17:04 分类：问答