fedora.server.storage.replication
Class DefaultDOReplicator

java.lang.Object
  fedora.server.Parameterized
      fedora.server.Pluggable
          fedora.server.Module
              fedora.server.storage.replication.DefaultDOReplicator

All Implemented Interfaces:

Constants, DOReplicator

public class DefaultDOReplicator
extends Module
implements DOReplicator

Title: DefaultDOReplicator.java

Description: A Module that replicates digital object information to the dissemination database.

Converts data read from the object reader interfaces and creates or updates the corresponding database rows in the dissemination database.

Version:

$Id: DefaultDOReplicator.java 5241 2006-11-27 08:14:31Z cwilper $

Author:

Paul Charlton, cwilper@cs.cornell.edu

Nested Class Summary

Nested classes/interfaces inherited from interface fedora.common.Constants

Constants.FedoraHome

Field Summary

static java.util.regex.Pattern	s_fedoraLocalPattern
static java.util.regex.Pattern	s_relativeGetPattern
static java.util.regex.Pattern	s_relativeGetPatternAsParm
static java.util.regex.Pattern	s_relativePattern
static java.util.regex.Pattern	s_relativeSearchPattern
static java.util.regex.Pattern	s_relativeSearchPatternAsParm

Fields inherited from interface fedora.common.Constants

ACTION, BDEF, BMECH, DATASTREAM, DC, DISSEMINATOR, ENVIRONMENT, FEDORA, FEDORA_HOME, FEDORA_SYSTEM_DEF_PID, FEDORA_SYSTEM_DEF_URI, HTTP_REQUEST, MODEL, OBJECT, RDF, RECOVERY, RELS_EXT, RESOURCE, SUBJECT, TUCANA, VIEW, XSD

Constructor Summary

DefaultDOReplicator(java.util.Map moduleParameters, Server server, java.lang.String role)

Method Summary

