Eclipse Community Forums: EclipseLink » Enum literals in JPQL IN expressions

Home » Eclipse Projects » EclipseLink » Enum literals in JPQL IN expressions(How to use enum literals in JPQL IN expressions)

Enum literals in JPQL IN expressions [message #540481]

Wed, 16 June 2010 06:52

Eclipse User

Hi,

I am trying to use Enum literals in JPQL IN expressions to select all Phones with a specific PhoneType where PhoneType is a Java Enum. The JPQL query is:

SELECT p FROM Phone p WHERE p.type IN (my.package.PhoneType.Home, my.package.PhoneType.Work)

This results in a Syntax error while parsing the query.
Exception Description: Syntax error parsing the query [nonMobilePhones: SELECT p FROM Phone p WHERE p.type IN (my.package.PhoneType.Home, my.package.PhoneType.Work)], line 1, column 41: syntax error at [.].

Can anyone give me a hint how this query has to be formulated with correct syntax?

Thanks,
Thomas

Re: Enum literals in JPQL IN expressions [message #540524 is a reply to message #540481]

Wed, 16 June 2010 08:56

Eclipse User

Hello Thomas,

Try adding enums as parameters:
SELECT p FROM Phone p WHERE p.type IN ( :param1 , :param2 )

query.setParameter("param1",
my.package.PhoneType.Home);
query.setParameter("param2", my.package.PhoneType.Work)

Best Regards,
Chris

Re: Enum literals in JPQL IN expressions [message #540592 is a reply to message #540524]

Wed, 16 June 2010 11:32

Eclipse User

Hi Chris,

thanks for your hint. I think that would solve my problem. I am using another workaround at the moment. I've reformulated my query to:

SELECT p FROM Phone p WHERE p.type=my.package.PhoneType.Home OR p.type=my.package.PhoneType.Work

This works fine too but I would have preferred my first JPQL query.

The EJB 3.0 specification contains the following specification of IN expressions:

in_expression ::=
state_ﬁeld_path_expression [NOT] IN ( in_item {, in_item}* | subquery)

in_item ::= literal | input_parameter

The state_ﬁeld_path_expression must have a string, numeric, or enum value.
The literal and/or input_parameter values must be like the same abstract schema type of the
state_ﬁeld_path_expression in type. (See Section 4.12).

The sentence "literal values must be like the same abstract schema type of the ..." sounds like the usage of enum literals in IN expressions should be possible. Is there a way to use them in JPQL or is this perhaps not yet supported by EclipseLink?

Regards,
Thomas

Re: Enum literals in JPQL IN expressions [message #540888 is a reply to message #540481]

Thu, 17 June 2010 10:39

Eclipse User

What version of EclipseLink are you using? Could you try the 2.1 release.

Re: Enum literals in JPQL IN expressions [message #542541 is a reply to message #540888]

Fri, 25 June 2010 05:27

Eclipse User

Hi James,

sorry for the late reply.
We are currently using EclipseLink 2.0.2.
I've tested the scenario with EclipseLink 2.1. Seems that the problem has been fixed in that version. Everything works fine with EclipseLink 2.1.

Thanks for the hint.

Regards,
Thomas

Previous Topic:	Inherited OneToOne relationship not hydrated properly
Next Topic:	org.eclipse.persistence.exceptions.ValidationException thrown due to NegativeArraySizeException

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 22:36:48 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter