Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Multiple table queries

 
madhu bharathula
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Bring me the box labeled "thinking cap" ... and then read this tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!