jpql
JPA updatable attribute and JPQL
I have made a couple of observations in my test and I am finding them hard to understand. My tests perform some basic update (or merge) operations on an Entity which has one of its attribute set as up[详细]
2023-04-13 04:03 分类:问答How to include NULL using Order By with JPQL?
I am trying to run such JPQL query: SELECT t1 FROM Table1 t1 ORDER BY t1.column1.id ASC Column1 as such implementation:[详细]
2023-04-12 23:41 分类:问答JQPL: Create new Object within the Query from multiple tables
I\'m currently trying to fetch data with JQPL. My Query looks like SELECT NEW com.test.CustomObject(t1.name, CASE WHEN(t2 IS 开发者_C百科NOT NULL) THEN true ELSE false END) FROM table1 t1, table2 t2[详细]
2023-04-12 11:15 分类:问答JPA: how do you get/print the JPQL query string behind a (typed) query after parameters have been set?
How do you get/print the JPQL query string behind a (typed) query, that is after parameters have been set? (e.g. for debugging purposes)[详细]
2023-04-12 03:31 分类:问答Usecases that really need Hibernate HQL over JPQL
I know JPQL is a subset of HQL. Are there any practical usecases (please give examples) that really need HQL specific features to be used (that means it is impossible or considerably difficult with[详细]
2023-04-12 01:09 分类:问答How to fetch length of a blob field with JPQL?
I have a JPA entity with a blob field in it. I want to write a JPQL query to fetch the l开发者_运维技巧ength of the entity\'s blob (I don\'t want to load the blob into the memory).[详细]
2023-04-11 22:47 分类:问答Date literals in Hibernate
I wonder how to use date literals in Hibernate query language. I did as follows in my JPA project (as Eclipselink the provider) and it works.[详细]
2023-04-11 17:09 分类:问答JPQL Left Join - Filter right rows while returning all left rows
I have a two entities that are related like so. public class User { @Column(name = \"I开发者_运维知识库D\")[详细]
2023-04-11 17:00 分类:问答Multiple JQPL fetch joins fail with Hibernate
Using Hibernate 3.6.7 and JPA 2, I cannot have two fetch joins in one query. Entity has a self referencing field called parent. localizedTexts is an @ElementCollection, of Java type of Map. entity.get[详细]
2023-04-08 10:44 分类:问答JPQL and clausole IN, not found
i have the following situation: In the dao class: ... Query q = em.createNamedQuery(\"myQuery\"); q.setPa开发者_如何学运维rameter(\"attr\", \"value\");[详细]
2023-04-08 03:42 分类:问答