jpql
JPA: Query that returns multiple entities
I\'m writing a JPQL query that joins across three tables. In my resultlist I would like to get all three entities per matching row (hope that makes sense).[详细]
2023-03-24 01:51 分类:问答java hibernate query.list returns empty list
I am using hibernate with JPA annotations and Jboss transaction manager I build the session factory open up a session and create a query when i use query.li开发者_运维技巧st it always returns me an em[详细]
2023-03-23 17:53 分类:问答How to access a OnetoMany join table in JPQL?
I want to write a lttl complicated query in JPQL where i access a OneToMany Join table. I get QuerySyntaxException: Pan_PanRes is not mapped.[详细]
2023-03-22 19:47 分类:问答Is Select EXISTS() possible in JPQL?
I\'m trying to run a query that checks if some conditions are true and returns a simple boolean result as output.What makes it slightly tricky is that one of the conditions is to test fo开发者_StackOv[详细]
2023-03-22 06:45 分类:问答persist a 1 column table using JPA
I\'ve got a table with only one column. It\'s an Id How can I persist it with JPA? I\'ve tried a entityManager.persist(new OneColumnTable());[详细]
2023-03-20 09:07 分类:问答Write & Call user-defined function in JPQL?
开发者_JS百科Is it possible to write & call user-defined function in JPQL?It\'s not supported by JPA specification itself, however, some JPA implementations may provide such an extension.[详细]
2023-03-19 20:49 分类:问答New Object in JPQL and selects
Why would a JPQL query Select new Foo(X,Y) from X join X.y as Y Where ... produces more than o开发者_如何学Pythonne sql? 1 for main select and 1 each for X and Y? Let\'s guess. One query that sele[详细]
2023-03-19 04:05 分类:问答How to perform a Non-Polymorphic JPQL query with JPA 1.0?
imagine i have 3 Entities, Basic <- Sub <- SubSub. I want to select Basic and Sub but not SubSub[详细]
2023-03-19 04:04 分类:问答In JPQL, how do you access properties of named parameters?
I\'m using Hibernate 3.5.4-Final. I want to pass an entity as a parameter of a named query, and then access a persisted property of that named parameter in that query. I want to do this:[详细]
2023-03-18 06:54 分类:问答Translate SQL query to JPQL
Following query: SELECT kinder.kindID, kinder.kindName, kinder.kindVorname FROM kinder INNER JOIN (SELECT kindName FROM kinder[详细]
2023-03-17 12:10 分类:问答