Error in Remote Server (LinkedList)

Dear Ranchers,
I'm using JSP and MySQL for my project. After completing the project, I uploaded to the server and there i'm getting errors

The error i'm getting is given below.

HTTP Status 500 - 
 
--------------------------------------------------------------------------------
 
type Exception report
 
message 
 
description The server encountered an internal error () that prevented it from fulfilling this request.
 
exception 
 
org.apache.jasper.JasperException: Unable to compile class for JSP
 
An error occurred at line: 22 in the jsp file: /program/orderMgmt/status/search.jsp
Generated servlet error:
The method add(int, Object) in the type LinkedList is not applicable for the arguments (int)
 
An error occurred at line: 22 in the jsp file: /program/orderMgmt/status/search.jsp
Generated servlet error:
Type mismatch: cannot convert from double to Double

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:397)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

--------------------------------------------------------------------------------
 
Apache Tomcat/5.5.9

When I checked the Java Version of the remote server it is JDK 1.5

The error i'm getting is in a file called search.jsp and the code is given below.

<%@page import="ChartDirector.*" %> 
 
<%@  page language="java" session="true"  import="java.sql.*" import="java.util.*" import="java.text.SimpleDateFormat"%>
<%
String firstname = (String)session.getValue("firstname");
String lastname = (String)session.getValue("lastname");
if(firstname==null ||  lastname==null)
{response.sendRedirect("../../../sessionout.htm");
}
String client = request.getParameter("clicode");
String from = request.getParameter("from");
String to = request.getParameter("to");
try
{try
{Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(ClassNotFoundException e)
{out.println(e);
}
%>
<%@ include file="../../../dbcon/db.jsp" %>
<%
Statement client_con = dbCon.createStatement(); //for Client Codes
Statement stmt = dbCon.createStatement();
Statement stmt1 = dbCon.createStatement(); //for total shipments
Statement stmt2 = dbCon.createStatement(); //for air shipments
Statement stmt3 = dbCon.createStatement(); //for sea-fcl shipments
Statement stmt4 = dbCon.createStatement(); //for sea-lcl shipments
Statement stmt5 = dbCon.createStatement(); //for road-fcl shipments
Statement stmt6 = dbCon.createStatement(); //for road-lcl shipments
Statement stmt7 = dbCon.createStatement(); //for rail-fcl shipments
Statement stmt8 = dbCon.createStatement(); //for rail-lcl shipments

Statement stmt9 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt10 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt11 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt12 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt13 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt14 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt15 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt16 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt17 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt18 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt19 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt20 = dbCon.createStatement(); //for early deli of AIR Shipments
Statement stmt21 = dbCon.createStatement(); //To get the exception code
Statement stmt22 = dbCon.createStatement(); //To get the financials Details
Statement stmt23 = dbCon.createStatement(); //To get the Charges code

LinkedList ex_code = new LinkedList();
LinkedList ex_cnt = new LinkedList();

LinkedList fin_code = new LinkedList();
LinkedList fin_amt = new LinkedList();
 
String client_qry = "Select * from supplier_code where client_code='"+client+"'";
ResultSet rs_client = client_con.executeQuery(client_qry);
String client_name = "";
while(rs_client.next())
{client_name = rs_client.getString(3);
}

String query = "Select * from register_order where client='"+client+"' and fpodate>=str_to_date('"+from+"','%d-%m-%Y') and fpodate<=str_to_date('"+to+"','%d-%m-%Y')";
ResultSet rs = stmt.executeQuery(query);
int i=0;
String id="";
int total=0,air=0,sea_lcl=0,sea_fcl=0;
int road_fcl=0,road_lcl=0,rail_fcl=0,rail_lcl=0;
int sea_teu=0,sea_teu2=0;
int road_teu=0,road_teu2=0;
int rail_teu=0,rail_teu2=0;
//Date comparision variables below
int air_early=0,air_time=0,air_late=0;
int sea_early=0,sea_time=0,sea_late=0;
int road_early=0,road_time=0,road_late=0;
int rail_early=0,rail_time=0,rail_late=0;

int tot_early=0,tot_time=0,tot_late=0;

while(rs.next())
{i++;
id= rs.getString(1);
String query1 = "Select * from file_details where id='"+id+"'"; //total shipments
ResultSet rs1 = stmt1.executeQuery(query1);
while(rs1.next())
{total++;
}
String air_ship = "Select * from file_details where id='"+id+"' and type='AIR'"; //Air Shipments
ResultSet rs2 = stmt1.executeQuery(air_ship); 
while(rs2.next())
{air++;
}
String SFCL = "Select * from file_details where id='"+id+"' and type='FCL' and type_transport= 'SEA'"; //SEA -FCL
ResultSet rs3 = stmt3.executeQuery(SFCL); 
while(rs3.next())
{sea_fcl++;
sea_teu=sea_teu + rs3.getInt(26);
sea_teu2 = sea_teu2 + rs3.getInt(27);
}
String SLCL = "Select * from file_details where id='"+id+"' and type='LCL'and type_transport= 'SEA'"; //SEA-LCL
ResultSet rs4 = stmt4.executeQuery(SLCL); 
while(rs4.next())
{sea_lcl++;
}
 
String RDFCL = "Select * from file_details where id='"+id+"' and type='FCL'and type_transport= 'ROAD'"; //ROAD-FCL
ResultSet rs5 = stmt5.executeQuery(RDFCL); 
while(rs5.next())
{road_fcl++;
road_teu=road_teu + rs5.getInt(26);
road_teu2 = road_teu2 + rs5.getInt(27);

}
 
String RDLCL = "Select * from file_details where id='"+id+"' and type='LCL'and type_transport= 'ROAD'"; //ROAD-LCL
ResultSet rs6 = stmt6.executeQuery(RDLCL); 
while(rs6.next())
{road_lcl++;
}
 
String RAFCL = "Select * from file_details where id='"+id+"' and type='FCL'and type_transport= 'RAIL'"; //RAIL-FCL
ResultSet rs7 = stmt7.executeQuery(RAFCL); 
while(rs7.next())
{rail_fcl++;
rail_teu = rail_teu + rs7.getInt(26);
rail_teu2 = rail_teu2 + rs7.getInt(27);
}
 
String RALCL = "Select * from file_details where id='"+id+"' and type='LCL'and type_transport= 'RAIL'"; //RAIL-LCL
ResultSet rs8 = stmt8.executeQuery(RALCL); 
while(rs8.next())
{rail_lcl++;
}
//Shipments that are early, ontime and late will be calculated from here onwards

String AIR_EARLY = "Select * from file_details where id='"+id+"' and type_transport='AIR' and lead_time > delivery_date";
ResultSet rs9 = stmt9.executeQuery(AIR_EARLY);
while(rs9.next())
{air_early++;
} 
String AIR_TIME = "Select * from file_details where id='"+id+"' and type_transport='AIR' and lead_time = delivery_date";
ResultSet rs10 = stmt10.executeQuery(AIR_TIME);
while(rs10.next())
{air_time++;
} 
String AIR_LATE = "Select * from file_details where id='"+id+"' and type_transport='AIR' and lead_time < delivery_date";
ResultSet rs11 = stmt11.executeQuery(AIR_LATE);
while(rs11.next())
{air_late++;
} 
String SEA_EARLY = "Select * from file_details where id='"+id+"' and type_transport='SEA' and lead_time > delivery_date";
ResultSet rs12 = stmt12.executeQuery(SEA_EARLY);
while(rs12.next())
{sea_early++;
} 
String SEA_TIME = "Select * from file_details where id='"+id+"' and type_transport='SEA' and lead_time = delivery_date";
ResultSet rs13 = stmt13.executeQuery(SEA_TIME);
while(rs13.next())
{sea_time++;
} 
String SEA_LATE = "Select * from file_details where id='"+id+"' and type_transport='SEA' and lead_time < delivery_date";
ResultSet rs14 = stmt14.executeQuery(SEA_LATE);
while(rs14.next())
{sea_late++;
} 
String ROAD_EARLY = "Select * from file_details where id='"+id+"' and type_transport='ROAD' and lead_time > delivery_date";
ResultSet rs15 = stmt15.executeQuery(ROAD_EARLY);
while(rs15.next())
{road_early++;
} 
String ROAD_TIME = "Select * from file_details where id='"+id+"' and type_transport='ROAD' and lead_time = delivery_date";
ResultSet rs16 = stmt16.executeQuery(ROAD_TIME);
while(rs16.next())
{road_time++;
} 
String ROAD_LATE = "Select * from file_details where id='"+id+"' and type_transport='ROAD' and lead_time < delivery_date";
ResultSet rs17 = stmt17.executeQuery(ROAD_LATE);
while(rs17.next())
{road_late++;
} 
 
String RAIL_EARLY = "Select * from file_details where id='"+id+"' and type_transport='RAIL' and lead_time > delivery_date";
ResultSet rs18 = stmt18.executeQuery(RAIL_EARLY);
while(rs18.next())
{rail_early++;
} 
String RAIL_TIME = "Select * from file_details where id='"+id+"' and type_transport='RAIL' and lead_time = delivery_date";
ResultSet rs19 = stmt19.executeQuery(RAIL_TIME);
while(rs19.next())
{rail_time++;
} 
String RAIL_LATE = "Select * from file_details where id='"+id+"' and type_transport='RAIL' and lead_time < delivery_date";
ResultSet rs20 = stmt20.executeQuery(RAIL_LATE);
while(rs20.next())
{rail_late++;
} 
//shipments which are early,ontime and late are configured and end here...
}
String exception_code = "select exe_code,count(exe_code) from file_details,register_order where file_details.client_code = '"+client+"' and  register_order.id = file_details.id and register_order.order_active >= str_to_date('"+from+"','%d-%m-%Y') and register_order.order_active <= str_to_date('"+to+"','%d-%m-%Y') and exe_code!='' group by exe_code";
ResultSet rs21 = stmt21.executeQuery(exception_code);
while(rs21.next())
{ex_code.add(rs21.getString(1));
ex_cnt.add(rs21.getInt(2));
}

//String financials = "select charges_code,sum(usd_amt) from financials where client='"+client+"' group by charges_code";
String financials = "select charges_code,sum(usd_amt) from register_order,financials where financials.client='"+client+"' and register_order.order_active >=str_to_date('"+from+"','%d-%m-%Y') and register_order.order_active <=str_to_date('"+to+"','%d-%m-%Y') group by charges_code";
ResultSet rs22 = stmt22.executeQuery(financials);
while(rs22.next())
{fin_code.add(rs22.getString(1));
java.lang.Double abc = rs22.getDouble(2);
fin_amt.add(abc);
}

//int ex_code_length = ex_cnt.size();
//out.println(ex_code_length);
int air_total = air_early + air_time + air_late;
int sea_total = sea_early + sea_time + sea_late;
int road_total = road_early + road_time + road_late;
int rail_total = rail_early + rail_time + rail_late;

%>

Please Help me to solve this problem.

I've already given the same topic and couldn't solve the problem yet. Thanks and regards

Aravind Prasad

I've already given the same topic and couldn't solve the problem yet. Thanks and regards

The topic you're referring to is this one:
http://www.coderanch.com/t/291466/JSP/java/LinkedList-Problems-JSP
and a lot of people put in time to help you with it.
Please don't spread the same conversation across different threads. It gets confusing and wastes the time of the people who are trying to help you.

Go back and look at the answers in that thread, I think you will find the answer there.