how to get session from spring-config.xml

[indu iyengar]

Hi all, am getting null pointer exception when try to access session --

Session session = sessionFactory.openSession();

dispatcher servlet code is :::

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
  	
  	<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
        <property name="prefix" value="/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    	
   <bean name="/login.htm" class="com.controllers.LoginController">
    	<property name="validator"><ref bean="loginValidator"/></property>
     	<property name="formView" value="LoginForm"></property>
     	<property name="successView" value="LoginSuccess"></property>
     	<property name="commandName" value="loginStudent"></property>
     	<property name="commandClass" value="com.bean.LoginStudent"></property>
     	<property name="sessionForm" value="true"></property> 
   </bean>
   
   <bean id="loginValidator" class="com.validate.LoginValidator"></bean>
   
   <bean id="messageSource" 
        class="org.springframework.context.support.ResourceBundleMessageSource">
     <property name="basename" value="messages">
     </property>
  </bean>
  
  <!--  ********************** DB (Hibernate) details ********************************* -->
  
  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="password" value="admin"></property>
		<property name="url" value="jdbc:mysql:///test"></property>
		<property name="username" value="root"></property>
   </bean>
   		
	<bean id="mysessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
	   <property name="dataSource"><ref local="dataSource"></ref></property>
	   <property name="mappingResources" value="com/mappings/LoginStudent_map.hbm.xml"></property>
	   <property name="hibernateProperties">
	   <props>
	   		<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
	   		<prop key="hibernate.hbm2ddl.auto">update</prop>
	   		<prop key="hibernate.show_sql">true</prop>
		</props>
	    </property>
		</bean>
	
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory">
            <ref bean="mysessionFactory"/>
        </property>
    </bean>
</beans>

code to access session

private SessionFactory sessionFactory;
	
	public void setSessionFactory(SessionFactory sessionFactory) {
		System.out.println(" B4 set SF .... ");
		this.sessionFactory = sessionFactory;
		System.out.println(" SF .........");
	}

	public boolean checkID(String stid, String stpw)
	{
		System.out.println("in impl.."+stid+" --- "+stpw);
		//sessionFactory = new Configuration().configure().buildSessionFactory(); /// am not building any hibernate.cfg.xml.. all the details are in dispatcher servlet only..

		Session session = sessionFactory.openSession(); ////  ... here null pointer exception is coming 
		System.out.println(" got session >>>>>>>>>>");

[Ran Pleasant]

Indu

I don't see any configuration where the "mysessionFactory" bean is being injected into the sessionFactory field, thus you get the Null exception. Therefore, you need to lookup the bean "mysessionFactory" and set it in the sessionFactory field.

Ran Pleasant

[indu iyengar]

Thanks Ran ... got it