cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno René Santos <brunor...@holos.pt>
Subject Re: runtime shutdown
Date Tue, 31 May 2011 14:43:14 GMT
Hello all,


I am having a problem with the setFetchLimit on Oracle. When I use 
joined tables that have fields with the same name i get the error:

Error code 918, SQL state 42000: ORA-00918: column ambiguously defined

with a query similar to the next one:

select * from ( select tid.*, ROWNUM rnum from (
SELECT .... LEFT JOIN
ENTIDADE t1 ON (t0.ENTIDADE_ID_ENTIDADE = t1.ID_ENTIDADE) WHERE 
t0.FISC_ID_FISCALIZACAO = 6103 ORDER BY t0.DT_AVERIG)
  tid where ROWNUM <=15) where rnum > 0

Any way around this?

Thanx
Bruno

Mime
View raw message