Forum:

Spring

org.apache.jasper.JasperException: java.lang.NumberFormatException: For input string: "id"

Rahman ziaur

Greenhorn

Posts: 23

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am doing a small apps on SPring MVC and getting the exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /views/addPerson.jsp at line 17

Below is the my jsp page code,

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"  
    pageEncoding="ISO-8859-1"%>  
<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>  
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>  
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">  
<html>  
 <head>  
  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">  
  <title>Spring MVC Form Handling</title>  
 </head>  
 <body>  
  <h2>Add Person Data</h2>  
  <form:form method="POST" action="save.html">  
      <table>  
       <tr>  
           <td><form:label path="id">Person ID:</form:label></td>  
           <td><form:input path="id" value="${person.id}" readonly="true"/></td>  
       </tr>  
       <tr>  
           <td><form:label path="fname">Person First_Name:</form:label></td>  
           <td><form:input path="fname" value="${person.fname}"/></td>  
       </tr>  
       
       <tr>  
           <td><form:label path="lname">Person Last_Name:</form:label></td>  
           <td><form:input path="lname" value="${person.lname}"/></td>  
       </tr> 
       <tr>  
           <td><form:label path="age">Person Age:</form:label></td>  
           <td><form:input path="age" value="${person.age}"/></td>  
       </tr>  
       <tr>  
           <td><form:label path="cnumber">Person Contact:</form:label></td>  
           <td><form:input path="cnumber" value="${person.cnumber}"/></td>  
       </tr>  
         
       <tr>  
           <td><form:label path="address">Person Address:</form:label></td>  
                    <td><form:input path="address" value="${person.address}"/></td>  
       </tr>  
          <tr>  
         <td colspan="2"><input type="submit" value="Submit"/></td>  
        </tr>  
   </table>   
  </form:form>  
    
  
 </body>  
</html>

Person.java

package com.zia.model;

import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id; 
import javax.persistence.Table;

/**
 * @author ziaur.rahman
 *
 */
@Entity
@Table(name="Person")
public class Person implements Serializable{

/**
	 * 
	 */
	private static final long serialVersionUID = 6041958632742989064L;
	
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	@Column(name="person_id")
	public Integer person_id;
	
	@Column(name="first_name")
	public String first_name;
	
	@Column(name="last_name")
	public String last_name;
	
	@Column(name="age")
	public int age;
	
	@Column(name="contact_number")
	public String contact_number;
	
	@Column(name="address")
	public String address;

public Integer getPerson_id() {
		return person_id;
	}

public String getFirst_name() {
		return first_name;
	}

public String getLast_name() {
		return last_name;
	}

public int getAge() {
		return age;
	}

public String getContact_number() {
		return contact_number;
	}

public String getAddress() {
		return address;
	}

public void setPerson_id(Integer person_id) {
		this.person_id = person_id;
	}

public void setFirst_name(String first_name) {
		this.first_name = first_name;
	}

public void setLast_name(String last_name) {
		this.last_name = last_name;
	}

public void setAge(int age) {
		this.age = age;
	}

public void setContact_number(String contact_number) {
		this.contact_number = contact_number;
	}

public void setAddress(String address) {
		this.address = address;
	}

}

PersonBean.java===

PersonController.java

package com.zia.controller;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.mapping.MetaAttributable;
import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;
import org.springframework.validation.BindingResult;
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.servlet.ModelAndView;

import com.zia.bean.PersonBean;
import com.zia.model.Person;
import com.zia.service.PersonService;

/**
 * @author ziaur.rahman
 *
 */

@Controller
public class PersonController {
	
	@Autowired
	public PersonService personService;
	
	
	@RequestMapping(value="/save" , method=RequestMethod.POST)
	public ModelAndView savePerson(@ModelAttribute("command")PersonBean personBean,   
			   BindingResult result)
	{
		Person person = prepareModel(personBean);  
		personService.addPerson(person);
		return new ModelAndView("redirect:/add.html");
	}
	
	
	@RequestMapping(value="/person" ,method=RequestMethod.GET)
	public ModelAndView listPerson()
	{
		Map<String,Object> model=new HashMap<String,Object>();
		model.put("person",  prepareListofBean(personService.listPerson()));
		return new ModelAndView("personList", model);
	}
	
