<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">

	<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>

	<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl">

	</property>

	<property name="username" value="xxtz_sys"></property>

	<property name="password" value="xxtz_sys"></property>

</bean>



<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">

	<property name="dataSource" ref="dataSource"></property>

	<property name="hibernateProperties">

		<props>

			<prop key="hibernate.dialect">

				org.hibernate.dialect.Oracle10gDialect

			</prop>

			<prop key="hibernate.max_fetch_depth">1</prop>

			<prop key="show_sql">true</prop>

		</props>

	</property>

</bean>

private SessionFactory sessionFactory;

private Session session;



public void setSessionFactory(SessionFactory sessionFactory) {

	this.sessionFactory = sessionFactory;

}

protected Session getSession(){

	return sessionFactory.getCurrentSession();

}



public List<Cls> findByPage(final String hql, final Page page)

		throws Exception {

	List<Cls> list = new ArrayList<Cls>();

	session = getSession();

	Query query = session.createQuery(hql);

	query.setFirstResult(page.getStartrow());

	query.setMaxResults(page.getRowsperpage());

	list = query.list();

	return list;

}

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is java.lang.UnsupportedOperationException: The application must supply JDBC connections

	at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:440)

	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)

	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)

	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)

	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)