mapping fields with a collection

jba · **Joined:** Fri Oct 28, 2005 9:08 am **Posts:** 12

I have a table with several fields that have the same properties (the same data types, the same sizes,...).
I have also other fields in this table.

Is it possible to map the fields that have the same properties directly with a collection ?

--> The fields that have the same properties must be directly mapped with a collection in the associated business object and the other fields are mapped normally.

rfulcher · **Joined:** Tue Mar 29, 2005 5:34 pm **Posts:** 19

Can you give an example of the tables?

jba · **Joined:** Fri Oct 28, 2005 9:08 am **Posts:** 12

example of a table :

NUMMSG NUMBER
ARGTBL VARCHAR
LIB1 VARCHAR
LIB2 VARCHAR
LIB3 VARCHAR
LIB4 VARCHAR
STAT VARCHAR

I want to map LIB1,LIB2,LIB3 and LIB4 with a collection (List or Map,...) and not an attribute for each field in table.

rfulcher · **Joined:** Tue Mar 29, 2005 5:34 pm **Posts:** 19

When you say a map you are wanting to load the data in LIB1,LIB2,LIB3 and LIB4 into a collection, so you want to store collection data into these fields?

jba · **Joined:** Fri Oct 28, 2005 9:08 am **Posts:** 12

I want this structure in the business object for the table I have described :

Integer nummsg;
String argtb;
Set lib;
String stat;

where lib contains LIB1,LIB2,LIB3 and LIB4.