Join table and Store procedure in CMP

Discussions

EJB design: Join table and Store procedure in CMP

Bookmark and Share Get thread feed

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

    • Posted by: Carson Lam
    • Posted on: November 27 2000 23:02 EST
    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?
    Reply to this

    Threaded Messages (3)

  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


    Reply to this Reply to original

  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?
    Reply to this Reply to original

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

    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


    Reply to this Reply to original