I had a friend who had to do this in a system where it took 20-30 minutes to run each report. He used JMS from a webapp to kickoff the report generation process. As far as caching, if you use JDBC, you may have to use a custom caching solution with something like EhCache, but I believe that's pretty easy to program.
Matt On 7/13/07, reddeagle9 <[EMAIL PROTECTED]> wrote:
Guys, I have been assigned a strange project that i am trying my best to thing how best to do it. Its going to be an appfuse web based reporting project where the user inputs the sql that will be run. The purpose of the tool is to alert people of certain transactions that take place. e.g someome withdraws 10,000 pounds 1) The user inputs a sql query e.g. select * from accounts where lastwithdrawal = 10000; 2) They then assign how often this report should run e.g ever 10 minutes (will use quartz) 3) When the report runs, if it generates results, do not include the results the next time the report runs (some sort of caching no idea how) 4) When the reports run, the user gets an email with results in a table format with a header per report. I am thinking i will have to use JDBCTemplates to run those reports and build an html table and attach this to an email and send to the user. I will use quartz to manage the scheduling and threading. I not sure how i will manage cache, if the report runs and generates 10 results, if the next time the report runs its generates 11, but 10 of them are the same as before i only send 1 result to the user? Any wisdom out there that could guide me to a clean solution.. I will remove this posting if it is deemed not appropriate, but on my own for this one and would love some guidance. -- View this message in context: http://www.nabble.com/architecture-question-to-appfuse-users.-tf4074933s2369.html#a11581131 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- http://raibledesigns.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
