How can I join two DB tables in an Entity bean?

Discussions

EJB programming & troubleshooting: How can I join two DB tables in an Entity bean?


  1.       Hi,

           How can I write an Entity bean which has to join two DB tables.What I meant to say is I want retrieve data from two DateBase tables in single Entity bean.

              Thank u,

                  Satya
  2. You have to use BMP
  3. Use a tool which supports this like CoCobase from Thought inc.

    Dave Wolf
    Internet Applications Division
    Sybase
  4. TOPLink does that quite well
  5. Weblogic uses Toplink to provide CMP. It is very vendor specific though, depends what kind of app server you are using.
  6. Yes, TopLink is very vendor specific and actually quite invasive to the application server. Thats why I like CoCo Base so much. Its not invasive, ports to every application server, and uses the EJB2 style CMP/BMP subclassiing model.

    We use it alot with Sybase EAServer

    Dave Wolf
    Internet Applications Division
    Sybase