[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

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 
 EclipseLink ,  http://www.oracle.com/technology/products/ias/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.