Hi
The Cewolf forum is very slow in responding to help. So I'm seeking
your help who had experienced with Cewolf.
Bean - JDBCXYTest
=================================
package de.laures.cewolf.example;
import java.util.Map;
import java.io.Serializable;
import de.laures.cewolf.DatasetProduceException;
import de.laures.cewolf.DatasetProducer;
import de.laures.cewolf.CategoryItemLinkGenerator;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import com.jrefinery.chart.JFreeChart;
import com.jrefinery.chart.ChartFactory;
import com.jrefinery.data.XYDataset;
import com.jrefinery.data.JdbcXYDataset;
public class JDBCXYTest implements DatasetProducer, Serializable {
private static XYDataset data;
public JDBCXYTest() {
XYDataset data = readData();
}
private XYDataset readData() {
JdbcXYDataset data = null;
String url = "jdbc:mysql://localhost"; + "/" + "test4";
Connection con;
try {
Class.forName("org.gjt.mm.mysql.Driver");
}
catch (ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
con = DriverManager.getConnection(url, "test1", "abc");
data = new JdbcXYDataset(con);
String sql = "SELECT * from try4;";
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 synchronized Object produceDataset(Map params) throws DatasetProduceException {
return data;
}
==================================
url I use for displaying
http://127.0.0.1:8080/HSP/jdbc_xy_demo.jsp
(with Guido's tutorial PageViewCount,
I was able to display the image). With my
modified jsp file, I cant seem to get it work.
bash-2.03# cat jdbc_xy_demo.jsp
<%@page contentType="text/html"%>
<%@taglib uri='/WEB-INF/cewolf.tld' prefix='cewolf' %>
<HTML>
<BODY>
<H1>Page View Statistics</H1>
<HR>
<jsp:useBean id="xytest" class="JDBCXYTest"/>
<cewolf:chart
id="line"
title="Page View Statistics"
type="xy"
xaxislabel="Page"
yaxislabel="Views">
<cewolf:data>
<cewolf:producer id="xytest" />
</cewolf:data>
</cewolf:chart>
<cewolf:img chartid="line" renderer="cewolf" width="800" height="800">
<cewolf:map id="xytest"/>
</cewolf:img>
</BODY>
</HTML>
Browser displays following errors:
====================================
Apache Tomcat/4.0.3 - HTTP Status 500 - Internal Server Error
type Exception report
message Internal Server Error
description The server encountered an internal error (Internal Server Error) that prevented it from fulfilling this
request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
An error occurred at line: 7 in the jsp file: /jdbc_xy_demo.jsp
Generated servlet error:
/tomcat4_0_3/jakarta-tomcat-4.0.3/work/localhost/HSP/jdbc_0005fxy_0005fdemo$jsp.java:64: Class org.apache.jsp.JDBCXYTest not found.
JDBCXYTest xytest = null;
^
An error occurred at line: 7 in the jsp file: /jdbc_xy_demo.jsp
Generated servlet error:
/tomcat4_0_3/jakarta-tomcat-4.0.3/work/localhost/HSP/jdbc_0005fxy_0005fdemo$jsp.java:67: Class org.apache.jsp.JDBCXYTest not found.
xytest= (JDBCXYTest)
^
An error occurred at line: 7 in the jsp file: /jdbc_xy_demo.jsp
Generated servlet error:
/tomcat4_0_3/jakarta-tomcat-4.0.3/work/localhost/HSP/jdbc_0005fxy_0005fdemo$jsp.java:72: Class org.apache.jsp.JDBCXYTest not found.
xytest = (JDBCXYTest) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "JDBCXYTest");
^
3 errors, 1 warning
==================================================
What did I do wrong ?
Any help is appreciated