<bean id="dataSource" ...> ... </bean>

<bean id="sessionFactory" class="...LocalSessionFactoryBean">

<property name="mappingResources">

<list>

<value>employee.hbm.xml</value>

</list>

</property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.dialect">....DB2Dialect</prop>

</props>

</property>

<property name="dataSource">

<ref bean="dataSource"/>

</property>

</bean>

SessionFactory sessionFactory = (SessionFactory) ctx.getBean("sessionFactory");

HibernateTemplate hibernate = new HibernateTemplate(sessionFactory);

Employee e = (Employee) hibernate.load(Employee.class, "000330");

e.setFirstName("BOB");

hibernate.update(e);

List employees = hibernate.find("from app.Employee");

List list = hibernate.find(

"from app.Employee e where e.lastName=?",

"LEE",

Hibernate.STRING);

List list = hibernate.find(

"from app.Employee e where e.lastName=? and e.firstName=?",

new String[] { "BOB", "LEE" },

new Type[] {Hibernate.STRING , Hibernate.STRING });

List list = (List) hibernate.execute(new HibernateCallback() {

public Object doInHibernate(Session session)

throws HibernateException {

List result = session.find("from app.Employee");

// do some further stuff with the result list

return result;

}

});