Joe Weakliam

Hi Ulf

Apologies for the uninformative topic title! It won't happen again.

Just to clarify a few issues I still have regarding my original post. My overall application would be developed using different aspects of Java.

In other words I would first use JDBC to (1) connect to the database,
(2) imbed SQL queries to retrieve the relevant data, and (3) manipulate the resultset.

I would then use Jasper/cewolf depending on my specific requirements to generate different styles of graphs/charts based on the resultset produced? The graphs would need to be generated in different formats, i.e. pdf, jpeg, tiff, etc. and then inserted into Web pages, pdf documents, etc. (I have not totally decided how the output will be presented at this point).

Do I need to use JSP at all if I decide to use cewolf? Where might the JSP fit in?

Thanks a lot for your help

Joe

Hi there

I am just looking for a bit of sound advice before I start developing my application. In essence what I am trying to do is quite simple. I have a whole stack of tables stored in a database and I want to display the results of (SQL) queries in a Web-based application in a variety of different graphical formats, i.e. line graphs, pie-charts, bar-charts (standard enough formats - nothing too fancy), etc.

I did a little research on the Web and came across JSP and JASPER Reports which I know absolutely nothing about but appear to be relatively straighforward and some of the better tools to use for this kind of thing. I am quite familiar with Java in general so I assume that this would help a lot.

Can anybody give me some useful pointers as to whether
JSP and JASPER are the best choice of tools for generating graphs
from database tables and displaying them in Web-based formats. Also, I assume that one would connect to the database using JDBC or does JSP use its own syntax for establishing connections?

Thanks for your help

Joe


[BPSouther: Added a meaningful subject line]
[ November 10, 2008: Message edited by: Ben Souther ]