| 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.