unable to save

[fabian verbeek]

Hi,

I'm trying to use hibernate 4 and spring 3 but when i want to save, i receive this next trace
[DEBUG] [http-bio-8080-exec-7 07:24:08] (UserService.java:add:55) Adding new usr 22 déc. 2012 19:24:08 org.apache.catalina.core.StandardWrapperValve invoke GRAVE: Servlet.service() for servlet [CreationUser] in context with path [/starterSpring] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause java.lang.NullPointerException at com.starterSpring.services.user.UserService.add(UserService.java:58) at com.starterSpring.controller.user.CreationUser.addUSer(CreationUser.java:33) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132) at org.springframework.web.servlet.mvc.method.annotation. ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) at org.springframework.web.servlet.mvc.method.annotation. RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:746) at org.springframework.web.servlet.mvc.method.annotation. RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:687) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:915) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:822) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:796) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:680)

it concerns this line: Session session = sessionFactory.getCurrentSession(); in this class

package com.starterSpring.services.user;
import java.util.List;

import javax.annotation.Resource;

import org.apache.log4j.Logger;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import modele.DAO.beans.user.*;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@Service("userService")
@Transactional
public class UserService {
protected static Logger logger = Logger.getLogger("service");
	
	@Resource(name="sessionFactory")
	private SessionFactory sessionFactory;
	
	/**
	 * Retrieves all usrs
	 * 
	 * @return a list of usrs
	 */
	public List<User> getAll() {
		logger.debug("Retrieving all usrs");
		
		// Retrieve session from Hibernate
		Session session = sessionFactory.getCurrentSession();
		
		// Create a Hibernate query (HQL)
		Query query = session.createQuery("FROM  usr");
		
		// Retrieve all
		return  query.list();
	}
	
	/**
	 * Retrieves a single usr
	 */
	public User get( Integer id ) {
		// Retrieve session from Hibernate
		Session session = sessionFactory.getCurrentSession();
		
		// Retrieve existing usr first
		User usr = (User) session.get(User.class, id);
		
		return usr;
	}
	/**
	 * Adds a new usr
	 */
	public void add(User usr) {
		logger.debug("Adding new usr");
		
		// Retrieve session from Hibernate
		Session session = sessionFactory.getCurrentSession();
		
		// Save
		session.save(usr);
	}
	
	/**
	 * Deletes an existing usr
	 * @param id the id of the existing usr
	 */
	public void delete(Integer id) {
		logger.debug("Deleting existing usr");
		
		// Retrieve session from Hibernate
		Session session = sessionFactory.getCurrentSession();
		
		// Retrieve existing usr first
		User usr = (User) session.get(User.class, id);
		
		// Delete 
		session.delete(usr);
	}
	
	/**
	 * Edits an existing usr
	 */
	public void edit(User usr) {
		logger.debug("Editing existing usr");
		
		// Retrieve session from Hibernate
		Session session = sessionFactory.getCurrentSession();
		
		// Retrieve existing usr via id
		User existingusr = (User) session.get(User.class, usr.getUserId());
		
		// Assign updated values to this usr
		existingusr.setUserLogin(usr.getUserLogin());
		existingusr.setUserPswd(usr.getUserPswd());
		existingusr.setUserNom(usr.getUserNom());
		existingusr.setUserPrenom(usr.getUserPrenom());
		existingusr.setUserAdresse(usr.getUserAdresse());
		existingusr.setUserCp(usr.getUserCp());
		existingusr.setUserEmail(usr.getUserEmail());
		existingusr.setUserTel(usr.getUserTel());
		existingusr.setUserGsm(usr.getUserGsm());

		// Save updates
		session.save(existingusr);
	}
}

My class User:

package modele.DAO.beans.user;
import java.text.SimpleDateFormat;
import java.util.Date;
/*import javax.validation.constraints.Pattern;
import javax.validation.constraints.Max;
import javax.validation.constraints.Min;
import javax.validation.constraints.Size;*/
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
/**
 * User generated by hbm2java
 */
@Entity
@Table(name = "user")
public class User implements java.io.Serializable {
	@Id
	@Column(name = "user_id")
	@GeneratedValue
	private Integer userId;
	//@Size(min = 1, message="trou dcul c'est faux")
	@Column(name = "user_login")
	private String userLogin;
	@Column(name = "user_pswd")
	private String userPswd;
	@Column(name = "user_nom")
	private String userNom;
	@Column(name = "user_prenom")
	private String userPrenom;
	@Column(name = "user_adresse")
	private String userAdresse;
	@Column(name = "user_cp")
	private String userCp;
	//@Pattern(regexp="[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}",message="${message[valEmail]}")
	@Column(name = "user_email")
	private String userEmail;
	@Column(name = "user_tel")
	private String userTel;
	@Column(name = "user_gsm")
	private String userGsm;
	@Column(name = "user_createDate")
	private Date userCreateDate;
	@Column(name = "user_isAdmin")
	private boolean userIsAdmin;
	@Column(name = "user_isValide")
	private boolean userIsValide;

