BMP / CMP Entity Bean?

[Sahana Hussain]

Hi

If I've to use BLOB/CLOB data in my application, which EntityBean (BMP or CMP) will be more efficient?

Thanks
Sahana

[Paul Sturrock]

This is a bit of an unanswerable question: the BMP Entity bean will be more efficient if you implement the persistence code in a more efficient way than the container does.

I think the bigger question if you are worried about efficiency is why are you using Entity Beans?
[ November 30, 2006: Message edited by: Paul Sturrock ]

[Prabhu Venkatachalam]

As Paul said, In BMP you can do BLOB and CLOB operations as because as a Bean Developer you are responsible for writing SQL queries.

In CMP also it is possible, but it is upto Application Server you use. I know, web logic supports. But I really don't know about others.

[Sahana Hussain]

Thanks Paul/ Prabhu for your reply.

So, the BMP is a better solution as far as performance is concerned. I'm using EntityBean, as the existing application uses it. Otherwise, I can use SessionBean, which is a much better option, isn't it?

Thanks

[Prabhu Venkatachalam]

Paul said that,

the BMP Entity bean will be more efficient if you implement the persistence code in a more efficient way than the container does .

Means, for CMP container does persistence and you don't need to worry about it. But for BMP you need take care of everything.