The reports hopefully will not take 20 mins, but im excepting maybe 10 mins each, i will have a think about JMS. I am going to read up on EhCache, i know i use it with hibernate, but writing a custom solution will be interesting. Does EhCache sound like it might help me with preventing duplications. This was my major worry for this app. Also i think i have to use JDBC, becuase the fact that the users supply the sql, the query could be a join of 10 tables for all i know, i think JDBC is my only option, run the query, get a result set back and build an html table and pop it in a mail.
mraible wrote: > > 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] > > > -- View this message in context: http://www.nabble.com/architecture-question-to-appfuse-users.-tf4074933s2369.html#a11582148 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
