<!-- Hibernate session factory -->
   <bean id="dataSource"
      class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <constructor-arg index="0" value="${ech.conn.driver}" />
      <constructor-arg index="1" value="${ech.conn.url}" />
      <constructor-arg index="2" value="${ech.conn.username}" />
      <constructor-arg index="3" value="${ech.conn.password}" />
   </bean>

   <bean id="sessionFactory"
      class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
      <property name="dataSource">
         <ref bean="dataSource" />
      </property>
      <property name="configLocation">
         <value>hibernate.cfg.xml</value>
      </property>
      <property name="configurationClass">
         <value>org.hibernate.cfg.AnnotationConfiguration</value>
      </property>
   </bean>

   <bean id="txManager"
      class="org.springframework.orm.hibernate3.HibernateTransactionManager">
      <property name="sessionFactory" ref="sessionFactory" />
   </bean>

   <tx:annotation-driven transaction-manager="txManager" />

<hibernate-configuration>
   <session-factory>
      <property name="hibernate.dialect">${ech.db.dialect}</property>
      <!-- Hibernate Search configuration -->
      <property name="hibernate.search.default.directory_provider">org.hibernate.search.store.FSDirectoryProvider</property>
      <property name="hibernate.search.default.indexBase">c:/temp/lucene/indexes</property>
      <!-- this will show us all SQL statements -->
      <property name="hibernate.show_sql">true</property>
      <mapping class="au.com.cgu.echelon.domain.sandbox.Address" />
      <mapping class="au.com.cgu.echelon.domain.sandbox.TestPolicy"></mapping>
      <mapping class="au.com.cgu.echelon.domain.sandbox.TestBroker" />
      <mapping class="au.com.cgu.echelon.domain.sandbox.TestInterestInsured" />
      <mapping class="au.com.cgu.echelon.domain.UserProfile" />
   </session-factory>
</hibernate-configuration>

@Entity
@Table( name = "SB_POLICY" )
@Indexed( index = "policies" )
public class TestPolicy implements Serializable, IImmortal
{
   private static final long serialVersionUID = 1L;

   @ManyToOne( cascade = CascadeType.ALL )
   @JoinColumn( name = "Broker_Id" )
   private TestBroker _broker;

   @OneToMany( cascade = CascadeType.ALL, fetch = FetchType.EAGER )
   @JoinColumn( name = "Policy_Id" )
   private List< TestInterestInsured > _interestInsureds = new ArrayList< TestInterestInsured >();

   @Column( name = "Policy_Number" )
   @Field( name = "policyNumber" )
   private String _policyNumber;

   @Id
   @Column( name = "Policy_Id" )
   @SequenceGenerator( name = "Policy_Sequence", sequenceName = "ECHELON.SQ_Policy", allocationSize = 10 )
   @GeneratedValue( strategy = GenerationType.SEQUENCE, generator = "Policy_Sequence" )
   @DocumentId
   private int _policyId;

// Getters and Setters omitted
}

@Transactional(propagation=Propagation.REQUIRES_NEW)
public TestPolicy storePolicy( final TestPolicy policy )
   {
      getCurrentSession().saveOrUpdate( policy );
      getCurrentSession().flush();
      return policy;
   }