[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: Re[eclipselink-users] ad all query alias problem

Verify that you have mapped the classes correctly.  If still having issues
please include you class files and mappings and the full query you are
using.



ercan wrote:
> 
> Hello;
> I have a named query like this in java as JPA.
> 
> select a from table1 a, table2 b where a.id=b.id ...
> ____
> 
> when eclipselink run this query ; generate under sql
> 
> select table1.id,table1.name,table1.surname from table1 t0,table2 t1
> 
> There are error "table1.surname" is invalid identifier. Because; table1 is
> not define as an alias, must be "t0.surname".
> 
> How can solve this...
> 


-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/Read-all-query-alias-problem-tp19149503p19181317.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.