About expression

release

2.2.4

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 ...

 
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 ...

 
issue

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 ( ...

 
issue

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 ...

 
api-jdo

setResult(data)

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

 
api-jpa

selectCase()

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

 
forum_thread

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 ...

 
api-jdo

executeWithArray(parameters)

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

 
api-jpa

value(value)

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

 
api-jdo

addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameter)

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