void	delete(java.lang.String pid) Removes a digital object from the dissemination database.
void	initModule() Initializes the Module based on configuration parameters.
void	insertBehaviorDefinitionRow(java.sql.Connection connection, java.lang.String bDefPID, java.lang.String bDefLabel, java.lang.String bDefState) Inserts a Behavior Definition row.
void	insertBehaviorMechanismRow(java.sql.Connection connection, java.lang.String bDefDbID, java.lang.String bMechPID, java.lang.String bMechLabel, java.lang.String bMechState) Inserts a Behavior Mechanism row.
void	insertDataStreamBindingMapRow(java.sql.Connection connection, java.lang.String bMechDbID, java.lang.String dsBindMapID, java.lang.String dsBindMapLabel) Inserts a dsBindMap row.
void	insertDataStreamBindingRow(java.sql.Connection connection, java.lang.String doDbID, java.lang.String dsBindKeyDbID, java.lang.String dsBindMapDbID, java.lang.String dsBindKeySeq, java.lang.String dsID, java.lang.String dsLabel, java.lang.String dsMIME, java.lang.String dsLocation, java.lang.String dsControlGroupType, java.lang.String dsCurrentVersionID, java.lang.String policyDbID, java.lang.String dsState) Inserts a DataStreamBindingRow row.
void	insertDataStreamBindingSpecRow(java.sql.Connection connection, java.lang.String bMechDbID, java.lang.String dsBindSpecName, java.lang.String dsBindSpecOrdinality, java.lang.String dsBindSpecCardinality, java.lang.String dsBindSpecLabel) Inserts a dsBindSpec row.
void	insertDataStreamMIMERow(java.sql.Connection connection, java.lang.String dsBindKeyDbID, java.lang.String dsMIMEName) Inserts a dsMIME row.
void	insertDigitalObjectDissAssocRow(java.sql.Connection connection, java.lang.String doDbID, java.lang.String dissDbID) Inserts a doDissAssoc row.
void	insertDigitalObjectRow(java.sql.Connection connection, java.lang.String doPID, java.lang.String doLabel, java.lang.String doState) Inserts a do row.
void	insertDisseminatorRow(java.sql.Connection connection, java.lang.String bDefDbID, java.lang.String bMechDbID, java.lang.String dissID, java.lang.String dissLabel, java.lang.String dissState) Inserts a Disseminator row.
void	insertGen(java.sql.Connection connection, java.lang.String insertionStatement) General JDBC row insertion method.
void	insertMechanismImplRow(java.sql.Connection connection, java.lang.String bMechDbID, java.lang.String bDefDbID, java.lang.String methodDbID, java.lang.String dsBindKeyDbID, java.lang.String protocolType, java.lang.String returnType, java.lang.String addressLocation, java.lang.String operationLocation, java.lang.String policyDbID) Inserts a mechImpl row.
void	insertMechDefaultMethodParmRow(java.sql.Connection connection, java.lang.String methDBID, java.lang.String bmechDBID, java.lang.String parmName, java.lang.String parmDefaultValue, java.lang.String parmDomainValues, java.lang.String parmRequiredFlag, java.lang.String parmLabel, java.lang.String parmType)
void	insertMethodParmRow(java.sql.Connection connection, java.lang.String methDBID, java.lang.String bdefDBID, java.lang.String parmName, java.lang.String parmDefaultValue, java.lang.String parmDomainValues, java.lang.String parmRequiredFlag, java.lang.String parmLabel, java.lang.String parmType)
void	insertMethodRow(java.sql.Connection connection, java.lang.String bDefDbID, java.lang.String methodName, java.lang.String methodLabel) Inserts a method row.
java.lang.String	lookupBehaviorDefinitionDBID(java.sql.Connection connection, java.lang.String bDefPID) Looks up a BehaviorDefinition DBID.
java.lang.String	lookupBehaviorMechanismDBID(java.sql.Connection connection, java.lang.String bMechPID) Looks up a BehaviorMechanism DBID.
java.lang.String	lookupDataStreamBinding(java.sql.Connection connection, java.lang.String doDbID, java.lang.String dsBindKeyDbID, java.lang.String dsBindMapDbID, java.lang.String dsBindKeySeq, java.lang.String dsID, java.lang.String dsLocation, java.lang.String dsState)
java.lang.String	lookupDataStreamBindingMapDBID(java.sql.Connection connection, java.lang.String bMechDBID, java.lang.String dsBindingMapID) Looks up a dsBindMap DBID.
java.lang.String	lookupDataStreamBindingSpecDBID(java.sql.Connection connection, java.lang.String bMechDBID, java.lang.String dsBindingSpecName) Looks up a dsBindSpec DBID.
java.lang.String	lookupDBID1(java.sql.Connection connection, java.lang.String DBIDName, java.lang.String tableName, java.lang.String lookupColumnName, java.lang.String lookupColumnValue) General JDBC lookup method with 1 lookup column value.
java.lang.String	lookupDBID2(java.sql.Connection connection, java.lang.String DBIDName, java.lang.String tableName, java.lang.String lookupColumnName1, java.lang.String lookupColumnValue1, java.lang.String lookupColumnName2, java.lang.String lookupColumnValue2) General JDBC lookup method with 2 lookup column values.
java.lang.String	lookupDBID2FirstNum(java.sql.Connection connection, java.lang.String DBIDName, java.lang.String tableName, java.lang.String lookupColumnName1, java.lang.String lookupColumnValue1, java.lang.String lookupColumnName2, java.lang.String lookupColumnValue2)
java.lang.String	lookupDBID4(java.sql.Connection connection, java.lang.String DBIDName, java.lang.String tableName, java.lang.String lookupColumnName1, java.lang.String lookupColumnValue1, java.lang.String lookupColumnName2, java.lang.String lookupColumnValue2, java.lang.String lookupColumnName3, java.lang.String lookupColumnValue3, java.lang.String lookupColumnName4, java.lang.String lookupColumnValue4, java.lang.String lookupColumnName5, java.lang.String lookupColumnValue5, java.lang.String lookupColumnName6, java.lang.String lookupColumnValue6, java.lang.String lookupColumnName7, java.lang.String lookupColumnValue7)
java.lang.String	lookupDigitalObjectDBID(java.sql.Connection connection, java.lang.String doPID) Looks up a do DBID.
java.lang.String	lookupDisseminatorDBID(java.sql.Connection connection, java.lang.String bDefDBID, java.lang.String bMechDBID, java.lang.String dissID) Looks up a Disseminator DBID.
java.lang.String	lookupMethodDBID(java.sql.Connection connection, java.lang.String bDefDBID, java.lang.String methName) Looks up a method DBID.
void	postInitModule() Second stage of Module initialization.
void	replicate(BDefReader bDefReader) Replicates a Fedora behavior definition object.
void	replicate(BMechReader bMechReader) Replicates a Fedora behavior mechanism object.
void	replicate(DOReader doReader) Replicates a Fedora data object.

