Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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

subject: Multiple table queries
Similar Threads
J2EE Design Question -- Am I On The Right Track?
possible to insert data into two tables from one sql?
How many entity beans to create for more than one table?
Entity bean representing a query
How Do I Insert records in multiple tables thru 1 SQL Query