Number Format Exception

[Ron Ingram]

Can someone fine the exception with the Integers? I know where it is at, just can't find out how it is happening

Exception:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer
	InventoryServlets.InvSelect.doPost(InvSelect.java:68)
	InventoryServlets.InvSelect.doGet(InvSelect.java:28)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.

Database Query

    public List INV_SELECT(Integer inv_id) {
        //Create Array to store ResultSet
        List<Object> invList = new ArrayList<Object>();
        //Get Database Resource
        con = dbcon.SimpleConnection();
        //PreparedStatement ps = null;


        String query = "SELECT * FROM Inventory WHERE inv_id = '" + inv_id + "';";

        try {
        //PreparedStatement for later use
            //ps = con.prepareStatement(query);
            //ps.setString(1, sku);

            //rs = ps.executeQuery():
            con = dbcon.SimpleConnection();

            stmt = con.createStatement();



            System.out.println(query);

            rs = stmt.executeQuery(query);

            if (rs.next()) {
                invList.add(rs.getInt(1));
                invList.add(rs.getString(2));
                invList.add(rs.getString(3));
                invList.add(rs.getString(4));
                invList.add(rs.getString(5));
                invList.add(rs.getString(6));
                invList.add(rs.getInt(7));
                invList.add(rs.getInt(8));
                invList.add(rs.getInt(9));
                invList.add(rs.getString(10));
                invList.add(rs.getString(11));
                invList.add(rs.getString(12));
                invList.add(rs.getString(13));
                invList.add(rs.getString(14));
                invList.add(rs.getString(15));
                invList.add(rs.getString(16));
                invList.add(rs.getString(17));
                invList.add(rs.getString(18));
                invList.add(rs.getString(19));
                invList.add(rs.getString(20));
                invList.add(rs.getString(21));
                invList.add(rs.getString(22));
                invList.add(rs.getString(23));
                invList.add(rs.getString(24));




            }
            return invList;
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        } finally {
            close.closeAll();
        }
    }

Servlet:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package InventoryServlets;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.*;


//Import for Security Check
import javax.servlet.http.HttpSession;
import DAO.InvDB;
import Beans.InvBean;
import java.util.List;

/**
 *
 * @author Ronald Ingram
 */
public class InvSelect extends HttpServlet {

    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //Forwards any doGet to doPost for better handling
        doPost(request, response);
    }

    @Override
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {



        RequestDispatcher dispatcher = null;
        HttpSession session = request.getSession();
        InvBean invBean = new InvBean();
        InvDB inv_data = new InvDB();

        //Used to validate role and navigate correctly for security
        String chk = session.getAttribute("role").toString();

            //Use to make the main screen list all products (default)

            Integer inv_id = Integer.parseInt(request.getParameter("selection"));
            System.out.println("Selection parameter=" +inv_id);

            
            System.out.println("poam equals" + inv_id);


            //Call InvDB and pass the inv_id as an argument to be used for the query
            List selectedList = inv_data.INV_SELECT(inv_id);
            System.out.println("String 0 =" + selectedList.get(0).toString());
            System.out.println("String 1 =" + selectedList.get(1).toString());


            //Add array to the Product Bean
            invBean.setInv_id((Integer)selectedList.get(0));
            invBean.setOrganization(selectedList.get(1).toString());
            invBean.setName(selectedList.get(2).toString());
            invBean.setLocation(selectedList.get(3).toString());
            invBean.setFloor(selectedList.get(4).toString());
            invBean.setRoom(selectedList.get(5).toString());
            invBean.setIp((Integer)selectedList.get(7));
            invBean.setSubnet((Integer)selectedList.get(8));
            invBean.setMac((Integer)selectedList.get(9));
            invBean.setBarcode(selectedList.get(9).toString());
            invBean.setManufacturer(selectedList.get(10).toString());
            invBean.setModel(selectedList.get(11).toString());
            invBean.setSerial(selectedList.get(12).toString());
            invBean.setOs(selectedList.get(13).toString());
            invBean.setAssigned_user(selectedList.get(14).toString());
            invBean.setStatus(selectedList.get(15).toString());
            invBean.setInv_class(selectedList.get(16).toString());
            invBean.setType(selectedList.get(17).toString());
            invBean.setSys_id(selectedList.get(18).toString());
            invBean.setPurchase_dt(selectedList.get(19).toString());
            invBean.setWarranty_exp(selectedList.get(20).toString());
            invBean.setWarranty_response(selectedList.get(21).toString());
            invBean.setCriticality(selectedList.get(22).toString());
            invBean.setSubsystem(selectedList.get(23).toString());



            //Store POAM Bean to session
            session.setAttribute("invBean", invBean);

if (chk.equals("ISSO")) {
            dispatcher = request.getRequestDispatcher("/jsp/Inventory/InvSelected.jsp");

        } else {

            dispatcher = request.getRequestDispatcher("/jsp/Inventory/InvSelectedUser.jsp");



        }
        dispatcher.forward(request, response);

        
    }
}

JSP:

<jsp:include page = "/jsp/Includes/TemplateJSPs.jsp" />
<%@page import="Beans.POAMBean"%>
<style type="text/css">
    /*Center Div Tag:  Overide format from css */
    #center{
        margin-left: 0%;
        margin-right: 0%;
    }

    #form{
        margin: auto;
        margin-right: auto;
        border: solid #6E899C;


    }

    #centerLeft{
        float: left;
        margin-right: 2%;
        margin-left: 0%;
        width: 48%;
        table-layout: auto;
        text-align:  center;
        font-family: Arial;
        color: #6E899C;

    }

    #centerRight{
        float: right;
        margin-left: 2%;
        margin-right: 0%;
        width: 48%;
        table-layout: auto;
        text-align:  center;
        font-family: Arial;
        color: #6E899C;
        border: 1px solid black;
    }

    #centerBottom{
        width: 100%;



    }

    #POAMLeft{
        padding: 2px;
        border: solid #6E899C;
        font-size: 12px;
    }

    #POAMRight{
        font-size: 12px;

    }

    #POAMRight td{

    }


    #POAMBottom  {
        border: 0px solid black;
        color: black;
        text-align: left;
        font-size: 12px;
    }



    #poamTable textarea{
        font-family: cursive;
        font-size: 12px;
    }
