Join table and Store procedure in CMP

Discussions

EJB design: Join table and Store procedure in CMP

  1. Join table and Store procedure in CMP (3 messages)

    I would like to know if I want to execute a sql statement that involve two table, how to do it in CMP, e.g. select * from A,B ? Also, how to execute the store procedure in CMP?
  2. Join table and Store procedure in CMP[ Go to top ]

    In CMP you dont write the SQL the container does. So you cant call a stored proc. You dont call anything the container does it all auto-magically. If you need to call a specific proc, use BMP.

    Dave Wolf
    Internet Applications Division
    Sybase


  3. Join table and Store procedure in CMP[ Go to top ]

    so how about the join table? how can I select the data from two tables in CMP?
  4. At present all the popular application servers support only one table per EJB.
    so, u better use BMP rather than CMP.
    I think there are some third party tools which will enable ur bean to support more than one table.
    if ur ben has to be portable go for BMP.
    thanks
    subbu