Have you considered Cyrstal reports. This would be more suitable for graphing.
It contains applet support. It can hook in directly with your WebServer, to
generate either HTML or Java. Crystal reports can communicate with many types
of databases. It might make sense to have some automatic generation of reports
on a daily basis (i.e in HTML with Java Graphing Components), and then during
the day users will retrieve static data, with no further hits to the database.
Having said all that, this is a very proprietary solution, and may not scale.
Consideration must be given to how fast your data is changing in your database.
EBJ does not neccessarily provide good caching, it's EJB vendor dependent. The
DBMS itself performs caching, you should consider that in the equation, and try
and optimize on caching within the database application. EJB Caching should be
applied to a more complex application.
Ed.
"Booth, Peter" wrote:
> Hello,
>
> I welcome any opinions on whether the following small project
> sounds like a suitable pilot EJB project:
>
> I have an applet that currently uses cgi to connect to a legacy
> graphing application on a web server. The graphing application
> queries a database and produces line graphs as pdf files.
>
> My project is to replace the legacy graphing app with an N tiered
> graphing app. I had initially planned to use servlets to read data via
> JDBC and return the time series data to the applet, which would build
> the graph objects using a third party tool. The app is not really
> transactional
> in nature, I am interested in evaluating EJB technology with a project
> where there is some pay-off.
>
> Is there any gain in using entity EJBs to read data from a database?
> The database stores a historical set of data points and is written to on
> a daily basis. A typical graph would involve reading say eight curves
> each with 2000 points. There will be perhaps 30 concurrent users.
> Would EJB make it any easier to cache commonly used data?
>
> Any opinions welcome.
>
> Peter Booth
> [EMAIL PROTECTED]
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
