fedora.server.storage.replication
Class DBIDLookup

java.lang.Object
  fedora.server.storage.replication.DBIDLookup

public class DBIDLookup

extends java.lang.Object

Title: DBIDLookup.java

Description: Database DBID lookup code. Looks up and returns the DBID for a row that matches the column values passed in for that particular row.

-----------------------------------------------------------------------------

License and Copyright: The contents of this file are subject to the Mozilla Public License Version 1.1 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.mozilla.org/MPL/.

Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for the specific language governing rights and limitations under the License.

The entire file consists of original code. Copyright © 2002-2005 by The Rector and Visitors of the University of Virginia and Cornell University. All rights reserved.

-----------------------------------------------------------------------------

Version:

$Id: DBIDLookup.java,v 1.18 2005/01/11 20:06:08 cwilper Exp $

Author:

Paul Charlton

Constructor Summary

DBIDLookup()

Method Summary

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	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	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.

Methods inherited from class java.lang.Object

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

Constructor Detail

DBIDLookup

public DBIDLookup()

Method Detail

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

StorageDeviceException

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:

java.sql.SQLException - JDBC, SQL error

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