	@RequestMapping(value = "/index", method = RequestMethod.GET)  
	public ModelAndView welcome() {  
	  return new ModelAndView("index");  
	 } 
	
	@RequestMapping(value="/add" ,method=RequestMethod.GET)
	public ModelAndView addPerson(@ModelAttribute("command")PersonBean personBean,BindingResult result)
	{
		Map<String,Object> model=new HashMap<String,Object>();
		model.put("person",  prepareListofBean(personService.listPerson()));
		return new ModelAndView("addPerson",model);
		
	}
	
	@RequestMapping(value="/edit" ,method=RequestMethod.GET)
	public ModelAndView editPerson(@ModelAttribute("command") PersonBean personBean,BindingResult result)
	{
		Map<String, Object> model = new HashMap<String, Object>();  
		  model.put("person", preparePersonBean(personService.getPerson((personBean.getId()))));  
		  model.put("persons",  prepareListofBean(personService.listPerson()));  
		  return new ModelAndView("addPerson", model);
	}
	
	@RequestMapping(value="/delete",method=RequestMethod.GET)
	public ModelAndView deletePerson(@ModelAttribute("command") PersonBean personBean,BindingResult result)
	{
		personService.deletePerson(prepareModel(personBean));
		Map<String,Object> model=new HashMap<String, Object>();  
		    
		  model.put("person", null);  
		  model.put("persons",  prepareListofBean(personService.listPerson()));  
		  return new ModelAndView("addPerson", model);  
	}
	
	private Person prepareModel(PersonBean personBean){  
		  Person person = new Person();  
		  person.setAddress(personBean.getAddress());
		  person.setAge(personBean.getAge());
		  person.setContact_number(personBean.getCnumber());
		  person.setFirst_name(personBean.getFname());
		  person.setLast_name(personBean.getLname());
		  person.setPerson_id(personBean.getId());
		  personBean.setId(null);
		  return person;  
		 }
	
	private List<PersonBean> prepareListofBean(List<Person> person){  
		  List<PersonBean> beans = null;  
		  if(person != null && !person.isEmpty()){  
		   beans = new ArrayList<PersonBean>();  
		   PersonBean bean = null;  
		   for(Person persons : person){  
		    bean = new PersonBean();  
		    bean.setAddress(persons.getAddress());  
		    bean.setId(persons.getPerson_id());
		    bean.setCnumber(persons.getContact_number());
		    bean.setAge(persons.getAge());
		    bean.setFname(persons.getFirst_name());
		    bean.setLname(persons.getLast_name());
		    beans.add(bean);  
		   }  
		  }  
		  return beans;  
		 }
	
	public PersonBean preparePersonBean(Person person)
	{
		 PersonBean bean = new PersonBean(); 
		 bean.setAddress(person.getAddress());
		 bean.setAge(person.getAge());
		 bean.setCnumber(person.getContact_number());
		 bean.setFname(person.getFirst_name());
		 bean.setLname(person.getLast_name());
		 bean.setId(person.getPerson_id());
		  return bean;  
		 }

}

PersonServiceIMpl.java

PersonDaoImpl.java

package com.zia.dao;

import java.util.List;

import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.zia.model.Person;

/**
 * @author ziaur.rahman
 *
 */

@Repository()
public class PersonDaoImpl implements PersonDao{
	
	@Autowired
	SessionFactory sessionFactory;
	
	Transaction tr=null;

@Override
	public void addPerson(Person person) {
		
		sessionFactory.getCurrentSession().saveOrUpdate(person);  
		/*org.hibernate.Session session= sessionFactory.openSession(); 
		tr=session.beginTransaction();
		session.persist(person);
		tr.commit();*/
		
		
		
	}

@SuppressWarnings("unchecked")
	@Override
	public List<Person> lisPersons() {
		 return (List<Person>) sessionFactory.getCurrentSession().createCriteria(Person.class).list();
	}

@Override
	public Person getPerson(int uid) {
		
		 return (Person) sessionFactory.getCurrentSession().get(Person.class, uid);
	}

@Override
	public void deletePerson(Person person) {
		sessionFactory.getCurrentSession().createQuery("DELETE FROM Person WHERE uId = "+person.getPerson_id()).executeUpdate();
		
		
	}

}

