Hi

I am using mysql 4.1 and I have a class as folllows:-
@Entity
@Table(name = "PortedNumberRelayTasks")
public class PortedNumberRelayTask implements Serializable {
......



}

The relevent section is
@Column(name="portednumberList")
@Type(type="text")
private List portednumberlist;

Basically I wanted to store a List into the database and then be able to get at the list when it was required. Mysql does not have an array type per se and so I am not sure how I should go about this? Currently I created my column as a text field, but have tried blob as well. I am also not sure if its possible to do such a thing

I have another Entity called PortedNumber and this List is a List of PortedNumbers.

Do I have to have another table and store the id link to it such as
table PortedNumberRelayTask
has a field called ListId int

and then have some other table PortedNumberList
Listid
blob the PortedNumber
eg
1, PortedNumber1
1,PortedNumber2
1,PortedNumber3 etc?

Hi,

You need to create a relationship between the entities, or alternatively you could use the @CollectionOfElements annotation. Seems as the list you want to persist is a list of entities, i would recommend that you take the relationship approach to store the list.

Cheers,

Andy

if you really want to store it in a single column (or a proprietary format), you can create a custom UserType

or if your list (and it's elements) are serializable you can store it in it's serialized form in one column without creating an UserType. Annotate it with @Type(type="serializable").

Octav