Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
In-Reply-To: <opsmlo27skyw38vq@st1-kl.softline.local>
Subject: RE: Arrays in OM classes
To: "Apache Torque Users List" <torque-user@db.apache.org>
Message-ID: 
 <OF52CE86E0.D7A7782A-ONC1256FB0.004AE8D5-C1256FB0.004F1E0A@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Tue, 22 Feb 2005 15:24:09 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII


Hi,

You can overwrite the doSelect Methods of your choice in ContactPeer to
access the PhoneNumbers. This automatically loads the phone numbers for the
Contact. For example, in ContactPeer you could use

public List doSelect(Criteria criteria, Connection connection) {
  List result = super.doSelect(criteria, connection);
  Iterator contactIt = result.iterator();
  while(contactIt.hasNext()) {
    Contact contact = (Contact) contactIt.next();
    contact.getPhoneNumbers(connection);
  }
  return result;
}

Do not forget to overwrite the doSelect methods with other signatures if
you use them.

   Thomas

"Kintzel Levente" <kintzel.levente@softech.ro> schrieb am 22.02.2005
14:29:21:

>
>    Hi!
>
> I have a simple design question.
> I want to creat a database with contact information (id, name, adress,
> phone no), but the contact can have more than one phonenumber. The
> simplest solution for this problem is the normalization and to create 2
> tables (one with id, name and adress and one with the id and phone
> numbers), but I want to be able to load automatically all phone  numbers

> when I load the data of one contact. In other words to have an array in
> the generated ContactOM class. Is that possible? Or there are some design

> solutions for this problem?
>
> Thank You
>
>         Levente Kintzel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org