Saving a vector of object

inoel131081 · **Joined:** Sun Dec 21, 2003 9:18 pm **Posts:** 21

Hi,

I have read the "Collection" chapter in hibernate doc. And I still dont get how to save a vector / list of objects into a table.

OKay basically I have this table, this is just a mock SQL create statement to show how the table look like so the SQL statement might not work

Create table address (
ADDRESS_ID BIGINT AUTO_INCREMENT
USER_ID varchar2(50),
STREET VARCHAR2(300),

FOREIGN KEY USER_ID REFERENCES USER(USER_ID)
)

My user may have more than 1 addresses. And from my Form Class I will return a vector/list/arrray of addresses to be saved to the table.

Do I need to loop the vector/list and save the object 1 by 1 or Can I use HIbernate to persist the vector ?

My Address object will be something like this:

Code:

public class UserAddress implements AbstractPersister {

   ArrayList addrList = new ArrayList();
   
   /* (non-Javadoc)
    * @see AbstractPersister#getPersisterClass()
    */
   public Class getPersisterClass() {
      
      return UserAddress.class;
   }
         

   /**
    * @return
    */
   public ArrayList getAddrList() {
      return addrList;
   }

   /**
    * @param list
    */
   public void setAddrList(ArrayList list) {
      addrList = list;
   }

}

[/code]

max · **Posted:** Sun Jan 04, 2004 6:58 am

First - AbstractPersister seems like a bad name for an interface ? Is it part of your own persistenceengine or something ? (just curious)

Secondly, always use interface for collections (as per the docs)...use List, Set, SortedSet instead of ArrayList, HashSet, TreeSet.

Thirdly, what objects are you storing in addresslist ?

And why don't User's just have a List of Address's ?

inoel131081 · **Joined:** Sun Dec 21, 2003 9:18 pm **Posts:** 21

Hmm well abstract persister is just an Interface with one method getClass(). The reason I created this interface is because I am passing all the object that I want to save into a separate class call DBManager.

This class accepts any instance of AbstractPersister and save those instances using session.save(). Here is the code:

Code:

public static void save(AbstractPersister persister)
throws MappingException, HibernateException {

    Session s = getSession(persister);

    Transaction tx = s.beginTransaction();
    s.save(persister);
   
    tx.commit();
      
    closeSession();

}

private static Session getSession(AbstractPersister persister)
throws MappingException, HibernateException {

Configuration config = new Configuration().addClass(persister.getClass());

sessionFactory = config.buildSessionFactory();
session = new ThreadLocal();
Session s = (Session) session.get();

if (s == null) {
s = sessionFactory.openSession(getConnection());

}

return s;

}

Well I guess I can make the user class contains a vector/list of addresses.

Thanks for the hints ^__^

max · **Posted:** Sun Jan 04, 2004 12:08 pm

You are building a sessionfactory EVERY time you do a save ? That's a biiiig performance killer!

I would suggest that you go look at http://www.hibernate.org/152.html - just to get the basics in place.