</style>


<!-- Center -->
<div id="center">
    <div id="form">
        <jsp:useBean id="invBean" scope="session" class="Beans.InvBean" />
        <div align="right">
            <a href="Forwarder?forward=editInv">Edit Inventory Item</a> |
            <a href="InvDelete?inv_id=<%= invBean.getInv_id()%>">Delete POAM</a> 

        </div>

        <table id="poamTable"width="100%" cellpadding="1" >
            <thead>
                <tr>
                    <th colspan="15"><h2> Selected Inventory <br /><br /></h2></th>

                </tr>


                <tr>

                    <th colspan="8"><h2>________________________________________________________________________<br /><br /></h2></th>

                </tr>
            </thead>
        </table>



        <div id="centerLeft">



            <table id="POAMLeft">
                <tr>
                    <td><b>Organization</b></td>
                    <td><b><u><%= invBean.getOrganization()%></u></b></td>
                </tr>
                <tr>
                    <td><b>FISMA System ID</b></td>
                    <td><b><u><%= invBean.getSys_id()%></u></b></td>
                </tr>
                <tr>
                    <td><b>Host Name</b></td>
                    <td><b><u><%= invBean.getName()%></u></b></td>
                </tr>
                <tr>
                    <td><b>Location</b></td>
                    <td><%=invBean.getLocation()%></td>
                </tr>
                <tr>
                    <td><b>IP Address</b></td>
                    <td><%=invBean.getIp()%></td>
                </tr>
                <tr>
                    <td><b>Subnet Mask</b></td>
                    <td><%=invBean.getSubnet()%></td>
                </tr>
                <tr>
                    <td><b>MAC Address</b></td>
                    <td><%=invBean.getMac()%></td>
                </tr>
                <tr>
                    <td><b>Manufacturer and Model</b></td>
                    <td><%=invBean.getManufacturer()%></td>
                </tr>
            </table>
        </div>

        <div id="centerRigt">
            <table id="POAMRight">


                <tr>
                    <td><b>Assest Tag Number (Barcode)</b></td>
                    <td><%=invBean.getBarcode()%></td>
                </tr>
                <tr>
                    <td><b>Serial Number</b></td>
                    <td><%=invBean.getSerial()%></td>
                </tr>
                <tr>
                    <td><b>Operating System/ Firmware</b></td>
                    <td><%=invBean.getOs()%></td>
                </tr>
                <tr>
                    <td><b>Customer/Assigned User</b></td>
                    <td><%=invBean.getAssigned_user()%></td>
                </tr>
                <tr>
                    <td><b>Status</b></td>
                    <td><%=invBean.getStatus()%></td>
                </tr>
                <tr>
                    <td><b>Warranty Expiration Date</b></td>
                    <td><%=invBean.getWarranty_exp()%></td>
                </tr>
                <tr>
                    <td><b>Class</b></td>
                    <td><%=invBean.getInv_class()%></td>
                </tr>

                <tr>
                    <td><b>Type</b></td>
                    <td><%=invBean.getType()%></td>
                </tr>
                <tr>
                    <td><b>Equipment Purchase Date</b></td>
                    <td><%=invBean.getPurchase_dt()%></td>
                </tr>
                <tr>
                    <td><b>Equipment Purchase Date</b></td>
                    <td><%=invBean.getPurchase_dt()%></td>
                </tr>
                <tr>
                    <td><b>Warranty End Date</b></td>
                    <td><%=invBean.getWarranty_exp()%></td>
                </tr>
                <tr>
                    <td><b>Warranty Response</b></td>
                    <td><%=invBean.getWarranty_response()%></td>
                </tr>
                <tr>
                    <td><b>Criticality</b></td>
                    <td><%=invBean.getCriticality()%></td>
                </tr>
                <tr>
                    <td><b>Security Subsystem</b></td>
                    <td><%=invBean.getSubsystem()%></td>
                </tr>
            </table>
        </div>

    </div>
    <div id="warning"

</div>

</div>

<jsp:include page = "Includes/mainBottom.jsp" />

[Paul Clapham]

The only place where you cast something to an Integer is here:

invBean.setInv_id((Integer)selectedList.get(0));

And as the message says, what you're getting from the list is a String and you can't cast that to an Integer.

Perhaps this instead?

invBean.setInv_id(Integer.parseInt(selectedList.get(0)));

[Mike Zal]

Integer inv_id = Integer.parseInt(request.getParameter("selection")); 

What value is being returned by the getParameter call? If you do a System.out.println(request.getParameter("selection")), I have a feeling that it will be a value that does not convert directly to an int.

[Ron Ingram]

returns 1 for parameter call "selection".

line 68 returns "test" which is def not a number. Got to figure this out where the problem lies. The database is correct for that field though

[Mike Zal]

I don't think this is the problem causing your issue but you may wish to update your query to not use select * or using positional index to retrieve values from a ResultSet. I have seen way too many maintenance issues come out of this practice.

[Ron Ingram]

Thanks Mike for your time

I just figured it out. It had the positional index numbers off trying to retrieve the values from the resultset. I'll go back and cleanup the query and use column names vs index.