This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes newbie:select method problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "newbie:select method problem " Watch "newbie:select method problem " New topic
Author

newbie:select method problem

Dio Joestar
Greenhorn

Joined: Jun 29, 2003
Posts: 1
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
John Chandra
Greenhorn

Joined: Jun 27, 2003
Posts: 10
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.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: newbie:select method problem
 
It's not a secret anymore!