	public User() {
	}
	
	public User(String userLogin, String userPswd, String userNom,
			String userPrenom, String userAdresse, String userCp,
			String userEmail, String userTel, String userGsm,
			Date userCreateDate) {
		this.userLogin = userLogin;
		this.userPswd = userPswd;
		this.userNom = userNom;
		this.userPrenom = userPrenom;
		this.userAdresse = userAdresse;
		this.userCp = userCp;
		this.userEmail = userEmail;
		this.userTel = userTel;
		this.userGsm = userGsm;
		this.userCreateDate = userCreateDate;
	}

	public Integer getUserId() {
		return this.userId;
	}

	public void setUserId(Integer userId) {
		this.userId = userId;
	}

	/**
	 * @param userLogin
	 * @param userPswd
	 * @param userNom
	 * @param userPrenom
	 * @param userAdresse
	 * @param userCp
	 * @param userEmail
	 * @param userTel
	 * @param userGsm
	 * @param userCreateDate
	 * @param userIsAdmin
	 * @param userIsValide
	 */
	public User(String userLogin, String userPswd, String userNom,
			String userPrenom, String userAdresse, String userCp,
			String userEmail, String userTel, String userGsm,
			Date userCreateDate, boolean userIsAdmin, boolean userIsValide) {
		super();
		this.userLogin = userLogin;
		this.userPswd = userPswd;
		this.userNom = userNom;
		this.userPrenom = userPrenom;
		this.userAdresse = userAdresse;
		this.userCp = userCp;
		this.userEmail = userEmail;
		this.userTel = userTel;
		this.userGsm = userGsm;
		this.userCreateDate = userCreateDate;
		this.userIsAdmin = userIsAdmin;
		this.userIsValide = userIsValide;
	}

	public String getUserLogin() {
		return this.userLogin;
	}

	public void setUserLogin(String userLogin) {
		this.userLogin = userLogin;
	}

	public String getUserPswd() {
		return this.userPswd;
	}

	public void setUserPswd(String userPswd) {
		this.userPswd = userPswd;
	}

	public String getUserNom() {
		return this.userNom;
	}

	public void setUserNom(String userNom) {
		this.userNom = userNom;
	}

	public String getUserPrenom() {
		return this.userPrenom;
	}

	public void setUserPrenom(String userPrenom) {
		this.userPrenom = userPrenom;
	}

	public String getUserAdresse() {
		return this.userAdresse;
	}

	public void setUserAdresse(String userAdresse) {
		this.userAdresse = userAdresse;
	}

	public String getUserCp() {
		return this.userCp;
	}

	public void setUserCp(String userCp) {
		this.userCp = userCp;
	}

	public String getUserEmail() {
		return this.userEmail;
	}

	public void setUserEmail(String userEmail) {
		this.userEmail = userEmail;
	}

	public String getUserTel() {
		return this.userTel;
	}

	public void setUserTel(String userTel) {
		this.userTel = userTel;
	}

	public String getUserGsm() {
		return this.userGsm;
	}

	public void setUserGsm(String userGsm) {
		this.userGsm = userGsm;
	}

	public Date getUserCreateDate() {
		return this.userCreateDate;
	}
	public String getUserCreateDateFormat() {
		SimpleDateFormat formater = new SimpleDateFormat("dd/MM/yyyy hh:mm:ss");
		return formater.format(this.userCreateDate);
	}

	public void setUserCreateDate(Date userCreateDate) {
		this.userCreateDate = userCreateDate;
	}

	public boolean isUserIsAdmin() {
		return userIsAdmin;
	}

	public void setUserIsAdmin(boolean userIsAdmin) {
		this.userIsAdmin = userIsAdmin;
	}

	public boolean isUserIsValide() {
		return userIsValide;
	}

	public void setUserIsValide(boolean userIsValide) {
		this.userIsValide = userIsValide;
	}
	
}

