Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.5

Mapping documents: Need help creating one for this scenario

Code between sessionFactory.openSession() and session.close(): N/A

Full stack trace of any exception that occurs: N/A

Name and version of the database you are using: SQL Server

The generated SQL (show_sql=true): N/A

Debug level Hibernate log excerpt: N/A


Hi,

I have a table with columns that look like this:

id, FirstName1, LastName1, FirstName2, LastName2, FirstName3, LastName3, FirstName4, LastName4

My Java class for mapping looks something like this:

public class Account {
String id;
Person[] persons;

public String getId() {
return id;
}

public void setId(String id) {
this.id = id;
}

public void setPersons(Person[] persons) {
this.persons = persons;
}

public void setPersons(int i, Person person) {
//some impl to add the person obj to that index;
}


public Person[] getPersons() {
return persons;
}



class Person {
String firstName;
String lastName;
}
}


I want to be able to set values of columns FirstName1, LastName1 to persons[0] in the Account object and FirstName2, LastName2 to persons[1] in the Account object etc.
I don't have the control to change either the object (generated based on schema) or the table (dba controlled)

Could you please help me as to how I can create mapping to map the columns to different person objects in the array.

Thanks.

Geeth