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)

Show: Today's Messages :: Show Polls :: Message Navigator

Enum literals in JPQL IN expressions [message #540481]

Wed, 16 June 2010 06:52

Thomas
Messages: 10
Registered: June 2010

Junior Member

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

Report message to a moderator

[Message index]

		Enum literals in JPQL IN expressions By: Thomas on Wed, 16 June 2010 06:52
		Re: Enum literals in JPQL IN expressions By: Chris Delahunt on Wed, 16 June 2010 08:56
		Re: Enum literals in JPQL IN expressions By: Thomas on Wed, 16 June 2010 11:32
		Re: Enum literals in JPQL IN expressions By: James Sutherland on Thu, 17 June 2010 10:39
		Re: Enum literals in JPQL IN expressions By: Thomas on Fri, 25 June 2010 05:27

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 01:59:36 EDT 2013