About expression



Release date: 2011-05-09 Download (5.09 MB) Binary:  objectdb-2.2.4.zip You should start by following a  tutorial or reading the manual ...


Setting and Tuning of JPA Queries

Explains various JPA query settings - result range, flush and lock.... page number ( 0 for the first page), the following expression retrieves the results for a specified page: ... ; These methods can be invoked in a single expression with getResultList getResultList() TypedQuery's ...


Alias not used in ORDER BY

Hi, I am doing something simple like final Root<T> from = criteria.from(T.class) final Path<?> path = from.get("someStringProperty") final Expression<String> upperPath = builder.upper((Expression<String>) path); upperPath.alias("TEST"); criteria.multiselect(from, path); criteria.orderBy(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like ... get ( "someStringProperty" ) final Expression<String> upperPath = builder. upper ( ( Expression<String> ) path ) ; upperPath. alias ( ...


JPQL Case Statements (JPA 2.0)

JPQL 2.0 adds support of CASE statements in queries for conditional expressions (similar switch/case/default in Java), following the SQL syntax. Case statements are currently not supported by ObjectDB. JPA Feature Version: 1.04 Priority: Normal Status: Active Replies: 1 Type:  JPA Feature ...



Specifies what type of data this query should return.(Method of javax.jdo.Query)



Create a general case expression.(Method of javax.persistence.criteria.CriteriaBuilder)


substring works with string but not with char

i want to select all entities whose name starts with a specific letter, i can use this query with a string parameter select f from Foo f where substring(f.name, 1, 1) = ?1 but when i use a char, the query does not return anything. i think it should also be possible to use char/Character types, do you agree? ... this comparison is valid, since the type of the left side expression is String and the type on the right side expression (the parameter) is Character . In ObjectDB as in Java ...



Execute the query and return the filtered Collection.(Method of javax.jdo.Query)



Add an argument to the coalesce expression.(Method of javax.persistence.criteria.CriteriaBuilder.Coalesce)


addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameter)

Add a subquery to this query.(Method of javax.jdo.Query)