SQLDatabaseRetrieval (Apache OODT 0.7 API)

java.lang.Object
- org.apache.oodt.commons.activity.SQLDatabaseRetrieval

All Implemented Interfaces:

Retrieval
```
public class SQLDatabaseRetrieval
extends Object
implements Retrieval
```
This class enables retrieval of activity incidents from 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.SQLDatabaseRetrieval.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.SQLDatabaseRetrieval.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.SQLDatabaseRetrieval.user
  Must contain the user name for the target database.
- org.apache.oodt.commons.activity.SQLDatabaseRetrieval.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.1 $

Author:

S. Hardman

- Constructor Summary
  
  Constructors
  Constructor and Description
  SQLDatabaseRetrieval()
  This constructor grabs the necessary system properties for the database connection.
- Method Summary
  
  Methods
  Modifier and Type Method and Description
  static void main(String[] argv)
  Execute the SQLDatabaseRetrieval class via the command-line.
  
  List retrieve()
  Retrieve the list of activities.
  - Methods inherited from class java.lang.Object
    clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructors
Constructor and Description
`SQLDatabaseRetrieval()` This constructor grabs the necessary system properties for the database connection.

Methods
Modifier and Type	Method and Description
`static void`	`main(String[] argv)` Execute the SQLDatabaseRetrieval class via the command-line.
`List`	`retrieve()` Retrieve the list of activities.

- Constructor Detail
  - SQLDatabaseRetrieval
```
public SQLDatabaseRetrieval()
```
    This constructor grabs the necessary system properties for the database connection.
- Method Detail
  - retrieve
```
public List retrieve()
              throws ActivityException
```
    Retrieve the list of activities.
    
    Specified by:
    
    retrieve in interface Retrieval
    
    Returns:
    A list of StoredActivity classes.
    
    Throws:
    
    ActivityException - If an error occurs opening or accessing the database.
  - main
```
public static void main(String[] argv)
```
    Execute the SQLDatabaseRetrieval class via the command-line. The program exits with status 0 on success, 1 on failure.
    
    Parameters:
    argv - The command-line arguments.

Class SQLDatabaseRetrieval

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

SQLDatabaseRetrieval

Method Detail

retrieve

main