create bar chart in jsp using msaccess database
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: 8 in the jsp file: /bar.jsp
Generated servlet error:
C:\Program Files\Apache Software Foundation\Tomcat 5.0\work\Catalina\localhost\chetana\org\apache\jsp\bar_jsp.java:57: cannot find symbol
symbol : constructor JDBCCategoryDataset(java.lang.String,java.lang.String)
location: class org.jfree.data.jdbc.JDBCCategoryDataset
An error occurred at line: 8 in the jsp file: /bar.jsp
Generated servlet error:
JDBCCategoryDataset dataset = new JDBCCategoryDataset("jdbc:odbc:Driver={Microsoft Access Driver(.mdb,.accdb)};DBQ=C:\mithu.accdb", "sun.jdbc.odbc.JdbcOdbcDriver");
^
1 error
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
View Answers
April 2, 2011 at 3:58 PM
Follow these steps:
1)Go to the start->Control Panel->Administrative Tools-> data sources.
2)Click Add button and select the driver Microsoft Access Driver(*.mdb).
3)After selecting the driver, click finish button.
4)Then give Data Source Name and click ok button.
5)Your DSN will get created.
6) Restart your server and run given jsp code.
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="org.jfree.data.*" %>
<%@ page import="org.jfree.chart.*" %>
<%@ page import="org.jfree.chart.plot.PlotOrientation"%>
<%@ page import="org.jfree.data.jdbc.JDBCCategoryDataset"%>
<%
String query="SELECT * from chart";
JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:odbc:student","sun.jdbc.odbc.JdbcOdbcDriver","","");
dataset.executeQuery(query);
JFreeChart chart = ChartFactory .createBarChart3D(
"Test",
"Id",
"Score",
dataset,
PlotOrientation.VERTICAL,true, true, false);
ChartFrame frame1=new ChartFrame("Bar Chart",chart);
frame1.setVisible(true);
frame1.setSize(350,450);
%>
Here student is our dsn and chart is table.
Ads
Related Tutorials/Questions & Answers:
create bar chart in jsp using msaccess database
create bar chart in
jsp using msaccess database type Exception... Foundation\Tomcat 5.0\work\Catalina\localhost\chetana\org\apache\
jsp\
bar_jsp.java:57...
org.apache.jasper.JasperException: Unable to compile class for
JSP
An error occurred at line: 8 in the
jsp
create bar chart in jsp using msaccess database
create bar chart in
jsp using msaccess database thanks for reply...)
org.apache.jsp.bar<em>
jsp.</em>jspService(
bar_jsp.java:57... ChartFrame("
Bar Chart",
chart);
frame1.setVisible(true);
frame1.setSize(350,450);
%>
Advertisements
how to create bar chart in jsp using msaccess database
how to
create bar chart in
jsp using msaccess database type... Foundation\Tomcat 5.0\work\Catalina\localhost\chetana\org\apache\
jsp\
bar_jsp.java...
org.apache.jasper.JasperException: Unable to compile class for
JSP
An error occurred at line: 10
How to create bar chart using database values
How to
create bar chart using database values How to
create bar chart using database values i.e excellent,good,average fields
using jsp?It is like opinion poll.I want to show how many votes are came for excellent,good,average
Create a bar chart in JSP page using JFreeChart
Create a
bar chart in
JSP page
using JFreeChart... to
create a
bar chart in
JSP page
using JFreeChart. Code given below creates a
bar chart... extended class ApplicationFrame to
create a frame and also pass a string value
Bar Chart using JSP and tooltip to be implemented
Bar Chart using JSP and tooltip to be implemented Hi Deepak,
I have generated a
bar chart in
JSP using JFreeCharts but I could not get the tool tip for that. Please any one suggest me how to do that or provide some code.
Help
Create a 3D bar chart in JSP page using JFreeChart
Create a 3D
bar chart in
JSP page
using JFreeChart... to
create a 3D
bar chart in
jsp page
using JFreeChart. Code given below creates a
bar chart of scores of two teams in matches.
In the code given below
Create a Pie Chart in jsp Page using JFree Chart
Create a Pie
Chart in
jsp Page
using JFree Chart Hello Sir I followed ur tutorial on "
CREATE A PIE
CHART IN
JSP PAGE
USING JFREE
CHART... the pie
chart report and after that save it to the desired location.Kindly help me
Create a pie chart in jsp page using JFreeChart
Create a pie
chart in
jsp page
using JFreeChart... to
create a pie
chart in
jsp page
using JFreeChart. Code given below creates... is used to
create bar chart for given values. It
takes title, category axis label
how to create database and table using jsp
how to
create database and table
using jsp hi frnds....,
i want to
create database and table in mysql
using jsp.... i have an registration form(name... table
using jsp code... the table name should be the name of the person
Stacked Bar Chart using JFreeChart
Stacked
Bar Chart using JFreeChart
 ...
bar chart using
JFreeChart.
In the code given below we have extended class....
createStackedBarChart(): This method is used to
create stacked
bar chart for given values
Stacked Bar Chart Example using JFreeChart
Stacked
Bar Chart Example
using JFreeChart... a Stacked
bar chart using JFreeChart.
Bar chart will represent scores
of two team... to
create stacked
bar chart for given values.
It
takes title, domain axis
get data between date using jsp with msaccess
get data between date
using jsp with msaccess hi, urgently i need program for get data between date
using jsp with
MsAccess database.plz any one can help me.thanks for anyone replay with regards c.b.chellappa
Create area chart in JSP page using JFreeChart
Create area
chart in
JSP page
using JFreeChart... to
create a area
chart in
JSP page
using JFreeChart. Code given below creates a area...(): This method is used to
create bar chart for given values. It
takes title
bar chart
bar chart how to
create a
bar chart from values of the
database and the string value should be the entities of the
database??plzz help..needed badly
Stacked 3d Bar Chart Example using JFreeChart
Stacked 3d
Bar Chart Example
using JFreeChart... a Stacked 3d
bar chart using JFreeChart.
Bar chart will represent the score... is used to
create stacked
bar chart for given values. It takes title, domain
java with jsp and dynamic database retrival for bar charts
java with
jsp and dynamic
database retrival for
bar charts Hi,
I...,sessionid,ip_address,logout.
so,can any one help me out how to get the
bar chart dynamically for the table values logintime and userid from
database.. can u please
Horizontal Bar Chart Example using JFreeChart
Horizontal
Bar Chart Example
using JFreeChart... a
Horizontal
bar chart using JFreeChart. This
example showing you match....
createBarChart():
This method is used to
create bar chart for given values
Bar Chart
;
In this section we are providing you an example to
create a
Bar Chart... for a
Bar chart we have to
create an object of DefaultCategoryDataset type...);
After added the data in dataset we
create the
Bar chart by invoking
Stacked Bar Chart
Stacked
Bar Chart How to display a stacked
bar chart using java from the values stored in the ms access
database?Plzz help..its urgent
How to create an area chart using jfreecharts?
How to
create an area
chart using jfreecharts? i want to
create an area
chart that represents ip addresses of top countries. i have gone thru the area
chart example
using jfreechart but i am still not clear with its method.
If u
Create a polar chart using JFreeChart
Create a polar
chart using JFreeChart
 ...(): This method is used to
create bar chart for given values. It
takes title, dataset... a polar
chart using JFreeChart. Code given below creates a simple
polar
chart
how to create using jsp
how to
create using jsp code 1:
<%@ page language="java...;
<title>
Create New Student</title>
</head>
<body>
<form name="
create" method="post" action="<