java.lang.NumberFormatException: For input string:

[Caleb Jhay]

Hi,

I dont knw if this is the right forum to ask this queston.

I have this query

    public ModelAndView handleRequest(HttpServletRequest hsr, HttpServletResponse hsr1) throws Exception {
        ModelAndView mv = new ModelAndView("group");
        String out = "";
        try {
            Session session = HibernateUtil.getSessionFactory().getCurrentSession();
            session.beginTransaction();
            List result = session.createSQLQuery("select * from SRC_ASSET_PROJECT_COST_SOURCE where SRC_DOCUMENT_ID not in (SELECT t1.SRC_DOCUMENT_ID from SRC_ASSET_PROJECT_COST_SOURCE t1 JOIN SRC_ASSET_PRJ_COST_SPLIT_ITEMS t2 ON (t1.SRC_DOCUMENT_ID = t2.SRC_DOCUMENT_ID) JOIN SRC_ASSET_PRJ_COST_SPLIT_DET t3 ON (t2.SPL_DOCUMENT_ID = t3.SPL_DOCUMENT_ID) WHERE t1.src_split_status = 'N' and t1.asset_grp_status = 'I' and t3.ASSET_GRP_STATUS LIKE 'N')").list();
            mv.addObject("srcAssetProjectCostSource", result);
            session.getTransaction().commit();
            } catch (Exception e) {
            e.printStackTrace();
        }
        mv.addObject("message", out);
        return mv;
    }

This code execute well. I was able to see the size of my result

For some reason I dont see anything on my jsp page it returns me this error

SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/AssetCap] threw exception [java.lang.NumberFormatException: For input string: "PO_NUMBER"] with root cause
java.lang.NumberFormatException: For input string: "DATE_RECEIVED"
	at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
	at java.lang.Integer.parseInt(Integer.java:449)
	at java.lang.Integer.parseInt(Integer.java:499)
	at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:166)
	at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:46)

My JSP CODE is this

                                    <c:forEach items="${srcAssetProjectCostSource}" var="srcAssetProjectCostSource">
                                                            addPO("<c:out value='${srcAssetProjectCostSource.PO_NUMBER}'/>");
                                    </c:forEach>

I ran out of ideas I dont know what to do because I'm new to java/spring and hibernate. Any help is deeply appriciated.

Best Regards,

[Paul Clapham]

Let's put it this way: the JSP processing is trying to convert the string "DATE_RECEIVED" to an integer for some reason. I don't see why either of the
two code fragments you posted have anything to do with that.

[Campbell Ritchie]

Please avoid long lines; they are difficult to read, particularly in code tags.
You are somehow passing the String "PO_NUMBER" to the constructor of a Number class, or to a method like Integer.parseInt(), Integer.valueOf(), etc. It would appear to be Integer.parseInt().
You will have to go through your code, using the line numbers shown, and work out where it is happening. It is probably not in the code you posted.

[Caleb Jhay]

Hi,

THANK YOU FOR REPLYING GUYS

edited the error and put the entire error log.

    public ModelAndView handleRequest(HttpServletRequest hsr, HttpServletResponse hsr1) throws Exception {
        ModelAndView mv = new ModelAndView("group");
        String out = "";
        try {
            Session session = HibernateUtil.getSessionFactory().getCurrentSession();
            session.beginTransaction();
            List result = session.createSQLQuery("select * from SRC_ASSET_PROJECT_COST_SOURCE where SRC_DOCUMENT_ID not in (
            SELECT t1.SRC_DOCUMENT_ID from SRC_ASSET_PROJECT_COST_SOURCE t1 JOIN SRC_ASSET_PRJ_COST_SPLIT_ITEMS t2 ON 
           (t1.SRC_DOCUMENT_ID = t2.SRC_DOCUMENT_ID)
          JOIN SRC_ASSET_PRJ_COST_SPLIT_DET t3 ON (t2.SPL_DOCUMENT_ID = t3.SPL_DOCUMENT_ID)
           WHERE t1.src_split_status = 'N' and t1.asset_grp_status = 'I' and t3.ASSET_GRP_STATUS LIKE 'N')").list();
            mv.addObject("srcAssetProjectCostSource", result);
            session.getTransaction().commit();
            } catch (Exception e) {
            e.printStackTrace();
        }
        mv.addObject("message", out);
        return mv;
    }

This code execute well. I was able to see the size of my result

For some reason I dont see anything on my jsp page it returns me this error

java.lang.NumberFormatException: For input string: "poNumber"
	at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
	at java.lang.Integer.parseInt(Integer.java:449)
	at java.lang.Integer.parseInt(Integer.java:499)
	at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:166)
	at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:46)
	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:67)
	at org.apache.el.parser.AstValue.getValue(AstValue.java:169)
	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:189)
	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:985)
	at org.apache.jsp.WEB_002dINF.jsp.srcAssetProjectCostSource_jsp._jspx_meth_c_005fout_005f0(srcAssetProjectCostSource_jsp.java:958)
	at org.apache.jsp.WEB_002dINF.jsp.srcAssetProjectCostSource_jsp._jspx_meth_c_005fforEach_005f0(srcAssetProjectCostSource_jsp.java:926)
	at org.apache.jsp.WEB_002dINF.jsp.srcAssetProjectCostSource_jsp._jspService(srcAssetProjectCostSource_jsp.java:673)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329)
	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:644)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:498)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:562)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:394)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302)
	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:619)
Jul 23, 2011 9:37:23 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/AssetCap] threw exception [An exception occurred processing JSP page /WEB-INF/jsp/srcAssetProjectCostSource.jsp at line 610

607:                                 <option value="All">All</option>
608:                                 <script type = "text/javascript">
609:                                     <c:forEach items="${srcAssetProjectCostSource}" var="srcAssetProjectCostSource">
610:                                                             addPO("<c:out value='${srcAssetProjectCostSource.poNumber}'/>");
611:                                     </c:forEach>
612:                                                             addPO2();
613:                                 </script>

My JSP CODE is this

                                    <c:forEach items="${srcAssetProjectCostSource}" var="srcAssetProjectCostSource">
                                                            addPO("<c:out value='${srcAssetProjectCostSource.PO_NUMBER}'/>");
                                    </c:forEach>

I was confused how come im getting the parse error since I'm not parsing anything?
Initially I was using List result = session.createQuery it works ok. But when I try List result = session.createSQLQuery Im getting this problem.

Best Regards,