File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Multiple table queries

madhu bharathula

Joined: Oct 08, 2001
Posts: 15
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.
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

I agree. Here's the link:
subject: Multiple table queries
jQuery in Action, 3rd edition