File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes EJB and other Java EE Technologies and the fly likes Multiple table queries 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 "Multiple table queries" Watch "Multiple table queries" New topic
Author

Multiple table queries

madhu bharathula
Greenhorn

Joined: Oct 08, 2001
Posts: 15
Hi,
I have a report where I need to build a complex query with 5-6 tables left and right joins. My question is how to proceed this with EJB ?? Can i write a stateful session bean with one query referring to these tables ?? If i represent one entity bean per table, it is not going to serve my purpose anyway.
Thanks
Madhu
sandy gupta
Ranch Hand

Joined: Jan 30, 2001
Posts: 228
Write a stateless session bean instead or if u are so hell bent on writing a entity bean try to do it using a BMP


Adios
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Multiple table queries