Java Programming

well hi guys......i want to view a piechart extracting items from a mysql database. i've created a button on a jsp page(view.jsp) which is calling another jsp page(viewrst.jsp) when i click that. the code for that is given below:

<%@ 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 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);

	}

}
%>

& i'm getting this error when I click the button:

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: 





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.

is the prob related to classpath variables?i have this

 PATH=
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\system32\WBEM;C:\Program Files\Java\jdk1.6.0_01\bin

the java is working when i run it, but not in jsp. please suggest what to do?......thankz

Message was edited by:
apontutul