db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adam.s.allga...@exxonmobil.com
Subject Re: Arrays in OM classes
Date Tue, 22 Feb 2005 14:50:30 GMT
Typically, your query of the Contact table would look like this:
      Criteria criteria = new Criteria();
      criteria.add...... //add your criteria here
      List results = ContactPeer.doSelect(criteria);  //get the list of
results
      Contact contact = (Contact)results.get(0); //get the first result
      List phoneNumbers = contact.getPhoneNumbers();  //get the list of
phone numbers associated with this contact

The "contact.getPhoneNumbers()" method will be automatically generated with
your OM if your phone number table has a foreign key reference to the
contact table.

It's slick stuff.

Adam




                                                                                         
                           
                      "Kintzel Levente"                                                  
                           
                      <kintzel.levente@soft          To:      torque-user@db.apache.org
                             
                      ech.ro>                        cc:                              
                              
                                                     Subject: Arrays in OM classes       
                           
                                                                                         
                           
                      02/22/05 07:29 AM                                                  
                           
                      Please respond to                                                  
                           
                      "Apache Torque Users                                               
                           
                      List"                                                              
                           
                                                                                         
                           
                                                                                         
                           




   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


Mime
View raw message