[EJB 3.0] - Re: EntityManager's Native Query & Paging Results - jboss-user

Thursday, 19 June 2008

How about changing your query to return the entire User object instead of just the ids?
Maybe like this:

SELECT USR FROM USER USR, USERWATCH UW WHERE  USR.ADDEDBYID =1 AND USR.COUNTRY = CAS
  | E WHEN (UW.COUNTRY is null) THEN USR.COUNTRY ELSE UW.COUNTRY END AND USR.ALIVE =
'A' 

See if that works.

View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4159291#...

Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[EJB 3.0] - Re: EntityManager's Native Query & Paging Results