I'm getting java.lang.ArrayIndexOutOfBoundsException
when using the code above in jsp file:
<%@ page import="java.util.*, java.sql.*, com.jrefinery.chart.*, com.jrefinery.chart.data.*, com.jrefinery.data.*, java.awt.*" contentType="image/jpeg"%>
<%
Connection con = ... // get some connection
OutputStream out_ = response.getOutputStream();
JFreeChart chart;
JdbcXYDataset data = new JdbcXYDataset( con );
data.executeQuery("SELECT O.OBJECT, COUNT(CO.ID_DIRECTORY), SUM(CO.VALUE) FROM OBJECTS O, CONTEXTOBJETCS CO WHERE O.ID_OBJECT = CO.ID_OBJECT GROUP BY O.OBJECT HAVING COUNT(CO.ID_DIRECTORY) > 200");
chart = ChartFactory.createLineXYChart("Total of Directories per Object", "Object", "Total Directories", data, false, false, false);
chart.setBackgroundPaint(Color.white);
chart.setAntiAlias(true);
ChartUtilities.writeChartAsJPEG(out_, 1.0f, chart, 400, 400);
out_.close();
con.getConnection().close();
%>
Am I doing something wrong??!?!
ArrayIndexOutOfBoundsException
Re: ArrayIndexOutOfBoundsException
Nothing obvious. Can you post the full exception message?
Regards,
Dave Gilbert
Regards,
Dave Gilbert
Re: ArrayIndexOutOfBoundsException
I get a java.lang.ArrayIndexOutOfBoundsException when the code executes the line
data.executeQuery("SELECT O.OBJECT, COUNT(CO.ID_DIRECTORY), SUM(CO.VALUE) FROM OBJECTS O, CONTEXTOBJETCS CO WHERE O.ID_OBJECT = CO.ID_OBJECT GROUP BY O.OBJECT HAVING COUNT(CO.ID_DIRECTORY) > 200");
data.executeQuery("SELECT O.OBJECT, COUNT(CO.ID_DIRECTORY), SUM(CO.VALUE) FROM OBJECTS O, CONTEXTOBJETCS CO WHERE O.ID_OBJECT = CO.ID_OBJECT GROUP BY O.OBJECT HAVING COUNT(CO.ID_DIRECTORY) > 200");