Methods inherited from class fedora.server.Module

getRole, getServer, shutdownModule

Methods inherited from class fedora.server.Pluggable

getHelp, getOptionalParameters, getParameterHelp, getRequiredModuleRoles, getRequiredParameters

Methods inherited from class fedora.server.Parameterized

getParameter, getParameter, getParameters, parameterNames, setParameter, setParameters

Methods inherited from class java.lang.Object

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

Field Detail

s_fedoraLocalPattern

public static java.util.regex.Pattern s_fedoraLocalPattern

s_relativePattern

public static java.util.regex.Pattern s_relativePattern

s_relativeGetPattern

public static java.util.regex.Pattern s_relativeGetPattern

s_relativeSearchPattern

public static java.util.regex.Pattern s_relativeSearchPattern

s_relativeGetPatternAsParm

public static java.util.regex.Pattern s_relativeGetPatternAsParm

s_relativeSearchPatternAsParm

public static java.util.regex.Pattern s_relativeSearchPatternAsParm

Constructor Detail

DefaultDOReplicator

public DefaultDOReplicator(java.util.Map moduleParameters,
                           Server server,
                           java.lang.String role)
                    throws ModuleInitializationException

Throws:

ModuleInitializationException

Method Detail

initModule

public void initModule()

Description copied from class: Module

Initializes the Module based on configuration parameters.

Overrides:

initModule in class Module

postInitModule

public void postInitModule()
                    throws ModuleInitializationException

Description copied from class: Module

Second stage of Module initialization. This is guaranteed to run after all Module's initModule() methods have run.

Overrides:

postInitModule in class Module

Throws:

ModuleInitializationException - If initialization values are invalid or initialization fails for some other reason.

replicate

public void replicate(BDefReader bDefReader)
               throws ReplicationException,
                      java.sql.SQLException

Replicates a Fedora behavior definition object.

Specified by:

replicate in interface DOReplicator

Parameters:

bDefReader - behavior definition reader

Throws:

ReplicationException - replication processing error

java.sql.SQLException - JDBC, SQL error

replicate

public void replicate(BMechReader bMechReader)
               throws ReplicationException,
                      java.sql.SQLException

Replicates a Fedora behavior mechanism object.

Specified by:

replicate in interface DOReplicator

Parameters:

bMechReader - behavior mechanism reader

Throws:

ReplicationException - replication processing error

java.sql.SQLException - JDBC, SQL error

replicate

public void replicate(DOReader doReader)
               throws ReplicationException,
                      java.sql.SQLException

Replicates a Fedora data object.

Specified by:

replicate in interface DOReplicator

Parameters:

doReader - data object reader

Throws:

ReplicationException - replication processing error

java.sql.SQLException - JDBC, SQL error

delete

public void delete(java.lang.String pid)
            throws ReplicationException

Removes a digital object from the dissemination database.

If the object is a behavior definition or mechanism, it's deleted as such, and then an attempt is made to delete it as a data object as well.

Note that this does not do cascading check object dependencies at all. It is expected at this point that when this is called, any referencial integrity issues have been ironed out or checked as appropriate.

All deletions happen in a transaction. If any database errors occur, the change is rolled back.

