CODEWITHSUNDEEP
hqleclipselinkjpql
Timo Westkämper
Timo Westkämper

Reputation: 22190

Casts in JPQL with EclipseLink

Is it possible to use casts in JPQL? In HQL it seems to be supported

cast(... as ...), where the second argument is the name of a Hibernate type, and extract(... from ...) if ANSI cast() and extract() is supported by the underlying database

source : Hibernate reference

My target JPA provider is EclipseLink, so any EclipseLink specific solution is ok as well.

Upvotes: 2

Views: 3408

Answers (3)

Ondrej Bozek
Ondrej Bozek

Reputation: 11491

It should be supported using JPA 2.1 TREAT operator.

Upvotes: 1

Timo Westkämper
Timo Westkämper

Reputation: 22190

Literal downcasts in EclipseLink JPQL are currently not supported, but might be if the following issue gets resolved : https://bugs.eclipse.org/bugs/show_bug.cgi?id=315087

Upvotes: 1

MRalwasser
MRalwasser

Reputation: 15963

According to the specification of JPA/JPA2, JPQL is not supporting query casts. However, the most recent EclipseLink Release 2.1.0 does have a propritary support for downcasts in JPQL and expressions, please look here

Upvotes: 3

Related Questions