Dynamic PDF reports from SQL data via JSP Tomcat

[Pierre Lessard <pe...@swissmail.org>]

Hello!

I'm just new to FOP, but already succeeded in embeding FOP in a JSP.

But now, would like to know the best way with the minimum install possible to generate PDF reports based on a SQL select request? In this by calling a JSP page from Tomcat? Can anyone can tell me the way?

XML report template 
----(SQL select from a database)---> 
XML report with the data 
----(XSL style sheet)---->
PDF generated on the fly with JSP

is this possible? any better way to do it?

What JAR to install?
What API or other packages like XALAN ?


Thank you!

Pete