hi,i'm a newbie of ejb now i wanna select out multi fields just like the traditional select query: select field1,field4,field7 from table where............. i looked it up by google but i found all the samples r like SELECT t.fieldX FROM table t (one field) or SELECT t FROM table t (all fields) so,in ejb,how can i select out some of the fields by ejb select method? thank in advance
Joined: Jun 27, 2003
You can not do this using EJB QL since every select query corresponds to a ejbSelect<METHOD>() you define in the entity bean and the return parameter of the ejbSelect<METHOD>() corresponds to the SELECT <FIELD> of the corresponding EJB QL statement. The best you can do is select all the fields. Cheers.