Specified by:

delete in interface DOReplicator

Parameters:

pid - The pid of the object to delete.

Throws:

ReplicationException - If the request couldn't be fulfilled for any reason.

insertBehaviorDefinitionRow

public void insertBehaviorDefinitionRow(java.sql.Connection connection,
                                        java.lang.String bDefPID,
                                        java.lang.String bDefLabel,
                                        java.lang.String bDefState)
                                 throws java.sql.SQLException

Inserts a Behavior Definition row.

Parameters:

connection - JDBC DBMS connection

bDefPID - Behavior definition PID

bDefLabel - Behavior definition label

bDefState - State of behavior definition object.

Throws:

java.sql.SQLException - JDBC, SQL error

insertBehaviorMechanismRow

public void insertBehaviorMechanismRow(java.sql.Connection connection,
                                       java.lang.String bDefDbID,
                                       java.lang.String bMechPID,
                                       java.lang.String bMechLabel,
                                       java.lang.String bMechState)
                                throws java.sql.SQLException

Inserts a Behavior Mechanism row.

Parameters:

connection - JDBC DBMS connection

bDefDbID - Behavior definition DBID

bMechPID - Behavior mechanism DBID

bMechLabel - Behavior mechanism label

bMechState - Statye of behavior mechanism object.

Throws:

java.sql.SQLException - JDBC, SQL error

insertDataStreamBindingRow

public void insertDataStreamBindingRow(java.sql.Connection connection,
                                       java.lang.String doDbID,
                                       java.lang.String dsBindKeyDbID,
                                       java.lang.String dsBindMapDbID,
                                       java.lang.String dsBindKeySeq,
                                       java.lang.String dsID,
                                       java.lang.String dsLabel,
                                       java.lang.String dsMIME,
                                       java.lang.String dsLocation,
                                       java.lang.String dsControlGroupType,
                                       java.lang.String dsCurrentVersionID,
                                       java.lang.String policyDbID,
                                       java.lang.String dsState)
                                throws java.sql.SQLException

Inserts a DataStreamBindingRow row.

Parameters:

connection - JDBC DBMS connection

doDbID - Digital object DBID

dsBindKeyDbID - Datastream binding key DBID

dsBindMapDbID - Binding map DBID

dsBindKeySeq - Datastream binding key sequence number

dsID - Datastream ID

dsLabel - Datastream label

dsMIME - Datastream mime type

dsLocation - Datastream location

dsControlGroupType - Datastream type

dsCurrentVersionID - Datastream current version ID

policyDbID - Policy DBID

dsState - State of datastream.

Throws:

java.sql.SQLException - JDBC, SQL error

insertDataStreamBindingMapRow

public void insertDataStreamBindingMapRow(java.sql.Connection connection,
                                          java.lang.String bMechDbID,
                                          java.lang.String dsBindMapID,
                                          java.lang.String dsBindMapLabel)
                                   throws java.sql.SQLException

Inserts a dsBindMap row.

Parameters:

connection - JDBC DBMS connection

bMechDbID - Behavior mechanism DBID

dsBindMapID - Datastream binding map ID

dsBindMapLabel - Datastream binding map label

Throws:

java.sql.SQLException - JDBC, SQL error

insertDataStreamBindingSpecRow

public void insertDataStreamBindingSpecRow(java.sql.Connection connection,
                                           java.lang.String bMechDbID,
                                           java.lang.String dsBindSpecName,
                                           java.lang.String dsBindSpecOrdinality,
                                           java.lang.String dsBindSpecCardinality,
                                           java.lang.String dsBindSpecLabel)
                                    throws java.sql.SQLException

Inserts a dsBindSpec row.

Parameters:

connection - JDBC DBMS connection

bMechDbID - Behavior mechanism DBID

dsBindSpecName - Datastream binding spec name

dsBindSpecOrdinality - Datastream binding spec ordinality flag

dsBindSpecCardinality - Datastream binding cardinality

dsBindSpecLabel - Datastream binding spec lable

Throws:

