org.apache.oodt.commons.activity

Class SQLDatabaseStorage

java.lang.Object

org.apache.oodt.commons.activity.SQLDatabaseStorage

All Implemented Interfaces:

Storage

public class SQLDatabaseStorage
extends Object
implements Storage

This class enables storage of activity incidents in just about any database management system. It should support MySQL, PostgreSQL, Oracle and Sybase.

This class uses the following properties:

• org.apache.oodt.commons.activity.SQLDatabaseStorage.driver
  Must contain the name of the JDBC driver class. See the following examples:
  • com.mysql.jdbc.Driver
  • org.postgresql.Driver
  • oracle.jdbc.driver.OracleDriver
  • com.sybase.jdbc2.jdbc.SybDriver
• org.apache.oodt.commons.activity.SQLDatabaseStorage.url
  Must contain the URL specification for the target database. See the following examples:
  • jdbc:mysql://host:port/database
  • jdbc:postgresql://host:port/database
  • jdbc:oracle:thin:@host:port:database
  • jdbc:sybase::Tds:host:port/database
• org.apache.oodt.commons.activity.SQLDatabaseStorage.user
  Must contain the user name for the target database.
• org.apache.oodt.commons.activity.SQLDatabaseStorage.password
  Must contain the password for the target database.

This class expects the following table to exist in the target database (data types will vary depending on the vendor):

 create table incidents (
          activityID varchar(32) not null,
          className varchar(255) not null,
          occurTime bigint not null default 0,
          detail text null,
          primary key (activityID, className, occurTime))
 

Version:

$Revision: 1.2 $

Author:

S. Hardman

Constructor Summary

Constructors

Constructor and Description
SQLDatabaseStorage() Constructor given no arguments.

Method Summary

Modifier and Type	Method and Description
static String	escapeSingleQuote(String inputString) This method will escape any single quotes found in the input string and return the escaped string.
void	finalize() This method closes the database connection.
void	store(String id, List incidents) This method stores the list of incidents for the activity in the database table named "incidents".

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLDatabaseStorage

public SQLDatabaseStorage()

Constructor given no arguments. This constructor grabs the necessary system properties and opens the database connection based on the property values.

Method Detail

store

public void store(String id,
                  List incidents)

This method stores the list of incidents for the activity in the database table named "incidents".

Specified by:

store in interface Storage

Parameters:

id - The activity identifier.

incidents - A list of Incident.

finalize

public void finalize()
              throws Throwable

This method closes the database connection.

Overrides:

finalize in class Object

Throws:

Throwable - If something goes wrong.

escapeSingleQuote

public static String escapeSingleQuote(String inputString)

This method will escape any single quotes found in the input string and return the escaped string. This will ready the string for insertion into a database. The single quote is escaped by inserting an additional single quote in front of it in the string. If some considerate developer has already escaped the single quotes in the input string, this method will essentially do nothing.

Parameters:

inputString - The string to be escaped.

Returns:

The escaped string.