[User.java]
 /** 
 * 
        @hibernate.class table="TBL_USER"
 * .. 
 * .. 
 * ... 
 */ 
 public class User { 
	 private Long id = new Long(-1); 
	 private String email; 
	 private String password; 
	
	 . 
	 . 
	 . 
	 /** 
	 * @return 
	 * 
        @hibernate.id column="PK_USER_ID" 
	 * 		 unsaved-value="-1" 
	 *              generator-class="native"
	 */ 
	 public Long getId() { 
		 return id; 
	 } 
	 ... 
	 /** 
	 * 
        @hibernate.property column="VC_EMAIL" 
	 * 			 type="string" 
	 * 			 update="false"
	 * 			 insert="true"
	 * 			 unique="true"
	 * 			 not-null="true"
	 * 			 length="82"
	 * @return 
	 */ 
	 public String getEmail() { 
		 return email; 
	 } 
	 /** 
	 * 
        @hibernate.property column="VC_PASSWORD" 
	 * 			 type="string" 
	 * 			 update="false"
	 * 			 insert="true"
	 * 			 unique="true"
	 * 			 not-null="true"
	 * 			 length="20"
	 * @return 
	 */ 
	 public String getPassword() { 
		 return password; 
	 } 
	 ... 
	 ... 
	 ... 
 } 
			
     

import net.sf.hibernate.HibernateException; 
import net.sf.hibernate.Session; 
import net.sf.hibernate.Query; 
import org.springframework.orm.hibernate.HibernateCallback; 
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
/** 
* @author Richard Hightower 
* ArcMind Inc. http://www.arc-mind.com 
*/ 
public class UserDAO extends HibernateDaoSupport{ 
  . 
  . 
  . 
  /** 
   * Demonstrates looking up a group with a HQL query 
   * @param email 
   * @return 
   */    
   public Group findGroupByName(String name) { 
     return (Group) getHibernateTemplate()
         .find("from Group g where g.name=?",name).get(0); 
   } 
   

  /** 
   * Demonstrates looking up a group and forcing it to 
   * populate users (relationship was lazy) 
   * @param email 
   * @return 
   */    
   public Group findPopulatedGroupByName(final String name) { 
     HibernateCallback callback = new HibernateCallback(){ 
      public Object doInHibernate(Session session) 
             throws HibernateException, SQLException { 
         Group group =null; 
         String query = "from Group g where g.name=?"; 
         Query queryObject = getHibernateTemplate()
	     .createQuery(session, query); 
         queryObject.setParameter(0, name); 
         group = (Group) queryObject.list().get(0); 
         group.getUsers().size();//force load 
         return group; 
         } 
        
      }; 
     
      return (Group) getHibernateTemplate().execute(callback); 
   } 
  . 
  . 
  . 
}    		

 <beans> 
    <!-- Datasource that works in any application server 
       You could easily use J2EE data source instead if this were 
       running inside of a J2EE container. 
    --> 
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> 
       <property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property>
       <property name="url"><value>jdbc:mysql://localhost:3306/mysql</value></property>
       <property name="username"><value>root</value></property> 
       <property name="password"><value></value></property> 
    </bean> 
    <!-- Hibernate SessionFactory --> 
    <bean id="sessionFactory" 
       class="org.springframework.orm.hibernate.LocalSessionFactoryBean"> 
       <property name="dataSource"><ref local="dataSource"/></property> 
      
       <!-- Must references all OR mapping files. --> 
       <property name="mappingResources"> 
          <list> 
              <value>net/sf/hibernateExamples/User.hbm.xml</value> 
              <value>net/sf/hibernateExamples/Group.hbm.xml</value> 
              <value>net/sf/hibernateExamples/Role.hbm.xml</value>               
              <value>net/sf/hibernateExamples/ContactInfo.hbm.xml</value> 
          </list> 
       </property> 
      
       <!-- Set the type of database; changing this one property will 
          port this to Oracle, MS SQL etc. --> 
       <property name="hibernateProperties"> 
          <props> 
           <prop key="hibernate.dialect">net.sf.hibernate.dialect.MySQLDialect</prop>
          </props> 
       </property> 
    </bean> 
   
    <!-- Pass the session factory to our UserDAO --> 
    <bean id="userDAO" class="net.sf.hibernateExamples.UserDAO"> 
       <property name="sessionFactory"><ref local="sessionFactory"/></property>
    </bean> 
   
 </beans> 			

