• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Is there a way to write finder method by join of two table in websphere 4.0

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello all,
I need to have a finder method which will bring the result by joining of two tables.
Eg select T1.*, T2.* from Order T1 Customer T2 where T1.id = T2.id
Is there a facility to write such a finder in websphere 4.0?
Thanks & Have a nice day,
Samir
 
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Not in Container Managed Persistence, there isn't. In Bean Managed Persistence, of course you can write any SQL you like in your ejbFind... methods.
Kyle
------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.
 
Samir Bhagwat
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Kyle, your suggestions are really valuable.
 
Samir Bhagwat
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Kyle,
One last question about finder methods to you. We were using powertier application server and we are planning to shift to websphere 4.0.
In powertier one writes custom finder method in home interface and one implements that in Bean class. I don't see this in websphere 4.0 here one has to use finder helper classes for it. But we have currently implemented custom finder method which takes custom object as inputs and it returns Enumeration of Custom objects which are not EJBObject.
For e.g. Consider custom finder method declared in home interface as follows:
Enumeration findByFilter(FilterObject f).
Now this enumeration contains Objects of class Table which is not EJBObject.
First I don't see this type of implementation in websphere. Am I right? So to accomplish this feature I have to create another layer before calling Entity bean which will do this functionality. Am I right or webshepere will provide this funciotnality?
Thanks a lot,
Samir
 
Kyle Brown
author
Posts: 3892
5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You are right, WebSphere will not provide that functionality (finders that don't return the type of the remote interface). That is not in compliance with the EJB spec. So yes, you'll have to write another layer of software to be in compliance with the spec and make it work in WebSphere.
Kyle
------------------
Kyle Brown,
Author of Enterprise Java (tm) Programming with IBM Websphere
See my homepage at http://members.aol.com/kgb1001001 for other WebSphere information.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic