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?
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.
Internet Applications Division
so how about the join table? how can I select the data from two tables in CMP?
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.