Here is my hibernate-context:
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd "> <context:property-placeholder location="/WEB-INF/spring.properties" /> <!-- Enable annotation style of managing transactions --> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- Declare a datasource that has pooling capabilities--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" p:driverClass="com.mysql.jdbc.Driver" p:jdbcUrl="jdbc:mysql://localhost:3306/gestImmo" p:user="root" p:password="" p:acquireIncrement="5" p:idleConnectionTestPeriod="60" p:maxPoolSize="100" p:maxStatements="50" p:minPoolSize="10" /> <!-- Declare the Hibernate SessionFactory for retrieving Hibernate sessions --> <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" p:dataSource-ref="dataSource" p:configLocation="${hibernate.config}" p:packagesToScan="modele.DAO.beans.user"/> <!-- Declare a transaction manager--> <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager" p:sessionFactory-ref="sessionFactory" /> </beans>

My servlet

package com.starterSpring.controller.user;
import org.springframework.stereotype.Controller;
import org.springframework.validation.BindingResult;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.starterSpring.form.user.CreateUserForm;
import com.starterSpring.utilities.EmailSender;
import modele.DAO.beans.user.User;
import com.starterSpring.services.user.*;

@Controller
public class CreationUser {

	@RequestMapping("/user/creationUser")
    public ModelAndView addUSer(@ModelAttribute User usr,@RequestParam("confirmUser") 
String pswdConfirm,BindingResult result, Model model) {      
		//model.addAttribute("ser", user);
		ModelAndView modelAndView = new ModelAndView();
		if(usr.getUserPswd().equals(pswdConfirm) && pswdConfirm != ""){
			modelAndView.setViewName("valUser");
		}else{
			modelAndView.setViewName("createUser");
		}
		UserService usrServ = new UserService();
        usrServ.add(usr);
        //usr.setUserAdresse("&&&"+pswdConfirm+"---"+usr.getUserPswd()+usr.getUserPswd().equals(pswdConfirm));
		modelAndView.addObject("User", usr);
        return modelAndView;
    }
	@RequestMapping(value="/user/createUser", method=RequestMethod.GET)
    public String myform(Model model) {
        model.addAttribute("User", new User());
        
        return "createUser";
    }
}

finally my page asp

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@taglib uri="http://www.springframework.org/tags" prefix="spring"%>
<%@taglib prefix="form" uri="http://www.springframework.org/tags/form"%>
<%@ page pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8" />
        <title>Création d'un User</title>
        <link type="text/css" rel="stylesheet" href="../inc/css/style.css" />
        
        <script>
        	function checkFied(){
        		/*if(document.getElementById("nomUser").value == ''){
        			alert("vous devez introduire un nom");
        			document.getElementById("nomUser").focus();
        			return false;
        		}
        		if(document.getElementById("adresseUser").value == ''){
        			alert("vous devez introduire une adresse");
        			document.getElementById("adresseUser").focus();
        			return false;
        		}
        		if(document.getElementById("telephoneUser").value == ''){
        			alert("vous devez introduire un numero de telephone");
        			document.getElementById("telephoneUser").focus();
        			return false;
        		}*/
        		document.forms['insUser'].submit();
        		return true;
        	}
        </script>
    </head>
    <body>
        <div>
        	<c:out value="${message}" default="Inscription" escapeXml="false"></c:out>
            <form:form commandName="User" method="post" id="insUser" name="insUser" action="creationUser">
            <form:errors path="userLogin" />
                <fieldset>
                    <legend>Informations User</legend>
                    
                    <form:label path="userLogin"><spring:message code="label.login"/>
<span class="requis">*</span></form:label>
                    <form:input path="userLogin" ></form:input>
                    <!--<label for="loginUser">Login <span class="requis">*</span></label>
<input type="text" id="loginUser"
 name="loginUser" value="<c:out value="${user.userLogin}"></c:out>" size="20" maxlength="20" />-->
                    <span class="erreur"><c:out value="${form.erreurs['loginUser']}"></c:out></span>
                    <br />
                    
                    <!--<label for="pswdUser">Password <span class="requis">*</span></label>
                    <input type="password" id="pswdUser" name="pswdUser" value="" size="20" maxlength="20" />-->
                    <form:label path="userPswd"><spring:message code="label.password"/>
<span class="requis">*</span></form:label>
                    <form:input path="userPswd"></form:input>
                    <span class="erreur"><c:out value="${form.erreurs['pswdUser']}"></c:out></span>
                    <br />
                    
                    <label for="confirmUser"><spring:message code="label.confirm"/><span class="requis">*</span></label>
                    <input type=""password" id="confirmUser" name="confirmUser" value="" size="20" maxlength="20" />
                    
                    <span class="erreur"><c:out value="${form.erreurs['confirmUser']}"></c:out></span>
                    <br />
                    
                    <!--<label for="nomUser">Nom <span class="requis">*</span></label>
                    <input type="text" id="nomUser" name="nomUser" value="<c:out value="${user.userNom}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userNom"><spring:message code="label.lastname"/>
