CMP with Mutiple tables

[sameer_menon]

Hey guys,
Can i create on entity bean on columns from mutiple tables, like we get the effect of having views created on more than one table.
please bear if i sound silly. I am a novice to JBoss and EJB .

[dsundstrom]

This is not currently supported.

[vickyk]

Hi,
Which app server do support this?
The basic definition of the Entity Bean says that the Bean instance represents the row of the table.So one table can be mapped to the one Entity Bean.
regards
Vicky

[dsundstrom]

I don't know what other app servers support this as I don't use any other appservers. The EJB spec doesn't say anything about the acutal storage of entity beans other than it must be persistent, so storage in multiple tables is perfectly legal, but not required.

[aloubyansky]

I know that Borland's app server supports entity beans mapped to several tables.
Once, on Borland's seminar I asked several questions on the topic such as how a new instance mapped to different tables is created? How do they deal with primary keys? and so on.
But the answer I got was "well... this question is covered in our special training..." :)

alex

[tux2]

Hi Guys!
BEA Weblogic 7 definitely suppurts multiple table mapping. Here's a link to the docs:

http://edocs.bea.com/wls/docs70/ejb/cmp.html#1093392

....but I never gave a trial on my own. I hope it helps.

Stefan

[dsundstrom]

I've had people tell me that, but it's not a priority. Almost no one needs this feature. As I said last time this discussion came up, if someone want to pay me to develop it right now, I will. Otherwise, they'll have to do it them selves, or wait until it get aroung to it.