web.xml

crudOperation-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:security="http://www.springframework.org/schema/security"
	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-3.0.xsd       
                http://www.springframework.org/schema/context      
                http://www.springframework.org/schema/context/spring-context-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/security     
                http://www.springframework.org/schema/security/spring-security-3.1.xsd">

<context:property-placeholder location="classpath:resources/database.properties"></context:property-placeholder>
	<context:component-scan base-package="com.zia">
	</context:component-scan>

<tx:annotation-driven transaction-manager="hibernateTransactionManager"></tx:annotation-driven>

<bean
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean"
		id="sessionFactory">
		<property name="dataSource" ref="dataSource"></property>
		<property name="annotatedClasses">
			<list>
				<value>com.zia.model.Person</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
				<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
				<prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
			</props>
		</property>
	</bean>

Full Stack trace====

Sep 05, 2013 4:53:13 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Program Files\RSA SecurID Token Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;D:\apache-ant-1.9.2\bin;C:\Program Files\IBM\SDP\runtimes\base_v7\java\bin;;.
Sep 05, 2013 4:53:13 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
WARNING: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SpringCrudOperation' did not find a matching property.
Sep 05, 2013 4:53:13 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8012
Sep 05, 2013 4:53:13 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 412 ms
Sep 05, 2013 4:53:13 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Sep 05, 2013 4:53:13 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
log4j:WARN No appenders could be found for logger (org.springframework.web.servlet.DispatcherServlet).
log4j:WARN Please initialize the log4j system properly.
Sep 05, 2013 4:53:13 PM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring FrameworkServlet 'crudOperation'
Sep 05, 2013 4:53:16 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8012
Sep 05, 2013 4:53:16 PM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8010
Sep 05, 2013 4:53:16 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/24  config=null
Sep 05, 2013 4:53:16 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 2858 ms
Hibernate: select this_.person_id as person1_0_0_, this_.address as address0_0_, this_.age as age0_0_, this_.contact_number as contact4_0_0_, this_.first_name as first5_0_0_, this_.last_name as last6_0_0_ from Person this_
Sep 05, 2013 4:53:18 PM org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.NumberFormatException: For input string: "id"
	at java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at javax.el.ListELResolver.coerce(ListELResolver.java:167)
	at javax.el.ListELResolver.getValue(ListELResolver.java:51)
	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
	at org.apache.el.parser.AstValue.getValue(AstValue.java:123)
	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:938)
	at org.apache.jsp.views.addPerson_jsp._jspx_meth_form_005finput_005f0(addPerson_jsp.java:260)
	at org.apache.jsp.views.addPerson_jsp._jspx_meth_form_005fform_005f0(addPerson_jsp.java:134)
	at org.apache.jsp.views.addPerson_jsp._jspService(addPerson_jsp.java:87)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238)
	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)

Sep 05, 2013 4:53:18 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet crudOperation threw exception
java.lang.NumberFormatException: For input string: "id"
	at java.lang.NumberFormatException.forInputString(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at java.lang.Integer.parseInt(Unknown Source)
	at javax.el.ListELResolver.coerce(ListELResolver.java:167)
	at javax.el.ListELResolver.getValue(ListELResolver.java:51)
	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
	at org.apache.el.parser.AstValue.getValue(AstValue.java:123)
	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:938)
	at org.apache.jsp.views.addPerson_jsp._jspx_meth_form_005finput_005f0(addPerson_jsp.java:260)
	at org.apache.jsp.views.addPerson_jsp._jspx_meth_form_005fform_005f0(addPerson_jsp.java:134)
	at org.apache.jsp.views.addPerson_jsp._jspService(addPerson_jsp.java:87)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:386)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
	at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:238)
	at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:250)
	at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1060)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:798)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Unknown Source)

Can anyone help me,why i am getting this.
I am new to Spring and trying to learn it.

Any Suggestion must be appreciated.
Thanks in advance.

Rahman ziaur

Greenhorn

Posts: 23

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

No one is here to help???