java.sql.SQLException - JDBC, SQL error

insertDataStreamMIMERow

public void insertDataStreamMIMERow(java.sql.Connection connection,
                                    java.lang.String dsBindKeyDbID,
                                    java.lang.String dsMIMEName)
                             throws java.sql.SQLException

Inserts a dsMIME row.

Parameters:

connection - JDBC DBMS connection

dsBindKeyDbID - Datastream binding key DBID

dsMIMEName - Datastream MIME type name

Throws:

java.sql.SQLException - JDBC, SQL error

insertDigitalObjectRow

public void insertDigitalObjectRow(java.sql.Connection connection,
                                   java.lang.String doPID,
                                   java.lang.String doLabel,
                                   java.lang.String doState)
                            throws java.sql.SQLException

Inserts a do row.

Parameters:

connection - JDBC DBMS connection

doPID - DigitalObject PID

doLabel - DigitalObject label

doState - State of digital object.

Throws:

java.sql.SQLException - JDBC, SQL error

insertDigitalObjectDissAssocRow

public void insertDigitalObjectDissAssocRow(java.sql.Connection connection,
                                            java.lang.String doDbID,
                                            java.lang.String dissDbID)
                                     throws java.sql.SQLException

Inserts a doDissAssoc row.

Parameters:

connection - JDBC DBMS connection

doDbID - DigitalObject DBID

dissDbID - Disseminator DBID

Throws:

java.sql.SQLException - JDBC, SQL error

insertDisseminatorRow

public void insertDisseminatorRow(java.sql.Connection connection,
                                  java.lang.String bDefDbID,
                                  java.lang.String bMechDbID,
                                  java.lang.String dissID,
                                  java.lang.String dissLabel,
                                  java.lang.String dissState)
                           throws java.sql.SQLException

Inserts a Disseminator row.

Parameters:

connection - JDBC DBMS connection

bDefDbID - Behavior definition DBID

bMechDbID - Behavior mechanism DBID

dissID - Disseminator ID

dissLabel - Disseminator label

dissState - State of disseminator.

Throws:

java.sql.SQLException - JDBC, SQL error

insertMechanismImplRow

public void insertMechanismImplRow(java.sql.Connection connection,
                                   java.lang.String bMechDbID,
                                   java.lang.String bDefDbID,
                                   java.lang.String methodDbID,
                                   java.lang.String dsBindKeyDbID,
                                   java.lang.String protocolType,
                                   java.lang.String returnType,
                                   java.lang.String addressLocation,
                                   java.lang.String operationLocation,
                                   java.lang.String policyDbID)
                            throws java.sql.SQLException

Inserts a mechImpl row.

Parameters:

connection - JDBC DBMS connection

bMechDbID - Behavior mechanism DBID

bDefDbID - Behavior definition DBID

methodDbID - Method DBID

dsBindKeyDbID - Datastream binding key DBID

protocolType - Mechanism implementation protocol type

returnType - Mechanism implementation return type

addressLocation - Mechanism implementation address location

operationLocation - Mechanism implementation operation location

policyDbID - Policy DBID

Throws:

java.sql.SQLException - JDBC, SQL error

insertMethodRow

public void insertMethodRow(java.sql.Connection connection,
                            java.lang.String bDefDbID,
                            java.lang.String methodName,
                            java.lang.String methodLabel)
                     throws java.sql.SQLException

Inserts a method row.

Parameters:

connection - JDBC DBMS connection

bDefDbID - Behavior definition DBID

methodName - Behavior definition label

methodLabel - Behavior definition label

Throws:

java.sql.SQLException - JDBC, SQL error

insertMethodParmRow

public void insertMethodParmRow(java.sql.Connection connection,
                                java.lang.String methDBID,
                                java.lang.String bdefDBID,
                                java.lang.String parmName,
                                java.lang.String parmDefaultValue,
                                java.lang.String parmDomainValues,
                                java.lang.String parmRequiredFlag,
                                java.lang.String parmLabel,
                                java.lang.String parmType)
                         throws java.sql.SQLException

