org.rcsb.openmms.apps.rdb
Class DBLoader

java.lang.Object
  |
  +--org.rcsb.openmms.apps.rdb.DBLoader

All Implemented Interfaces:

TypeNamesSql

public class DBLoader

extends java.lang.Object

implements TypeNamesSql

Database loader class that performs load and delete Entry operations.

Version:

1.13

Author:

Douglas S. Greer

Field Summary

static int

debug

Fields inherited from interface org.rcsb.openmms.util.TypeNamesSql

bigBinaryType, bigTextType, CATEGORY_TABLE_CIF_ID_NAME, CATEGORY_TABLE_DESC_NAME, CATEGORY_TABLE_KEY_NAME, CATEGORY_TABLE_MAND_NAME, CATEGORY_TABLE_NAME, CATEGORY_TABLE_NEXT_RECORD_NAME, CATEGORY_TABLE_TABLE_NAME, dbTypeNames, ENTRY_CATS_CATEGORY_NAME, ENTRY_CATS_ENTRY_NAME, ENTRY_CATS_FIRST_KEY_NAME, ENTRY_CATS_LEN_NAME, ENTRY_CATS_TABLE_NAME, ENTRY_TABLE_DEP_DATE_NAME, ENTRY_TABLE_FLAG_BASE_NAME, ENTRY_TABLE_ID_NAME, ENTRY_TABLE_KEY_NAME, ENTRY_TABLE_LOAD_DATE_NAME, ENTRY_TABLE_LOAD_STATUS_NAME, ENTRY_TABLE_NAME, hugeTextType, IBM_DB2_FLAVOR, ITEM_TABLE_CAT_INDX_NAME, ITEM_TABLE_CIF_ID_NAME, ITEM_TABLE_COLUMN_NAME, ITEM_TABLE_DESC_NAME, ITEM_TABLE_KEY_NAME, ITEM_TABLE_MAND_NAME, ITEM_TABLE_NAME, KEY_ID_SUFFIX, largeTableQualifier, MICROSOFT_ACCESS_FLAVOR, MYSQL_FLAVOR, NUMBER_OF_FLAVORS, ORACLE_FLAVOR, SCHEMA_PREFIX, smallBinaryType, STD_DATE_TYPE, STD_KEY_TYPE, STD_LINE_TYPE, STD_NAME_TYPE, SYBASE_FLAVOR, SYSTEM_DATA_BANK_NAME, SYSTEM_MODEL_ID_NAME, SYSTEM_REVISION_NUMBER_NAME, SYSTEM_TABLE_NAME, SYSTEM_VERSION_NAME, TYPE_FIELD_LEN

Constructor Summary

DBLoader(ServerHandler a, DataItemList dl)

Method Summary

protected void	abortDBOperation()
void	closeConnection()
java.sql.Connection	connect(java.lang.String url, java.lang.String driver, java.lang.String user, java.lang.String passwd)
void	dbCheck() This routine is done in the swing thread on start-up to insure that the database loading was not aborted in the middle of an entry load.
java.lang.String	deleteEntries(java.io.Reader r)
void	deleteEntry(InsertEntryFinal edbl, int key, java.lang.String ename)
void	deleteSingleEntry(InsertEntryFinal edbl, java.lang.String ename)
int	getEntryKey(java.lang.String ename)
boolean	getStop()
void	insertSingleEntry(InsertEntryFinal edbl, java.lang.String ename, EntryImpl ei)
java.lang.String	loadEntries(java.io.Reader r, java.lang.String dataPath, java.lang.String manifest)
java.lang.String	loadEntries(java.lang.String[] list, java.lang.String dataPath)
void	processSingleEntry(InsertEntryFinal edbl, java.lang.String ename)
java.lang.String[]	readManifest(java.lang.String manifest, java.util.HashSet exclude)
EntryImpl	readSingleEntry(java.lang.String id)
void	runGC()
void	setDebug(int d)
void	setStop(boolean stp)

Methods inherited from class java.lang.Object

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

Field Detail

debug

public static int debug

Constructor Detail

DBLoader

public DBLoader(ServerHandler a,
                DataItemList dl)

Method Detail

setDebug

public void setDebug(int d)

connect

public java.sql.Connection connect(java.lang.String url,
                                   java.lang.String driver,
                                   java.lang.String user,
                                   java.lang.String passwd)
                            throws java.sql.SQLException,
                                   java.lang.ClassNotFoundException

java.sql.SQLException

java.lang.ClassNotFoundException

closeConnection

public void closeConnection()

readManifest

public java.lang.String[] readManifest(java.lang.String manifest,
                                       java.util.HashSet exclude)
                                throws java.io.IOException

java.io.IOException

setStop

public void setStop(boolean stp)

getStop

public boolean getStop()

dbCheck

public void dbCheck()
             throws MmsTranslationException

This routine is done in the swing thread on start-up to insure that the database loading was not aborted in the middle of an entry load. This is needed for systems such as mySQL that do not support transaction control.

MmsTranslationException

loadEntries

public java.lang.String loadEntries(java.lang.String[] list,
                                    java.lang.String dataPath)
                             throws java.lang.Error

java.lang.Error

loadEntries

public java.lang.String loadEntries(java.io.Reader r,
                                    java.lang.String dataPath,
                                    java.lang.String manifest)
                             throws java.lang.Error

java.lang.Error

processSingleEntry

public void processSingleEntry(InsertEntryFinal edbl,
                               java.lang.String ename)
                        throws DataAccessException,
                               java.sql.SQLException,
                               MmsTranslationException,
                               CifParseException,
                               java.io.IOException

DataAccessException

java.sql.SQLException

MmsTranslationException

CifParseException

java.io.IOException

getEntryKey

public int getEntryKey(java.lang.String ename)
                throws java.sql.SQLException

java.sql.SQLException

readSingleEntry

public EntryImpl readSingleEntry(java.lang.String id)
                          throws DataAccessException,
                                 java.sql.SQLException,
                                 MmsTranslationException,
                                 CifParseException,
                                 java.io.IOException

DataAccessException

java.sql.SQLException

MmsTranslationException

CifParseException

java.io.IOException

insertSingleEntry

public void insertSingleEntry(InsertEntryFinal edbl,
                              java.lang.String ename,
                              EntryImpl ei)
                       throws java.sql.SQLException,
                              MmsTranslationException

java.sql.SQLException

MmsTranslationException

deleteEntries

public java.lang.String deleteEntries(java.io.Reader r)

deleteSingleEntry

public void deleteSingleEntry(InsertEntryFinal edbl,
                              java.lang.String ename)
                       throws DataAccessException,
                              java.sql.SQLException,
                              MmsTranslationException

DataAccessException

java.sql.SQLException

MmsTranslationException

deleteEntry

public void deleteEntry(InsertEntryFinal edbl,
                        int key,
                        java.lang.String ename)
                 throws java.sql.SQLException,
                        MmsTranslationException

java.sql.SQLException

MmsTranslationException

abortDBOperation

protected void abortDBOperation()

runGC

public void runGC()