About jpql

71-80 of 145Refresh
Forum
11

JPQL query to get entities that does not have a child entity in their child entities

JPQL query to get entities that does not have a child entity in their child entities
Issue
11

JPQL support for mapped by (inverse) collections

JPQL support for mapped by (inverse) collections
Forum
11

KEY() / VALUE() not recognized in JPQL??

KEY() / VALUE() not recognized in JPQL??
JPA Doc
5

javax.persistence.Query

javax.persistence Interface Query Subinterfaces: TypedQuery Interface used to control query execution. Since: JPA 1.0 See Also: TypedQuery Parameter Learn how to define and use JPA/JPQL queries in ... .0 ObjectDB Notes: Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA
JPA Doc
3

getFirstResult()

Method javax.persistence.Query int getFirstResult() The position of the first result the query object was set to retrieve. Returns 0 if setFirstResult was not applied to the query object. Returns: position of the first result Since: JPA 2.0 Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA manual.
JPA Doc
3

javax.persistence.Parameter

javax.persistence Interface Parameter Subinterfaces: ParameterExpression Type for query parameter objects. Since: JPA 2.0 See Also: Query TypedQuery Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA manual. String getName() Return the parameter name, or null
JPA Doc
3

javax.persistence.TypedQuery

javax.persistence Interface TypedQuery Superinterfaces: Query Interface used to control the execution of typed queries. Since: JPA 2.0 See Also: Query Parameter Learn how to define and use JPA/JPQL queries in Chapter 4 of the ObjectDB/JPA manual.   int executeUpdate() Execute an update or delete
Forum
3

how to query by properties of onetomany relations? (Error 990)

. However, this query is invalid. You cannot navigate through collections in JPQL directly. You have to use ... ) {             this.name = name;         }     }    } This is of course an extension to the standard JPQL ... but it is JPA portable. ObjectDB can enforce using standard JPQL by setting the following query hint
Forum
3

Issue with Casting / Joins

out of here?? thanks so much Alex You may try using a string based (JPQL) query instead of a criteria query for this purpose, since ObjectDB supports casting in a string based query (as an extension to JPQL). Hi ... ? About the variable for iterating map values.. Yes I am aware that this isn't supported in JPQL
Forum
2

Explorer in 2.3

to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive ... that could be extended and may be also supported during editing. Only expressions that are valid in queries (JPQL ... , not a JPQL expression in a query. For example, I double click on a String field in an entity. Right