• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting unrequested nested query

 
Halcon Guatemala
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends,
I'm getting this error message from my application:



My POJO is:



And my mapping file:



I'm confused about why is generating this query:
select * from ( select this_.COD_MSJ as COD1_1_0_, this_.CANT_ERRORES as CANT2_1_0_, this_.CANT_REGLAS_APLICADAS as CANT3_1_0_, this_.CANT_SUBREGLAS_APLICADAS as CANT4_1_0_, ... ,this_.STATUS as STATUS1_0_, this_.USUARIO as USUARIO1_0_, this_.USUARIO_INVALIDO as USUARIO14_1_0_ from DUA_MSJ_AGENTE this_ ) where rownum <= ?


when I'd wait for it:
select this_.COD_MSJ as COD1_1_0_, this_.CANT_ERRORES as CANT2_1_0_, this_.CANT_REGLAS_APLICADAS as CANT3_1_0_, this_.CANT_SUBREGLAS_APLICADAS as CANT4_1_0_, ... ,this_.STATUS as STATUS1_0_, this_.USUARIO as USUARIO1_0_, this_.USUARIO_INVALIDO as USUARIO14_1_0_ from DUA_MSJ_AGENTE this_


Note I'm consulting the entire DuaMensaje class, without restrictions, only adding the class.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic