Session session = getHibernateTemplate().getSessionFactory().getCurrentSession();

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
   <bean id="sybaseHibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
      <property name="properties">
         <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.SybaseDialect</prop>
            <prop key="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</prop>
            <prop key="hibernate.connection.url">jdbc:jtds:sybase://somedomain.com:5000/SomeDBName</prop>
            <prop key="hibernate.connection.username">user</prop>
            <prop key="hibernate.connection.password">password</prop>
            <prop key="hibernate.connection.pool_size">1</prop>
            <prop key="hibernate.connection.autocommit">false</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</prop>
            <prop key="hibernate.jdbc.fetch_size">512</prop>
            <prop key="hibernate.jdbc.batch_size">30</prop>
            <prop key="hibernate.hbm2ddl.auto">none</prop>
         </props>
      </property>
   </bean>
   
   <bean id="mappingResourcesList" class="org.springframework.beans.factory.config.ListFactoryBean">
      <property name="sourceList">
         <list>
            <value>com/somedomain/hibernate/DoSomething.hbm.xml</value>
         </list>
      </property>
   </bean>
   <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" lazy-init="false">
      <property name="mappingResources">
         <ref bean="mappingResourcesList"/>
      </property>
      <property name="hibernateProperties">
         <ref bean="sybaseHibernateProperties"/>
      </property>
   </bean>
   
   <bean id="myHibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate" lazy-init="true">
      <property name="sessionFactory" ref="mySessionFactory"/>
   </bean>
   
   <bean id="myDAOImpl" class="com.somedomain.MyDAO" lazy-init="true">
      <property name="hibernateTemplate" ref="myHibernateTemplate"/>
   </bean>
   
    <bean id="myTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager" lazy-init="true">
       <property name="sessionFactory" ref="mySessionFactory" />
    </bean>

    <bean id="myDAO" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" lazy-init="true">
       <property name="transactionManager" ref="myTransactionManager"/>
       <property name="target" ref="myDAOImpl"/>
       <property name="transactionAttributes">
          <props>
             <prop key="*">PROPAGATION_REQUIRED</prop>
          </props>
       </property>
    </bean>      
</beans>

public class MyTest extends TestCase {
   SessionFactory sessionFactory;
   private MyDAO myDAO;
   private HibernateTemplate hibTemplate;
   
   public void setUp() throws Exception{
      // Obtain DAO implementation from someplace (spring or whatever)
      myDAO = getMyDAO();
         
     // Obtain the hibernate template from someplace (spring or whatever)
     hibTemplate = getMyDAOHibTemplate();
     
     sessionFactory = hibTemplate.getSessionFactory();
 
     Session session = SessionFactoryUtils.getSession(sessionFactory, true);
     TransactionSynchronizationManager.bindResource(sessionFactory, new SessionHolder(session));
   }
   
   public void tearDown() throws Exception {
      Session session = sessionFactory.getCurrentSession();
      TransactionSynchronizationManager.unbindResource(sessionFactory);
      SessionFactoryUtils.releaseSession(session, sessionFactory);   
   }
   
   public void testSomething() throws Exception {
      // Code blows up here coz inside it has hibernateTemplate.getSessionFactory().getCurrentSession()
      myDAO.doSomething(); 
   }
   
}