Eclipse Community Forums: EclipseLink » EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found 'AS'

Home » Eclipse Projects » EclipseLink » EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found 'AS'

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

EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found 'AS' [message #1698987]

Fri, 19 June 2015 10:24

Ponic Pan

Messages: 3
Registered: January 2015

Junior Member

I have the following JPQL query

SELECT DISTINCT a.productName AS prod_id,   a.prodDesc FROM 
ProductList a  LEFT JOIN a.masterList u  LEFT JOIN u.details
e WHERE u.productName=?1 and a.isActive='A'

But I am getting the following error

line 1, column 34: syntax error at [AS]. Internal Exception: line 1:34: expecting "from", found 'AS'

What is the reason for this?

Appreciate any insight into this?

Report message to a moderator

Re: EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found [message #1699085 is a reply to message #1698987]

Sat, 20 June 2015 15:36

Chris Delahunt

Messages: 1389
Registered: July 2009

Senior Member

What version are you using, and does it work if you remove the keyword 'DISTINCT'?

Report message to a moderator

Previous Topic:	Customize instantiation of EntityListener
Next Topic:	Generating annotated ( @NamedPLSQLStoredFunctionQuery / @NamedPLSQLStoredProcedureQuery) queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:50:37 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter