<%@ page language="java"%>
 
<%@page import="org.jfree.chart.*;"%>
<%@page import="java.sql.DriverManager;"%>
<%@page import="java.sql.*;"%>
<%@page import="org.jfree.data.jdbc.*;"%>
<%@page import="org.jfree.data.general.*;"%>
 
<%!
public class votepie {
 
    /**
     * @param args
     */
    
    private PieDataset readData() {
        JDBCPieDataset data = null;
        String url = "jdbc:mysql://localhost/vote";
        Connection con;
        try {
        Class.forName("com.mysql.jdbc.Driver");
        }
        catch (ClassNotFoundException e) {
        System.err.print("ClassNotFoundException: ");
        System.err.println(e.getMessage());
        }
        try {
        con = DriverManager.getConnection(url, "vote", "vote001");
        data = new JDBCPieDataset(con);
        String sql = "SELECT option_text, counter FROM VOTE_VOTES where poll_id=1;";
        data.executeQuery(sql);
        con.close();
        }
        catch (SQLException e) {
        System.err.print("SQLException: ");
        System.err.println(e.getMessage());
        }
        catch (Exception e) {
        System.err.print("Exception: ");
        System.err.println(e.getMessage());
        }
        return data;
        }
        
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        
        votepie pd = new votepie();
        pd.readData();
        
        //creating the chart
        JFreeChart chart = ChartFactory.createPieChart(
                "Sample Pie Chart",
                pd.readData(),
                true, // legend?
                true, // tooltips?
                false // URLs?
                );
                // create and display a frame...
                ChartFrame frame = new ChartFrame("First", chart);
                frame.pack();
                frame.setVisible(true);
 
    }
 
}
%>

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: 44 in the jsp file: /viewrst.jsp
The method main cannot be declared static; static methods can only be declared in a static or top level type
41:         }
42:         return data;
43:         }
44:     public static void main(String[] args) {
45:         // TODO Auto-generated method stub
46:         
47:         votepie pd = new votepie();


Stacktrace:
    org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
    org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
    org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
    org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
    org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
    org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
    org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:308)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.10 logs.
Apache Tomcat/6.0.10