Enterprise Information Portal APIs

com.ibm.gcs.db.component
Class ConfigTableDef

java.lang.Object
  |
  +--com.ibm.gcs.db.component.ConfigTableDef

public class ConfigTableDef
extends java.lang.Object

This class defines the constants for the database table CONFIGTABLE. The table stores serialized XML Configuration information used by the URLs in the URL_TABLE. The table is defined by the following SQL CREATE statement:

 
  create table CONFIGTABLE(
    CONFIG_NAME varchar( 100 ) not null primary key,
    CONFIG blob( 1M )
  )
 


Field Summary
static java.lang.String CONFIG
          The serialized configuration object: CONFIG.
static java.lang.String CONFIGNAME
          A string identifying the configuration object: CONFIG_NAME.
static java.lang.String TABLE
          The table name: CONFIGTABLE.
 
Constructor Summary
ConfigTableDef()
           
 
Method Summary
static void createTable(Transaction t)
          Given a Transaction object, executes the create statements (which create the table and associated indexes on the table).
static void dropTable(Transaction t)
          Given a Transaction object, executes the drop statement.
static java.util.Enumeration getCreateIndexSQL()
          Returns the SQL CREATE statements to create the necessary indexes on the CONFIGTABLE.
static java.lang.String getCreateSQL()
          Returns the SQL CREATE statement to create the tree table.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

TABLE

public static final java.lang.String TABLE
The table name: CONFIGTABLE.

CONFIGNAME

public static final java.lang.String CONFIGNAME
A string identifying the configuration object: CONFIG_NAME.

SQL DEF: VARCHAR(100) NOT NULL PRIMARY KEY


CONFIG

public static final java.lang.String CONFIG
The serialized configuration object: CONFIG.

SQL DEF: BLOB(1M))

Constructor Detail

ConfigTableDef

public ConfigTableDef()
Method Detail

getCreateSQL

public static java.lang.String getCreateSQL()
Returns the SQL CREATE statement to create the tree table. The SQL CREATE statement is as follows:
 
  create table CONFIGTABLE(
    CRAWL_PATTERN_ID varchar( 100 ) not null primary key,
    CONFIG blob( 1M )
  )
 
Returns:
The sql string to create the treetable.

createTable

public static void createTable(Transaction t)
                        throws TransactionException
Given a Transaction object, executes the create statements (which create the table and associated indexes on the table).
Parameters:
t - The transaction object through which to execute the create statements.
Throws:
TransactionException - on failed SQL update.

getCreateIndexSQL

public static java.util.Enumeration getCreateIndexSQL()
Returns the SQL CREATE statements to create the necessary indexes on the CONFIGTABLE. The enumeration contains the following CREATE INDEX statements: None
Returns:
An enumeration of SQL strings each contain a separate createIndex statement.

dropTable

public static void dropTable(Transaction t)
                      throws TransactionException
Given a Transaction object, executes the drop statement.
Parameters:
t - The transaction object through which to execute the drop statements.
Throws:
TransactionException - on failed SQL update.

EIP Web Crawler APIs

(c) Copyright International Business Machines Corporation 1996, 2002. IBM Corp. All rights reserved.