Hi,
It's perfectly possible to persist an Entity Bean over more than one table
using CMP. The solution is views.
Create a view having the required data from muliple tables. Then treate this
view as a target table.
Whatever is possible doing with this view directly...it is possible with
having CMP entity beans too..I have tested it
with WL5.1 and it works.
If we talk about oracle particularly, it states the concept of "key-preserved
tables". (i guess it holds for other databases too).A table is key preserved
if every key of the table can also be a key of the result of the join. So, a
key-preserved table has it's keys preserved through a join.
And then specs state, you can update, insert, or delete from a join view
provided there is one and only one key-preserved table in the join.
The point i want to make is...this the restriction is from the database side
not from the Entity bean(AS) side(atleast with WL5.1)...
Regards,
Harvinder
-----Original Message-----
From: Rein Reezigt [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 1:33 AM
To: [EMAIL PROTECTED]
Subject: persisting an Entity Bean over more than one table using CMP
Hello,
I was wondering if it is possible to persist an Entity Bean over more than
one table using CMP. For example 3 attributes go in table A and 2 attributes
go in table B.
I can see this might come in handy when having some kind of inheritance in
your architecture.
Thanks,
Rein Reezigt
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
