Is it possible ? Schedule + Run a report

[matias casal]

Hello
I am making and schedule job (quartz libraries) and I have the following doubt.

I have this code in a class which is load in a jsp page.

 
public void execute(JobExecutionContext context)throws JobExecutionException {
    System.out.println("Impresion automatica");
    }
}    

And the jsp

   JobDetail jobDetail =
                                new JobDetail("jobDetail-s1", "jobDetailGroup-s1", quartz.SimpleQuartzJob.class);
                        SimpleTrigger simpleTrigger =
                                new SimpleTrigger("simpleTrigger", "triggerGroup-s1");

                        simpleTrigger.setStartTime(new Date());

                        simpleTrigger.setRepeatInterval(10000);

                        simpleTrigger.setRepeatCount(100);
                        scheduler.scheduleJob(jobDetail, simpleTrigger);

                        // start the scheduler
                        scheduler.start();
  

It works perfectly, but I would like to know if instead of

  System.out.println("Impresion automatica");  

in the execute method I could run something execute a web ( like a href)
src="report?report1&outputFormat=html

[Jeanne Boyarsky]

Matias,
You could open a UrlConnection in the execute method. Is the web page in the same application as the scheduler? If so, you could skip the URL and call the action directly.

[Deepak Bala]

Is that code sitting inside a JSP ? eek ! Never write code inside a JSP

And if you are looking for a reporting solution, have you considered crystal reports / Jasper / BIRT ? You could in theory run reports at regular intervals and export them in a variety of formats by opening a URLConnection

[matias casal]

This code is in a servlet.
I am using pentaho reporting. Report designer 3.5. .prpt files.
I will try with the url connection
Thank you!