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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multiple table queries