Hello again,
Lets suppose that I have a SQL Server database which constantly becomes populated with XML or just normal data containing statistical information.
Now, lets say that I want to create a system in which this data will be pulled from the database (of course, using
JDBC) and create XML feeds or normal data to a
JSP page (which will display these statistics)...
What is the *BEST* way to go about doing this?
- Web services (if so which API)?
- Is there a JSP taglib which parses XML or generates aggregated feeds?
- Any open source frameworks?
- How about XSLT?
- Should I be using RSS?
Basically, what the advice that I seek is what is the best way to aggregate data into a tabular format in a JSP page from a SQL Server database? This statistics page automatically runs in the server (perhaps JMS?), and the only user interaction would be to click on the links on the top of the columns which would sort the data (e.g. greatest to least or least to greatest; ascending / descending order).
Any suggestions, tips, and comments are greatly appreciated!