[User.java]
/** 
* @author Richard Hightower 
* ArcMind Inc. http://www.arc-mind.com 
* @hibernate.class table="TBL_USER" discriminator-value="2" 
* @hibernate.discriminator column="USER_TYPE"
* 
* @hibernate.query name="AllUsers" query="from User user order by user.email asc"
* 
* @hibernate.query name="OverheadStaff" 
* query="from Employee employee join employee.group g 
* where g.name not in ('ENGINEERING','IT')"
* 
* @hibernate.query name="CriticalStaff" 
* query="from Employee employee join employee.group g 
* where g.name in ('ENGINEERING','IT')"
* 
* @hibernate.query name="GetUsersInAGroup" 
* query="select user from Group g join g.users user"
* 
* @hibernate.query name="GetUsersNotInAGroup" 
* query="select user from User user where user.group is null"
* 
* @hibernate.query name="UsersBySalaryGreaterThan" 
* query="from User user inner join user.contactInfo info where info.salary > ?1"
* 
* @hibernate.query name="UsersBySalaryBetween" 
* query="from User user join user.contactInfo info 
* where info.salary between ?1 AND ?2"
* 
* @hibernate.query name="UsersByLastNameLike" 
* query="from User user join user.contactInfo info where info.lastName like ?1"
* 
* @hibernate.query name="GetEmailsOfUsers" 
* query="select user.email from Group g join g.users as user where g.name = ?1"
* 
*/ 
public class User {
 . 
 . 
 . 			
     

				[UserDAO.java]
	 /** 
	 * Demonstrates a query that returns a String. 
	 */                
	 public String[] getUserEmailsInGroup(String groupName){ 
		 List emailList = 
		 getHibernateTemplate().findByNamedQuery("GetEmailsOfUsers"); 
		 return (String []) 
			 emailList.toArray(new String[emailList.size()]); 
	 } 
	 /** 
	 * Demonstrates a query that returns a list of Users 
	 * 
	 * @return A list of emails of all of the users in the authentication system. 
	 * 
	 */                
	 public List getUsers(){ 
		 return getHibernateTemplate().findByNamedQuery("AllUsers"); 
	 } 
      /** 
	 * Demonstrates passing a single argument to a query. 
	 * 
	 * @return A list of UserValue objects. 
	 * 
	 */                    
	 public List getUsersBySalary(float salary){ 
	   return getHibernateTemplate() 
	       .findByNamedQuery("UsersBySalaryGreaterThan", 
	            new Float(salary)); 
	 } 
	 /** 
	 * Demonstrates passing multiple arguments to a query 
	 * 
	 * @return A list of UserValue objects. 
	 * 
	 */                    
	 public List getUsersBySalaryRange(float start, float stop){ 
                return getHibernateTemplate() 
		 .findByNamedQuery("UsersBySalaryBetween", 
			 new Object[] {new Float(start), new Float(stop)}); 
	 } 
	
     

				[UserDAO.java]
 /** 
 * @param group 
 */ 
 public void addGroup(Group group) { 
	 getHibernateTemplate().save(group); 
	
 } 
        [UserDAOTest.java]
 public void testAddGroupOfUsers(){ 
	 Group group = new Group(); 
	
	 for (int index=0; index < 10; index++){ 
		 User user = new User(); 
		 user.setEmail("rick"+index+"@foobar.com" ); 
		 user.setPassword("foobar"); 
		 group.addUser(user); 	
	 } 
	
	 group.setName("testGroup"); 
	
	 userDAO.addGroup(group); 
	 assertNotNull(group.getId()); 
	
	 Group group2 = userDAO.findPopulatedGroupByName("testGroup"); 
	
	 assertEquals("testGroup",group2.getName()); 
	 assertEquals(10, group2.getUsers().size()); 
	 String email = ((User)group2.getUsers().get(0)).getEmail(); 
	 assertEquals("rick0@foobar.com", email); 
	
 } 
     

				[applicationContext.xml]
 <!-- Pass the session factory to our UserDAO --> 
   <bean id="userDAOTarget" class="net.sf.hibernateExamples.UserDAOImpl"> 
	 <property name="sessionFactory"><ref local="sessionFactory"/></property> 
   </bean> 
	
   <bean id="transactionManager" 
   	 class="org.springframework.orm.hibernate.HibernateTransactionManager"> 
      <property name="sessionFactory"><ref bean="sessionFactory"/></property> 
   </bean> 
   <bean id="userDAO"
     class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean"> 
	 <property name="transactionManager"><ref local="transactionManager"/></property> 
	 <property name="target"><ref local="userDAOTarget"/></property> 
	 <property name="transactionAttributes"> 
		 <props> 
			 <prop key="addGroup">PROPAGATION_REQUIRED</prop> 
		 </props> 
	 </property> 
    </bean>