Sample QuartzScheduler Job connecting to HSQLDB

I was cleaning up my system and looking at code samples from over the years. I came across an example Job using the Quartz Scheduler to connect to an HSQLDB database and reading the information about the session. I thought I would update it a little and post it.

Requirements:

You must have an HSQLDB database running in server mode.

package com.bluelotussoftware.quartz.example;

/*
 * HSQLJob.java
 *
 */

/*
 * Copyright (C) 2008 Blue Lotus Software. All Rights Reserved.
 *
 * THIS SOFTWARE IS PROVIDED "AS IS," WITHOUT A WARRANTY OF ANY KIND.
 * ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES,
 * INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A
 * PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. 
 * BLUE LOTUS SOFTWARE, LLC AND ITS LICENSORS SHALL NOT BE LIABLE 
 * FOR ANY DAMAGES OR LIABILITIES
 * SUFFERED BY LICENSEE AS A RESULT OF  OR RELATING TO USE, MODIFICATION
 * OR DISTRIBUTION OF THE SOFTWARE OR ITS DERIVATIVES. IN NO EVENT WILL
 * BLUE LOTUS SOFTWARE, LLC OR ITS LICENSORS BE LIABLE FOR ANY LOST 
 * REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, SPECIAL, 
 * CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED 
 * AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE 
 * OF OR INABILITY TO USE SOFTWARE, EVEN IF BLUE LOTUS SOFTWARE, LLC 
 * HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
 *
 * You acknowledge that Software is not designed, licensed or intended
 * for use in the design, construction, operation or maintenance of any
 * nuclear facility.
 */

/*
 * Copyright 2008 John Yeary
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

/**
 *
 * @author John Yeary
 * @version 1.0
*/
public class HSQLJob implements Job {

  Connection con;
  Statement s;
  ResultSet rs;
  ResultSetMetaData rsmd;

  /** Creates a new instance of HSQLJob */
  public HSQLJob() {
  }

  public void execute(JobExecutionContext context)
          throws JobExecutionException {

      try {
          Class.forName("org.hsqldb.jdbcDriver");
      } catch (Exception e) {
          System.err.println("ERROR: failed to load HSQLDB JDBC driver.");
          e.printStackTrace(System.err);
          throw new JobExecutionException("Job Could not continue bacause driver failed to load");
      }

      System.out.println("Connecting to database...");

      try {
          // This may need to be changed to match the actual database name
          con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/glassfish", "sa", "");
      } catch (SQLException e) {
          throw new JobExecutionException("Failed to connect to HSQLDB Server");
      }

      try {
          String sql = "SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SESSIONINFO";
          s = con.createStatement();
          rs = s.executeQuery(sql);
          rsmd = rs.getMetaData();
          for (int i = 1; i <= rsmd.getColumnCount(); i++) {
              System.out.print(rsmd.getColumnName(i) + "\t");
          }
          System.out.println();
          while (rs.next()) {
              for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                  System.out.print(rs.getString(i) + "\t");
              }
              System.out.println();
          }

          // Clean up the connection
          rs.close();
          s.close();
          con.close();

      } catch (SQLException e) {
          System.err.println(e.getMessage());
          while (e.getNextException() != null) {
              System.err.println(e.getMessage());
          }
      }
  }
}

package com.bluelotussoftware.quartz.example;

/*
 * QrtzScheduler.java
 *
 */

/*
 * Copyright (C) 2008 Blue Lotus Software. All Rights Reserved.
 *
 * THIS SOFTWARE IS PROVIDED "AS IS," WITHOUT A WARRANTY OF ANY KIND.
 * ALL EXPRESS OR IMPLIED CONDITIONS, REPRESENTATIONS AND WARRANTIES,
 * INCLUDING ANY IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A
 * PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE HEREBY EXCLUDED. 
 * BLUE LOTUS SOFTWARE, LLC AND ITS LICENSORS SHALL NOT BE LIABLE 
 * FOR ANY DAMAGES OR LIABILITIES
 * SUFFERED BY LICENSEE AS A RESULT OF  OR RELATING TO USE, MODIFICATION
 * OR DISTRIBUTION OF THE SOFTWARE OR ITS DERIVATIVES. IN NO EVENT WILL
 * BLUE LOTUS SOFTWARE, LLC OR ITS LICENSORS BE LIABLE FOR ANY LOST 
 * REVENUE, PROFIT OR DATA, OR FOR DIRECT, INDIRECT, SPECIAL, 
 * CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES, HOWEVER CAUSED 
 * AND REGARDLESS OF THE THEORY OF LIABILITY, ARISING OUT OF THE USE 
 * OF OR INABILITY TO USE SOFTWARE, EVEN IF BLUE LOTUS SOFTWARE, LLC 
 * HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
 *
 * You acknowledge that Software is not designed, licensed or intended
 * for use in the design, construction, operation or maintenance of any
 * nuclear facility.
 */

/*
 * Copyright 2008 John Yeary
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
import java.text.ParseException;
import org.quartz.CronTrigger;
import org.quartz.JobDetail;
import org.quartz.Scheduler;
import org.quartz.SchedulerException;
import org.quartz.SchedulerFactory;
import org.quartz.impl.StdSchedulerFactory;

public class QrtzScheduler {

  public static void main(String[] args) {
      SchedulerFactory schedulerFactory = new StdSchedulerFactory();
      Scheduler scheduler;
      try {
          scheduler = schedulerFactory.getScheduler();
          scheduler.start();

          JobDetail job = new JobDetail("hsqldb_example",
                  scheduler.DEFAULT_GROUP, HSQLJob.class);
          CronTrigger cron = new CronTrigger("cron",
                  scheduler.DEFAULT_GROUP, "0/10 * * * * ?");
          scheduler.scheduleJob(job, cron);

      } catch (SchedulerException e) {
      } catch (ParseException e) {
      }
  }
}

The Netbeans 6.1 project is located here: HSQLDBQuartzExample.zip