try {
JDBCXYDataset ds = new JDBCXYDataset(DatabaseManager.getConnection());
ds.executeQuery("Select eventdate, (replace(TotalAXSuccess,0,1)/replace(TotalAXReceived,0,1) * 100) as SuccessRate, 90 as Target from DailyProcessedQuery");
JFreeChart chart = ChartFactory.createTimeSeriesChart
("AX Success Rate", // Title
"Date", // X-Axis label
"Percentage", // Y-Axis label
ds, // Dataset
true, // Show legend
true,
true
);
XYItemRenderer renderer = new VerticalXYBarRenderer();
chart.getXYPlot().setRenderer(renderer);
ChartUtilities.saveChartAsJPEG(new File("AXPercentageSuccess1.jpg"), chart, 1000, 600);
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception ex) {
ex.printStackTrace();
}
}
===========================================
I get the following error stack .......
java.lang.ClassCastException: com.jrefinery.data.JDBCXYDataset
at com.jrefinery.chart.renderer.VerticalXYBarRenderer.drawItem(Unknown Source)
at com.jrefinery.chart.plot.XYPlot.render(Unknown Source)
at com.jrefinery.chart.plot.XYPlot.draw(Unknown Source)
at com.jrefinery.chart.JFreeChart.draw(Unknown Source)
at com.jrefinery.chart.JFreeChart.createBufferedImage(Unknown Source)
at com.jrefinery.chart.ChartUtilities.writeChartAsJPEG(Unknown Source)
at com.jrefinery.chart.ChartUtilities.saveChartAsJPEG(Unknown Source)
at com.jrefinery.chart.ChartUtilities.saveChartAsJPEG(Unknown Source)
at testclasses.ChartMaker.percentageSuccessAX(ChartMaker.java:510)
at testclasses.ChartMaker.main(ChartMaker.java:568)