how to save collection object into database

[Saikiran Madhavan]

Hi,

We are having an object which has a collection (Set), i would like to save the set whenever i save that particular Class.

The Set has got many-to-many relation with another class.

The hbm file for that particular class and the database table is given below:-

 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.optum.secureMessaging.model">
   <class name="Mailbox">
  
  <id name="mailboxId" type="java.lang.Long">
            <column name="mailbox_id" />
            <generator class="native"></generator>
        </id>
        
        <!-- entry for Administrator Account id -->
        
        <property name="adminaccountId" type="java.lang.Long">
            <column name="administrator_account_id"  />
        </property>
        
        <property name="name" type="java.lang.String">
            <column name="name" length="255" />
        </property>
        
        <property name="description" type="java.lang.String">
            <column name="description" length="255" />
        </property>
            <property name="notificationEmail" type="java.lang.String">
            <column name="notification_email_address" length="255" />
        </property> 
        
  [B]<!-- SET OF ACCOUNTS -->
        <set name="accounts" table="account_mailbox" lazy="false" inverse="true" cascade="all" sort="natural" >
<key column="mailbox_id"/>
<many-to-many class="Account" column="account_id" />
</set>[/B]
<!-- SET OF FOLDERS -->
         <set name="folders" cascade="all" inverse="true" lazy="false" sort="natural">
<key column="mailbox_id" />
<one-to-many class="Folder" />
</set>
        
  </class>
  
  <query name="Mailbox.Name">FROM Mailbox WHERE name=?</query>
  
  <query name="Mailbox.MailId">FROM Mailbox WHERE mailbox_id=?</query>
  
    
  
   <!-- This query will return the count of the number of accounts with
the specified address. However, it returns a list in which the first
element in the list is an Long object representing the count -->
<query name="Mailbox.CountByName"><![CDATA[
      select count(*) FROM Mailbox WHERE name=?)]]>
   </query>
   
   <query name="Mailbox.AdminAccountId"> FROM Mailbox WHERE administrator_Account_id=?</query>
   
  <sql-query name="Mailbox.MatchMailboxesToMessage">
    <return-scalar column="name" type="string"/>
  <![CDATA[
    select M.name
    from Mailbox M,
    Folder F,
    Folder_Message FM
    where M.mailbox_id = F.mailbox_id
    and F.folder_id = FM.folder_id
    and FM.message_id = ?
    ]]>
</sql-query>

<sql-query name="Mailbox.MatchMailboxesToAccount">    
<return class="Mailbox"></return>
  <![CDATA[    
    SELECT *
FROM mailbox
WHERE mailbox.administrator_account_id=? 
AND mailbox.mailbox_id NOT IN (
                SELECT mailbox.mailbox_id
FROM account, account_mailbox, mailbox 
WHERE account.address=?
 AND account.account_id=account_mailbox.account_id
 AND account_mailbox.mailbox_id = mailbox.mailbox_id
AND mailbox.administrator_account_id=?)

   ]]>
</sql-query> 
    
</hibernate-mapping>

the database table is as below:-

Mailbox table

mailbox_id
name
description
administrator_admin_id
notification_email

Account_Mailbox
account_id
mailbox_id

now when i save or update Mailbox object i have to save the accounts set along with it.

can anyone help me out in this regard

cheers
sai

[Arun Kumarr]

fill the set with account_mailbox pojos and save the mailbox pojo. What happens? Aren't the account_mailbox details persisted in the link table. Do you see sany exceptions?