No SessionFactory specified

[lthomas]

I have an application where in Iam using Tapestry - Hibernate - Spring.
Following are my Class files

BaseDAO.java

package jeevan.spring.dao;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.SessionFactoryUtils;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class BaseDAO extends HibernateDaoSupport
{
	public Session openSession()
	{
		return SessionFactoryUtils.getSession(getSessionFactory(),false);
	}

	public Query getQuery(String query) throws HibernateException
	{
		Session session = this.openSession();
		return session.createQuery(query);
	}
}

FnuDAOImpl

package jeevan.spring.dao.impl;

import java.util.List;
import java.util.Vector;

import org.springframework.orm.hibernate3.HibernateTemplate;

import jeevan.spring.*;
import jeevan.spring.dao.BaseDAO;
import jeevan.spring.dao.IFnuDao;

public class FnuDAOImpl extends BaseDAO implements IFnuDao
{
	HibernateTemplate hibTemplate;
	
	public FnuDAOImpl()
	{
		hibTemplate = new HibernateTemplate();
	}
	
	public Vector getStatus()
	{
		Vector vStatus = new Vector(4, 4);

		CacheObject cObj = null;
		Status obj = null;
		System.out.println("Result Value");
		List result = hibTemplate.loadAll(Status.class);
			//this.getQuery("from Status ").list();
		
		System.out.println("Result Value"+result.size());
		for(int i=0; i < result.size();i++){
			obj = (Status)result.get(i);
			cObj = new CacheObject();
			cObj.setCacheId(obj.getId());
			cObj.setCacheCode(obj.getCode());
			vStatus.addElement(cObj);	
		} 
		
		return vStatus;
	}
}

Status.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
	<class name="jeevan.spring.Status" table="FNU_STATUS" dynamic-insert="false" dynamic-update="false">
	        
		<id name="id" column="STATUS_ID" type="long">
			<generator class="assigned"/>
		</id>
		<property name="code" column="STATUS_CODE"/>
	</class>
</hibernate-mapping>

applicationContext.xml

<?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="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="hibernate.connection.driver_class">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="hibernate.connection.url">
			<value>jdbc:oracle:thin:@192.168.1.18:1521:regac</value>
		</property>
		<property name="hibernate.connection.username">
			<value>fnur</value>
		</property>
		<property name="hibernate.connection.password">
			<value>fnur</value>
		</property>
		<property name="current_session_context_class">
			<value>thread</value>
		</property>
		<property name="cache.provider_class">
			<value>org.hibernate.cache.NoCacheProvider</value>
		</property>
		<property name="show_sql">
			<value>true</value>
		</property>
		<property name="hibernate.dialect">
			<value>org.hibernate.dialect.Oracle9Dialect</value>
		</property>
		<property name="mappingResources">
			<list>
				<value>jeevan/spring/Status.hbm.xml</value>
			</list>
		</property>
	</bean>
	
	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>
	
	<bean id="userDAO" class="jeevan.spring.dao.impl.FnuDAOImpl">
		<property name="hibernateTemplate">
			<ref local="hibernateTemplate" />
		</property>
	</bean>
	
</beans>

Status.java

package jeevan.spring;

import java.io.Serializable;

public class Status implements Serializable
{
	private static final long serialVersionUID = 7526472295622776147L;
	private long _id;
	private String _code;

	public Status()
	{
		_id = Integer.MIN_VALUE;
		_code = ""; 
	}

	public long getId()
	{
		return _id;
	}

	public void setId(long Value)
	{
		_id = Value;
	}

	public String getCode()
	{
		return _code;
	}

	public void setCode(String Value)
	{
		_code = Value;
	}
	
	public void print()
	{
		System.out.println("StatusId = " + _id);
		System.out.println("StatusCode = " + _code);
	}

}

IFnuDAO.java

package jeevan.spring.dao;

import java.util.Vector;

public interface IFnuDao
{
	public Vector getStatus();
}

TestJava.java

package jeevan;
import java.util.Vector;

import jeevan.spring.dao.IFnuDao;
import jeevan.spring.dao.impl.FnuDAOImpl;

public class TestJava
{
	Vector vStatus;
	
	public static void main(String srgs[])
	{
		IFnuDao fnuDao = new FnuDAOImpl();
		
		System.out.println(fnuDao.getStatus().size());
	}
}