<span class="requis">*</span></form:label>
                    <form:input path="userNom" ></form:input>
                    <br />
                    
                    <!--<label for="prenomUser">Prénom </label>
                    <!--<input type="text" id="prenomUser" name="prenomUser" value="<c:out value="${user.userPrenom}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userPrenom"><spring:message code="label.firstname"/>
<span class="requis">*</span></form:label>
                    <form:input path="userPrenom" ></form:input>
                    <br />
    
                    <!--<label for="adresseUser">Adresse <span class="requis">*</span></label>
                    <input type="text" id="adresseUser" name="adresseUser" value="<c:out value="${user.userAdresse}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userAdresse"><spring:message code="label.address"/>
<span class="requis">*</span></form:label>
                    <form:input path="userAdresse" ></form:input>
                    <br />
                    
                    <!--<label for="cpUser">Code postal <span class="requis">*</span></label>
                    <input type="text" id="cpUser" name="cpUser" value="<c:out value="${user.userCp}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userCp"><spring:message code="label.zipcode"/>
<span class="requis">*</span></form:label>
                    <form:input path="userCp" ></form:input>
                    <br />
    
                    <!--<label for="telephoneUser">Numéro de téléphone <span class="requis">*</span></label>
                    <input type="text" id="telephoneUser" name="telephoneUser" value="<c:out value="${user.userTel}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userTel"><spring:message code="label.telephone"/><span class="requis">*</span>
</form:label>
                    <form:input path="userTel" ></form:input>
                    <br />
                    
                    <!--<label for="gsmUser">Gsm <span class="requis">*</span></label>
                    <input type="text" id="gsmUser" name="gsmUser" value="<c:out value="${user.userGsm}">
</c:out>" size="20" maxlength="20" />-->
                    <form:label path="userGsm"><spring:message code="label.gsm"/><span class="requis">*</span>
</form:label>
                    <form:input path="userGsm" ></form:input>
                    <br />
                    
                    <!-- <label for="emailUser">Adresse email</label>
                    <input type="email" id="emailUser" name="emailUser" value="<c:out value="${user.userEmail}">
</c:out>" size="20" maxlength="60" />-->
                    <form:label path="userEmail"><spring:message code="label.email"/></form:label>
                    <form:input path="userEmail" ></form:input>
                    <span class="erreur"><c:out value="${form.erreurs['emailUser']}"></c:out></span>
                    <br />
                </fieldset>
                <input onClick="return checkFied();" type="button" value="Valider"  />
                <input type="reset" value="Remettre à zéro" /> <br />
                <p class="${empty form.erreurs ? 'succes' : 'erreur'}">${form.resultat}</p>
            </form:form>
        </div>
    </body>
</html>

I'm disturbing with this and hope to find a solution

[fabian verbeek]

I'm trying an other way by using a class HibernateSessionFactory

package modele.DAO;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateSessionFactory {

    private static final SessionFactory sessionFactory = buildSessionFactory();

    private static SessionFactory buildSessionFactory() {
        try {
            // Create the SessionFactory from hibernate.cfg.xml
            return new Configuration().configure("/hibernate.cfg.xml").buildSessionFactory();
        }
        catch (Throwable ex) {
            // Make sure you log the exception, as it might be swallowed
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }

}

And my hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="jndi.class">com.sun.jndi.fscontext.RefFSContextFactory</property> <property name="jndi.url">file:///tmp</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/gestImmo</property> <property name="hibernate.connection.username">root</property> <!-- dialect for MySQL --> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.transaction.factory_class"> org.hibernate.transaction.JDBCTransactionFactory</property> <property name="current_session_context_class">thread</property> <mapping class="modele.DAO.beans.user.User"/> </session-factory> </hibernate-configuration>

I replace the line in my userService:
Session session = sessionFactory.getCurrentSession();
session.save(usr);
by

Session session = sessionFactory.getCurrentSession();
		
		//logger.debug("Begin transaction");
		try{
			tx = session.beginTransaction();
			session.save(usr);
			tx.commit();
			logger.debug("commit");
		} catch (HibernateException e) {
			if (tx != null){
				tx.rollback();
			}
			e.printStackTrace();
		} finally {
			session.close();
		}