<Context antiJARLocking="true" path="/homeWork" >
    <Resource name="jdbc/Sybase" auth="Container" type="javax.sql.DataSource"
        removeAbandoned="true" 
        removeAbandonedTimeout="60"
        maxActive="20" 
        maxIdle="10"
        minIdle="0"
        maxWait="10000"
        username="sa" 
        password="qwerty"
        driverClassName="com.sybase.jdbc3.jdbc.SybDriver"
        url="jdbc:sybase:Tds:localhost:5000/myTestDb"
        testOnBoeeow="true"
        validationQuery="SELECT 1"
        timeBetweenEvictionRunsMillis="20000"
        minEvictableIdleTimeMillis="30000"
        testWhileIdle="true"
    />
</Context> 

    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="java:comp/env/jdbc/Sybase"/>
        <property name="proxyInterface" value="javax.sql.DataSource"/>
         <property name="resourceRef" value="true" />             
    </bean>    
    
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:hibernate.cfg.xml" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.Sybase11Dialect</prop>
            </props>
        </property>
    </bean>

    
    @Autowired
    private SessionFactory sessionFactory;
    
    
    @Override
    public User getTerminalBySerialNumber(String serialNumber){
        
        return (User) sessionFactory.getCurrentSession()
                .load(Terminal.class, 2);
         
        
    }

package ru.home.homeWork.dao.impl;

import java.util.List;
import org.hibernate.SessionFactory;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import ru.home.homeWork.dao.UserDAO;
import ru.home.homeWork.domain.User;


@Repository(value="UserDAO")
public class UserDaoImpl implements UserDAO {
    
    protected final Logger logger = LoggerFactory.getLogger( getClass() );

    @Autowired
    private SessionFactory sessionFactory;
    
    @Override
    public User getTerminalBySerialNumber(String serialNumber){
        
        return (User) sessionFactory.getCurrentSession()
                .load(Terminal.class, 2);
         
    }
    
}

    <!-- Включаем опцию использования конфигурационных аннотаций (@Annotation-based configuration)-->
    <context:annotation-config />
        
    <!-- Определяем папки, в которых будем автоматически искать бины-компоненты (@Component, @Service)  -->
    <context:component-scan base-package="ru.home.homeWork.dao" />
    <context:component-scan base-package="ru.home.homeWork.dao.impl" />
    
    <!-- Настраивает управление транзакциями с помощью аннотации @Transactional -->
    <tx:annotation-driven transaction-manager="transactionManager" />
    
    <!-- Менеджер транзакций -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    
    <!-- ну чтож будем пытаться подружить Spring и JNDI Connection Pool -->
    <jee:jndi-lookup id="dataSource" jndi-name="jdbc/Sybase"/>
    
    
    <!-- чтож попробую еще разок приручить страшный Hibernate -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dS" />
        <property name="configLocation" value="classpath:hibernate.cfg.xml" />
        <!--<property name="con" value="org.hibernate.cfg.AnnotationConfiguration" /> -->
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.Sybase11Dialect</prop>
                <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>
                <prop key="hibernate.current_session_context_class">thread</prop>
            </props>
        </property>
    </bean>

     <resource-ref>
        <description>Connection Pool</description>
        <res-ref-name>jdbc/Sybase</res-ref-name>
        <res-type>javax.sql.Datasource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>

   User u = new UserDaoImpl().getTerminalBySerialNumber('uname');

@RequestMapping(value = "/{name}", method =  RequestMethod.GET)
public @ResponseBody object getBook(@PathVariable String name, Model model)

<!-- Настраивает управление транзакциями с помощью аннотации @Transactional -->
    <tx:annotation-driven transaction-manager="transactionManager" />
    
    <!-- Менеджер транзакций -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    
    <!-- ну чтож будем пытаться подружить Spring и JNDI Connection Pool -->
    <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
        <property name="jndiName" value="jdbc/Sybase"/>
        <property name="proxyInterface" value="javax.sql.DataSource"/>
        <property name="resourceRef" value="true" />             
    </bean>  
        
    <!-- чтож попробую еще разок приручить страшный Hibernate сприн автоматом не отдает сессии -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:hibernate.cfg.xml" />
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.dialect">org.hibernate.dialect.Sybase11Dialect</prop>
            </props>
        </property>
    </bean>