While running TestJava.java file I am getting the following error message:

Result Value
java.lang.IllegalArgumentException: No SessionFactory specified
	at org.springframework.util.Assert.notNull(Assert.java:90)
	at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:293)
	at org.springframework.orm.hibernate3.SessionFactoryUtils.getSession(SessionFactoryUtils.java:194)
	at jeevan.spring.dao.BaseDAO.openSession(BaseDAO.java:13)
	at jeevan.spring.dao.BaseDAO.getQuery(BaseDAO.java:18)
	at jeevan.spring.dao.impl.FnuDAOImpl.getStatus(FnuDAOImpl.java:28)
	at jeevan.TestJava.main(TestJava.java:15)
Exception in thread "main"

[Marten Deinum]

In your test class you are just instantiating a FnuDAOImpl, it doesn't get injected with the sessionfactory and hibernate template. You need to create a ApplicationContext and retrieve a instance from that.

I strongly suggest you read the chapter about testing with the Spring Framework in the referenceguide.

Also I would change your class to something like this:

package jeevan.spring.dao.impl;

import java.util.List;
import java.util.Vector;

import org.springframework.orm.hibernate3.HibernateTemplate;

import jeevan.spring.*;
import jeevan.spring.dao.BaseDAO;
import jeevan.spring.dao.IFnuDao;

public class FnuDAOImpl extends BaseDAO implements IFnuDao
{
	public FnuDAOImpl() {}
	
	public Vector getStatus()
	{
		Vector vStatus = new Vector(4, 4);

		CacheObject cObj = null;
		Status obj = null;
		System.out.println("Result Value");
		List result = getHibernateTemplate().loadAll(Status.class);
			//this.getQuery("from Status ").list();
		
		System.out.println("Result Value"+result.size());
		for(int i=0; i < result.size();i++){
			obj = (Status)result.get(i);
			cObj = new CacheObject();
			cObj.setCacheId(obj.getId());
			cObj.setCacheCode(obj.getCode());
			vStatus.addElement(cObj);	
		} 
		
		return vStatus;
	}
}

Your baseclass extends HibernateDaoSupport which already has a HibernateTemplate for you. No need to create a new one.

Also why invoke SessionFactoryUtils yourself. The HibernateDaoSupport class has a method which does that for you. I would suggest to call getSession(false) instead of the SessionFactoryUtils method.

[lthomas]

Thanks for your reply.
Can you tell me how to create a ApplicationContext and retrieve a instance from that?
I have a file called applicationContext.xml

<?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="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="hibernate.connection.driver_class">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="hibernate.connection.url">
			<value>jdbc:oracle:thin:@192.168.1.18:1521:regac</value>
		</property>
		<property name="hibernate.connection.username">
			<value>fnur</value>
		</property>
		<property name="hibernate.connection.password">
			<value>fnur</value>
		</property>
		<property name="current_session_context_class">
			<value>thread</value>
		</property>
		<property name="cache.provider_class">
			<value>org.hibernate.cache.NoCacheProvider</value>
		</property>
		<property name="show_sql">
			<value>true</value>
		</property>
		<property name="hibernate.dialect">
			<value>org.hibernate.dialect.Oracle9Dialect</value>
		</property>
		<property name="mappingResources">
			<list>
				<value>jeevan/spring/Status.hbm.xml</value>
			</list>
		</property>
	</bean>
	
	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>
	
	<bean id="userDAO" class="jeevan.spring.dao.impl.FnuDAOImpl">
		<property name="hibernateTemplate">
			<ref local="hibernateTemplate" />
		</property>
	</bean>
	
</beans>

Also can you provide me with the links for "testing with the Spring Framework in the referenceguid"

Liju

[Marten Deinum]

The link was already there, just click it .

Well the easiest way would be to extend the Spring TestCase and let that work its magic for you. However you are not using JUnit for as far as I can see so someting like the following would do.

package jeevan;
import java.util.Vector;

import jeevan.spring.dao.IFnuDao;
import jeevan.spring.dao.impl.FnuDAOImpl;

public class TestJava {


	Vector vStatus;
	
	public static void main(String srgs[]) {

	    ApplicationContext context = new ClasspathXmlApplicationContext("path-to-your-applicationContext.xml");
	    IFnuDao fnuDao = (IFnuDao) context.getBean("userDAO");		
		System.out.println(fnuDao.getStatus().size());
	}
}