Parameters:

connection - An SQL Connection.

methDBID - The method database ID.

bdefDBID - The behavior Definition object database ID.

parmName - the parameter name.

parmDefaultValue - A default value for the parameter.

parmDomainValues - A list of possible values for the parameter.

parmRequiredFlag - A boolean flag indicating whether the parameter is required or not.

parmLabel - The parameter label.

parmType - The parameter type.

Throws:

java.sql.SQLException - JDBC, SQL error

insertMechDefaultMethodParmRow

public void insertMechDefaultMethodParmRow(java.sql.Connection connection,
                                           java.lang.String methDBID,
                                           java.lang.String bmechDBID,
                                           java.lang.String parmName,
                                           java.lang.String parmDefaultValue,
                                           java.lang.String parmDomainValues,
                                           java.lang.String parmRequiredFlag,
                                           java.lang.String parmLabel,
                                           java.lang.String parmType)
                                    throws java.sql.SQLException

Parameters:

connection - An SQL Connection.

methDBID - The method database ID.

bmechDBID - The behavior Mechanism object database ID.

parmName - the parameter name.

parmDefaultValue - A default value for the parameter.

parmRequiredFlag - A boolean flag indicating whether the parameter is required or not.

parmDomainValues - A list of possible values for the parameter.

parmLabel - The parameter label.

parmType - The parameter type.

Throws:

java.sql.SQLException - JDBC, SQL error

insertGen

public void insertGen(java.sql.Connection connection,
                      java.lang.String insertionStatement)
               throws java.sql.SQLException

General JDBC row insertion method.

Parameters:

connection - JDBC DBMS connection

insertionStatement - SQL row insertion statement

Throws:

java.sql.SQLException - JDBC, SQL error

lookupBehaviorDefinitionDBID

public java.lang.String lookupBehaviorDefinitionDBID(java.sql.Connection connection,
                                                     java.lang.String bDefPID)
                                              throws StorageDeviceException

Looks up a BehaviorDefinition DBID.

Parameters:

connection - JDBC DBMS connection

bDefPID - Behavior definition PID

Returns:

The DBID of the specified Behavior Definition row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupBehaviorMechanismDBID

public java.lang.String lookupBehaviorMechanismDBID(java.sql.Connection connection,
                                                    java.lang.String bMechPID)
                                             throws StorageDeviceException

Looks up a BehaviorMechanism DBID.

Parameters:

connection - JDBC DBMS connection

bMechPID - Behavior mechanism PID

Returns:

The DBID of the specified Behavior Mechanism row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDataStreamBindingMapDBID

public java.lang.String lookupDataStreamBindingMapDBID(java.sql.Connection connection,
                                                       java.lang.String bMechDBID,
                                                       java.lang.String dsBindingMapID)
                                                throws StorageDeviceException

Looks up a dsBindMap DBID.

Parameters:

connection - JDBC DBMS connection

bMechDBID - Behavior mechanism DBID

dsBindingMapID - Data stream binding map ID

Returns:

The DBID of the specified dsBindMap row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDataStreamBinding

public java.lang.String lookupDataStreamBinding(java.sql.Connection connection,
                                                java.lang.String doDbID,
                                                java.lang.String dsBindKeyDbID,
                                                java.lang.String dsBindMapDbID,
                                                java.lang.String dsBindKeySeq,
                                                java.lang.String dsID,
                                                java.lang.String dsLocation,
                                                java.lang.String dsState)
                                         throws StorageDeviceException

Throws:

StorageDeviceException

lookupDataStreamBindingSpecDBID

public java.lang.String lookupDataStreamBindingSpecDBID(java.sql.Connection connection,
                                                        java.lang.String bMechDBID,
                                                        java.lang.String dsBindingSpecName)
                                                 throws StorageDeviceException

Looks up a dsBindSpec DBID.

Parameters:

connection - JDBC DBMS connection

bMechDBID - Behavior mechanism DBID

dsBindingSpecName - Data stream binding spec name

Returns:

