j'ai un report jasper que j'appelle depuis un servlet en passant une requete SQL mais il me genère rien
voilà le code

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
private String DOWNLOAD_FILE_NAME = "REPORT.pdf";
private String FILE_TYPE = "application/pdf";
 
 
public void print(String numBac , HttpServletRequest request,
      HttpServletResponse response) {
        try {          
            JasperDesign jasperDesign = JRXmlLoader
                    .load("fiche.jrxml");
            String sql = "SELECT * FROM etudiant "
                    + "INNER JOIN filiere ON etudiant.code_f=filiere.code_f "
                    + "INNER JOIN lieu_nais ON etudiant.code_lieu=lieu_nais.code_lieu "
                    + "INNER JOIN montant ON etudiant.code_m=montant.code_m WHERE bac='"
                    + numBac + "'";
            JRDesignQuery newQuery = new JRDesignQuery();
            newQuery.setText(sql);
            jasperDesign.setQuery(newQuery);
            JasperReport report = JasperCompileManager
                    .compileReport(jasperDesign);
            //JasperPrint print = JasperFillManager.fillReport(report, null, cnx);
            //JasperViewer.viewReport(print);
 
            byte[] byteStream;
            byteStream = JasperRunManager.runReportToPdf(report, null, cnx);
            OutputStream outStream = response.getOutputStream();
            response.setHeader("Content-Sisposition", "inline,filename="+DOWNLOAD_FILE_NAME);
            response.setContentType(FILE_TYPE);
            response.setContentLength(byteStream.length);
            outStream.write(byteStream, 0, byteStream.length);
 
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
j'appelle cette méthode depuis ce code
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            //appel de la méthode
            print(e.getBac(),request,response);
 
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Servlet Edit</title>");
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>M/Mlle. " + e.getNom() + "</h1> </br>");
            out.println("<h1>" + msg + "</h1>");
            out.println("<h1>page <a href='index.jsp'>pricipale</h1>");
            out.println("</body>");
            out.println("</html>");
        } finally {
            out.close();
        }
    }