[lthomas]

Thanks.

Can you check applicationContext.xml file?
I think Iam going wrong somewhere.

<?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="oracleDS" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="hibernate.connection.driver_class">
			<value>oracle.jdbc.driver.OracleDriver</value>
		</property>
		<property name="hibernate.connection.url">
			<value>jdbc:oracle:thin:@192.168.1.18:1521:regac</value>
		</property>
		<property name="hibernate.connection.username">
			<value>fnur</value>
		</property>
		<property name="hibernate.connection.password">
			<value>fnur</value>
		</property>
		<property name="current_session_context_class">
			<value>thread</value>
		</property>
		<property name="cache.provider_class">
			<value>org.hibernate.cache.NoCacheProvider</value>
		</property>
		<property name="show_sql">
			<value>true</value>
		</property>
		<property name="hibernate.dialect">
			<value>org.hibernate.dialect.Oracle9Dialect</value>
		</property>
	</bean>
	
	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
<ref local="oracleDS"/>
</property>
	<property name="mappingResources">
			<list>
				<value>jeevan/spring/Status.hbm.xml</value>
			</list>
		</property>
	</bean>
	
	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory">
			<ref bean="sessionFactory"/>
		</property>
	</bean>
	
	<bean id="userDAO" class="jeevan.spring.dao.impl.FnuDAOImpl">
		<property name="hibernateTemplate">
			<ref local="hibernateTemplate" />
		</property>
	</bean>
	
</beans>

[Marten Deinum]

Well I could if I knew what was wrong or not working.

[lthomas]

Iam getting following Error:

log4j:WARN No appenders could be found for logger (org.springframework.beans.factory.xml.XmlBeanDefinitionReader).
log4j:WARN Please initialize the log4j system properly.
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'oracleDS' defined in class path resource [applicationContext.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'hibernate.connection.driver_class' of bean class [org.springframework.jdbc.datasource.DriverManagerDataSource]: Nested property in path 'hibernate.connection.driver_class' does not exist; nested exception is org.springframework.beans.NotReadablePropertyException: Invalid property 'hibernate' of bean class [org.springframework.jdbc.datasource.DriverManagerDataSource]: Bean property 'hibernate' is not readable or has an invalid getter method: Does the return type of the getter match the parameter type of the setter?
org.springframework.beans.NotWritablePropertyException: Invalid property 'hibernate.connection.driver_class' of bean class [org.springframework.jdbc.datasource.DriverManagerDataSource]: Nested property in path 'hibernate.connection.driver_class' does not exist; nested exception is org.springframework.beans.NotReadablePropertyException: Invalid property 'hibernate' of bean class [org.springframework.jdbc.datasource.DriverManagerDataSource]: Bean property 'hibernate' is not readable or has an invalid getter method: Does the return type of the getter match the parameter type of the setter?
org.springframework.beans.NotReadablePropertyException: Invalid property 'hibernate' of bean class [org.springframework.jdbc.datasource.DriverManagerDataSource]: Bean property 'hibernate' is not readable or has an invalid getter method: Does the return type of the getter match the parameter type of the setter?
	at org.springframework.beans.BeanWrapperImpl.getPropertyValue(BeanWrapperImpl.java:634)
	at org.springframework.beans.BeanWrapperImpl.getNestedBeanWrapper(BeanWrapperImpl.java:535)
	at org.springframework.beans.BeanWrapperImpl.getBeanWrapperForPropertyPath(BeanWrapperImpl.java:513)
	at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:709)
	at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:844)
	at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:871)
	at org.springframework.beans.BeanWrapperImpl.setPropertyValues(BeanWrapperImpl.java:860)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:926)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:727)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:336)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:223)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:277)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:312)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:80)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:65)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:56)
	at jeevan.TestJava.main(TestJava.java:17)
Exception in thread "main"

[Marten Deinum]

You are trying to set hibernate properties on the DriverManagerDataSource which it doesn't have. It isn't related to hibernate it is just a simple implementation of the DataSource interface.

Specify the needed properties on the LocalSessionFactoryBean and the ones concerning the datasource (url/password/user) on the DriverManagerDataSource .

[lthomas]

Thanks for your help!!!
I got the Result.
By the way my name is Liju Thomas (from India)
Iam working as a Programmer in JAVA.
I was new to this Spring Technology.

Thank You Again!!!