This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
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