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
posted 12 years ago
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.