The DBID of the specified dsBindSpec row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDigitalObjectDBID

public java.lang.String lookupDigitalObjectDBID(java.sql.Connection connection,
                                                java.lang.String doPID)
                                         throws StorageDeviceException

Looks up a do DBID.

Parameters:

connection - JDBC DBMS connection

doPID - Data object PID

Returns:

The DBID of the specified DigitalObject row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDisseminatorDBID

public java.lang.String lookupDisseminatorDBID(java.sql.Connection connection,
                                               java.lang.String bDefDBID,
                                               java.lang.String bMechDBID,
                                               java.lang.String dissID)
                                        throws StorageDeviceException

Looks up a Disseminator DBID.

Parameters:

connection - JDBC DBMS connection

bDefDBID - Behavior definition DBID

bMechDBID - Behavior mechanism DBID

dissID - Disseminator ID

Returns:

The DBID of the specified Disseminator row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupMethodDBID

public java.lang.String lookupMethodDBID(java.sql.Connection connection,
                                         java.lang.String bDefDBID,
                                         java.lang.String methName)
                                  throws StorageDeviceException

Looks up a method DBID.

Parameters:

connection - JDBC DBMS connection

bDefDBID - Behavior definition DBID

methName - Method name

Returns:

The DBID of the specified method row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDBID1

public java.lang.String lookupDBID1(java.sql.Connection connection,
                                    java.lang.String DBIDName,
                                    java.lang.String tableName,
                                    java.lang.String lookupColumnName,
                                    java.lang.String lookupColumnValue)
                             throws StorageDeviceException

General JDBC lookup method with 1 lookup column value.

Parameters:

connection - JDBC DBMS connection

DBIDName - DBID column name

tableName - Table name

lookupColumnName - Lookup column name

lookupColumnValue - Lookup column value

Returns:

The DBID of the specified row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDBID2

public java.lang.String lookupDBID2(java.sql.Connection connection,
                                    java.lang.String DBIDName,
                                    java.lang.String tableName,
                                    java.lang.String lookupColumnName1,
                                    java.lang.String lookupColumnValue1,
                                    java.lang.String lookupColumnName2,
                                    java.lang.String lookupColumnValue2)
                             throws StorageDeviceException

General JDBC lookup method with 2 lookup column values.

Parameters:

connection - JDBC DBMS connection

DBIDName - DBID Column name

tableName - Table name

lookupColumnName1 - First lookup column name

lookupColumnValue1 - First lookup column value

lookupColumnName2 - Second lookup column name

lookupColumnValue2 - Second lookup column value

Returns:

The DBID of the specified row.

Throws:

StorageDeviceException - if db lookup fails for any reason.

lookupDBID4

public java.lang.String lookupDBID4(java.sql.Connection connection,
                                    java.lang.String DBIDName,
                                    java.lang.String tableName,
                                    java.lang.String lookupColumnName1,
                                    java.lang.String lookupColumnValue1,
                                    java.lang.String lookupColumnName2,
                                    java.lang.String lookupColumnValue2,
                                    java.lang.String lookupColumnName3,
                                    java.lang.String lookupColumnValue3,
                                    java.lang.String lookupColumnName4,
                                    java.lang.String lookupColumnValue4,
                                    java.lang.String lookupColumnName5,
                                    java.lang.String lookupColumnValue5,
                                    java.lang.String lookupColumnName6,
                                    java.lang.String lookupColumnValue6,
                                    java.lang.String lookupColumnName7,
                                    java.lang.String lookupColumnValue7)
                             throws StorageDeviceException

Throws:

StorageDeviceException

lookupDBID2FirstNum

public java.lang.String lookupDBID2FirstNum(java.sql.Connection connection,
                                            java.lang.String DBIDName,
                                            java.lang.String tableName,
                                            java.lang.String lookupColumnName1,
                                            java.lang.String lookupColumnValue1,
                                            java.lang.String lookupColumnName2,
                                            java.lang.String lookupColumnValue2)
                                     throws StorageDeviceException

Throws:

StorageDeviceException