Using getHibernateTemplate() problem

[Prasath Premkumar]

Hi,

I'm a newbie to Spring. May be this question sound a childish, but still i need some help in this problem.

In a DAO which extends HibernateDaoSupport, i have a method named findByProperty in which i call

getHibernateTemplate().find(queryStr, value);

The problem is i get a nullPointerException for getHibernateTemplate() method.
I have defined a sessionFactory in application-context.xml. Also the DAO has a reference to the sessionFactory bean through sessionFactory property in the application-context.xml file.

Wt can be the problem or do i miss anythg???

I need some guidence in this problem.

thanks in advance.

[David Newton]

I'd recommend posting at least the relevant Spring config (and always UseRealWords, which you mostly did until the very end ;)

[Prasath Premkumar]

Hi david,

I'm sorry about typing short words, here after i'll stick to your advice. Sorry again.

Here is the relevent part of my application-context.xml file:

    
        <bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="configLocation"
			value="/WEB-INF/hibernate.cfg.xml">
		</property>
	</bean>

       <bean id="UsersDAO" class="com.acheivers.db.UsersDAO">
		<property name="sessionFactory">
			<ref bean="sessionFactory" />
		</property>
       </bean>
 

Here is the part of my Hibernate.cfg.xml which maps to the Users table for which UsersDAO is written

   
 <hibernate-configuration>

	<session-factory>
		<property name="dialect">
			org.hibernate.dialect.MySQLDialect
		</property>
		<property name="connection.url">
			jdbc:mysql://localhost:3306/acheivers
		</property>
		<property name="connection.username">root</property>
		<property name="connection.driver_class">
			com.mysql.jdbc.Driver
		</property>
		<property name="myeclipse.connection.profile">
			mysql-connector-5.0.5
		</property>
		<mapping class="com.acheivers.db.Users" />

	</session-factory>

</hibernate-configuration>
 

In acheivers-servlet.xml (dispatcher servlet) i have defined this :

    
 <bean name="jsp/login" class="com.acheivers.web.controllers.LoginController" />
 

In the login controller i'm using the UsersDAO like this:

   
 UsersDAO usd = new UsersDAO();
 List<Users> users = usd.findByProperty(str, str);
 

In the UsersDAO the above called method is defined like this:

    
     public List findByProperty(String propertyName, Object value) {

		try {
			String queryString = "from Users as model where model."
					+ propertyName + "= ?";
			return [b]getHibernateTemplate().find(queryString, value);[/b]
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	 }

But i get a nullPointer on getHibernateTemplate() method. Why is that?? do i miss anythg???

I read that HibernateDAOSupport can create a HibernateTemplate if sessonFactory is specified. I have defined sessionFactory in application-context.xml. Is that all i need to do??

Please guide me and give an explanation. Sample codes will be much more helpful.

Thanks a lot.

[Eduardo Bueno]

Where is your dataSource? Add it to your sessionFactory as a property:

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

[Prasath Premkumar]

Hi,

Thanks for the suggestion, i tried it but still it is throwing a nullPointerException for getHibernateTemplate() method.

Anyway, the database is defined in hibernate.cfg.xml and passed to the sessionFactory bean as a property, so do i need to set the dataSource property again???

I'm confused with why getHibernateTemplate() throwing a NullPointerException..... The sessionFactory is defined in application-context.xml, so the sessionFactory is set, isnt it? Or are there any sessionFactory bean injection to be done in order to get the HibernateTemplate???

Thanks.

[Eduardo Bueno]

Nevermind what I said, haven't seen the dataSource properties configured in your hibernate-config. I have no idea why hibernateTemplate is null; have you tried not to use it? By the way, it's use is discouraged.