Access datasource in Quartz job running under Struts 1.x

[Karl Larsson]

I found a tutorial here http://www.mkyong.com/struts/struts-quartz-scheduler-integration-example/ on how to enable Quartz under Struts 1.x. It works like a charm with a few modifications for Quartz 2.1.

Now I get a "Hello World" in my logs.

However, I want to access the database inside my Job. How do I do that? How can I get hold of a Datasource object like I do inside an Action?

struts-config.xml
<plug-in className="foo.bar.struts.plugin.QuartzPlugin" />

QuartzPlugin.java

package foo.bar.struts.plugin;

import java.text.ParseException;
import java.util.Map;

import javax.servlet.ServletException;

import org.apache.struts.action.ActionServlet;
import org.apache.struts.action.PlugIn;
import org.apache.struts.config.ModuleConfig;
import org.quartz.*;
import foo.bar.struts.quartz.SchedulerJob;
import foo.bar.struts.quartz.SchedulerTask;
import static org.quartz.JobBuilder.*;
import static org.quartz.TriggerBuilder.*;
import static org.quartz.DateBuilder.*;
import static org.quartz.SimpleScheduleBuilder.*;
import org.quartz.impl.*;

public class QuartzPlugin implements PlugIn {

    @Override
    public void destroy() {
        //null
    }

    @Override
    public void init(ActionServlet servlet, ModuleConfig config)
        throws ServletException {

        SchedulerTask task = new SchedulerTask();

        JobDetail job = newJob(SchedulerJob.class)
            .withIdentity("jobName", "groupName")
            .storeDurably()
            .requestRecovery()
            .build();

        Map dataMap = job.getJobDataMap();
        dataMap.put("schedulerTask", task);

        try {
            Trigger trigger = newTrigger()
                .withIdentity("runMeJobTesting")
                .startAt(futureDate(10, IntervalUnit.SECOND))
                .withPriority(6)
                .forJob(job)
                .withSchedule(simpleSchedule()
                .withIntervalInSeconds(30)
                .repeatForever())
                .build();

            Scheduler scheduler = new StdSchedulerFactory().getScheduler();
            scheduler.start();
            scheduler.scheduleJob(job, trigger);
        } catch(Exception e) {
            e.printStackTrace();
        }
    }
}

SchedulerJob.java

package foo.bar.struts.quartz;

import java.util.Map;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

public class SchedulerJob implements Job {
    public void execute(JobExecutionContext context)
        throws JobExecutionException {

        Map dataMap = context.getJobDetail().getJobDataMap();
        SchedulerTask task = (SchedulerTask) dataMap.get("schedulerTask");
        task.printMessage();
    }
}

SchedulerTask.java

package foo.bar.struts.quartz;

public class SchedulerTask {
     public void printMessage() {
         System.out.println("Struts + Quartz integration example ~");
     }
}

[Joe Ess]

Are you talking about the Struts Datasource? That was retired in Struts 1.2.7. Since Struts is an implementation of the Front Controller Pattern, it didn't make sense to manage "back end" resources like database connections. There is no way to access a Struts Datasource outside the Struts web app.
Depending on your servlet container, you may be able to configure a database pool to be available to outside processes (Weblogic can, Tomcat cannot).