-
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?Threaded Messages (3)
- Join table and Store procedure in CMP by Dave Wolf on November 28 2000 00:22 EST
- Join table and Store procedure in CMP by Carson Lam on November 28 2000 02:07 EST
- Join table and Store procedure in CMP by K V S Subrahmanyam K V S on November 28 2000 11:24 EST
- Join table and Store procedure in CMP by Carson Lam on November 28 2000 02:07 EST
-
Join table and Store procedure in CMP[ Go to top ]
- Posted by: Dave Wolf
- Posted on: November 28 2000 00:22 EST
- in response to Carson Lam
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
-
Join table and Store procedure in CMP[ Go to top ]
- Posted by: Carson Lam
- Posted on: November 28 2000 02:07 EST
- in response to Dave Wolf
so how about the join table? how can I select the data from two tables in CMP? -
Join table and Store procedure in CMP[ Go to top ]
- Posted by: K V S Subrahmanyam K V S
- Posted on: November 28 2000 11:24 EST
- in response to Carson Lam
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