Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found 'AS'
EclipseLink Alias Name Error - Internal Exception: line 1:34: expecting "from", found 'AS' [message #1698987] Fri, 19 June 2015 10:24 Go to next message
Ponic Pan is currently offline Ponic PanFriend
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?
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 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1380
Registered: July 2009
Senior Member
What version are you using, and does it work if you remove the keyword 'DISTINCT'?
Previous Topic:Customize instantiation of EntityListener
Next Topic:Generating annotated ( @NamedPLSQLStoredFunctionQuery / @NamedPLSQLStoredProcedureQuery) queries
Goto Forum:
  


Current Time: Wed Mar 03 03:44:37 GMT 2021

Powered by FUDForum. Page generated in 0.01333 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top