servlet is not available

[sarita rane]

Friends

I wrote a servlet to convert jasper report to excel, code is as follows:

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.IOException;
import java.io.OutputStream;
import java.sql.Connection;
import java.util.HashMap;
import java.util.Map;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;

/**
 * Servlet implementation class ExcelReportServlet
 */
public class ExcelReportServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    DataSource ds=null;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public ExcelReportServlet() {
        super();
        // TODO Auto-generated constructor stub
    }
    public void init()
    {
        try{
        System.out.println("in ExcelReportServlet");	
        Context initCtx = new InitialContext();
        if (initCtx == null)
           throw new Exception("Boom - No Context");
        Context envCtx = (Context) initCtx.lookup("java:comp/env");
        ds = (DataSource)envCtx.lookup("jdbc/myoracle");
        //System.out.println("ReportServlet:DataSourse obtained:"+ds);
	        
        }
        catch (Exception e)
        {
        System.out.println("database source not obtained");
        System.out.println(e.toString());
        }
    }// end init()

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		HttpSession session=request.getSession(false);
        String reqfor=(String)request.getParameter("requestfor");
        String userid = (String)session.getAttribute("IdCode");
        System.out.println("Requestfor parameter obtained:"+reqfor);
        Map<String, String> parameters=new HashMap<String, String>();
		if(reqfor.equals("purchase")) { 
	   	     String cd=(String)request.getParameter("cd");
		     String cat=(String)request.getParameter("cat");
		     String type=(String)request.getParameter("type");
		     String year=(String)request.getParameter("year");
		     //System.out.println("cd "+cd+" cat"+cat+"  year "+year);
		     //int yr=Integer.parseInt(year);
		    parameters.put("cd", cd);
		    parameters.put("cat", cat);
		    parameters.put("year",year);
		    IreportToExcelFile(request, response, "purchase.jasper", parameters);  
		} else {
            System.out.println("Requestfor parameter not obtained...");
        } 
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub	
		HttpSession session=request.getSession(false);
        String reqfor=(String)request.getParameter("requestfor");
        String userid = (String)session.getAttribute("IdCode");
        System.out.println("Requestfor parameter obtained:"+reqfor);
        Map<String, String> parameters=new HashMap<String, String>();
		if(reqfor.equals("paycomreport")) {
            String idcode1=(String)request.getParameter("idcode1");
            String idcode2=(String)request.getParameter("idcode2");
            String month=(String)request.getParameter("month");
            String year=(String)request.getParameter("year");
            String date="01-"+month+"-"+year;
            parameters.put("IDC1", idcode1);
            parameters.put("IDC2", idcode2);
            parameters.put("DT", date);
            IreportToExcelFile(request, response, "special_rec_comparison_excel.jasper", parameters);
        }else {
            System.out.println("Requestfor parameter not obtained...");
        }
	}

	  protected void IreportToExcelFile(HttpServletRequest request, HttpServletResponse response, String repfilename, Map repparams) throws IOException {
	    	try
	    	{
	    	System.out.println("In IreportToExcelFile...");	
	    	Connection con = null;
	        con=ds.getConnection();
	        File reportFile = new File(getServletContext().getRealPath("/reports/jrf") + "/" + repfilename);    
	    	String path = reportFile.getAbsolutePath(); 
	    	JasperPrint jasperPrint = JasperFillManager.fillReport ( path,repparams, con); 
	    	byte bytes[] = new byte[10];
	        JRXlsExporter exporter = new JRXlsExporter();
	    	ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();
	    	exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
	    	exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport);
	    	exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
	        exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
	        exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
	    	exporter.exportReport();
	    	bytes = xlsReport.toByteArray();
	    	response.setContentType("application/vnd.ms-excel");
	    	response.setContentLength(bytes.length);
	    	xlsReport.close();
	    	OutputStream ouputStream = response.getOutputStream();
	    	ouputStream.write(bytes, 0, bytes.length);
	    	ouputStream.flush();
	    	ouputStream.close();
	    	}
	    	catch(Exception e)
	    	{e.printStackTrace();}

	    }
}

I also mapped servlet in web.xml

<servlet>
   	<servlet-name>ExcelReportServlet</servlet-name>
   	<display-name>ExcelReportServlet</display-name>
   	<description></description>
   	<servlet-class>ExcelReportServlet</servlet-class>
   </servlet>
        <servlet-mapping>
        	<servlet-name>ExcelReportServlet</servlet-name>
        	<url-pattern>/ExcelReportServlet</url-pattern>
        </servlet-mapping>

But now when I try to access servlet I got error 'servlet is not available'
In log i got following error

signature: (Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljava/lang/String;Ljava/util/Map;)V) Incompatible argument to function

I a trying to access servlet by code "/datanet/ExcelReportServlet"

Please help.

[Tim Moores]

If parameters is defined as Map<String, String>, then so should repparams.

[sarita rane]

Thanks for reply

similar function is also use in another servlet , and that is working fine.
as follows:

protected byte[] buildReport(String filename, Map params) throws JRException, SQLException {
        Connection con = null;
        con=ds.getConnection();
        
        File reportFile = new File(getServletContext().getRealPath("/reports/jrf") + "/" + filename);
        if (!reportFile.exists())
            throw new JRRuntimeException(reportFile.getPath()+" - File not found.");
        JasperPrint jasperprint = JasperFillManager.fillReport(reportFile.getPath(), params, con);
        byte[] pdfinbytes = JasperExportManager.exportReportToPdf(jasperprint);
        con.close();
        return pdfinbytes;
        
    }//end buildReport

One more thing program is running in linux machine with jdk 1.5

[sarita rane]

I use POI lib. version is 2.5.

Log content are as follows:


SEVERE: Allocate exception for servlet ExcelReportServlet
java.lang.VerifyError: (class: ExcelReportServlet, method: IreportToExcelFile signature: (Ljavax/servlet/http/HttpServletRequest;Ljavax/servlet/http/HttpServletResponse;Ljava/lang/String;Ljava/util/Map;)V) Incompatible argument to function
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2328)
at java.lang.Class.getConstructor0(Class.java:2640)
at java.lang.Class.newInstance0(Class.java:321)
at java.lang.Class.newInstance(Class.java:303)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1055)
at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)


Is this version issue? what version POI I should user for jdk1.5 in linux machine

[Sumit Patil]

You are using POI lib version 2.5, can you please check if the classpath is referring to this version or some other version of POI lib.
Try to compile your servlet in some other machine and then run it.

Check This

[Tim Moores]

Regardless of what else is going on, run -don't walk- to upgrade POI to something much more recent, like version 3.8. 2.5 has been obsolete for a very, very long time.