DBTransferDAO (Waarp All 3.6.2-jre8 API Reference)

java.lang.Object
- org.waarp.openr66.dao.database.StatementExecutor<Transfer>
- - org.waarp.openr66.dao.database.DBTransferDAO

All Implemented Interfaces:

Cloneable, AbstractDAO<Transfer>, TransferDAO

Direct Known Subclasses:

H2TransferDAO, MariaDBTransferDAO, MySqlDBTransferDAO, OracleTransferDAO, PostgreSQLTransferDAO
```
public abstract class DBTransferDAO
extends StatementExecutor<Transfer>
implements TransferDAO
```
Implementation of TransferDAO for a standard SQL database

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`BLOCK_SIZE_FIELD`
`static String`	`FILE_INFO_FIELD`
`static String`	`FILENAME_FIELD`
`static String`	`GLOBAL_LAST_STEP_FIELD`
`static String`	`GLOBAL_STEP_FIELD`
`static String`	`ID_FIELD`
`static String`	`ID_RULE_FIELD`
`static String`	`INFO_STATUS_FIELD`
`static String`	`IS_MOVED_FIELD`
`static String`	`ORIGINAL_NAME_FIELD`
`static String`	`OWNER_REQUEST_FIELD`
`protected static String`	`PRIMARY_KEY_WHERE`
`static String`	`RANK_FIELD`
`static String`	`REQUESTED_FIELD`
`static String`	`REQUESTER_FIELD`
`static String`	`RETRIEVE_MODE_FIELD`
`protected static String`	`SQL_COUNT_ALL`
`protected static String`	`SQL_DELETE`
`protected static String`	`SQL_DELETE_ALL`
`protected static String`	`SQL_EXIST`
`protected static String`	`SQL_GET_ALL`
`protected static String`	`SQL_INSERT`
`protected static String`	`SQL_SELECT`
`protected static String`	`SQL_UPDATE`
`static String`	`STEP_FIELD`
`static String`	`STEP_STATUS_FIELD`
`protected static String`	`TABLE`
`static String`	`TRANSFER_INFO_FIELD`
`static String`	`TRANSFER_MODE_FIELD`
`static String`	`TRANSFER_START_FIELD`
`static String`	`TRANSFER_STOP_FIELD`
`static String`	`UPDATED_INFO_FIELD`

Fields inherited from class org.waarp.openr66.dao.database.StatementExecutor
connection, PARAMETER, PARAMETER_COMMA, SQL_COUNT_ALL_PREFIX, WHERE

Constructor Summary

Constructors
Modifier Constructor and Description

protected DBTransferDAO(Connection con)

Constructors
Modifier	Constructor and Description
`protected`	`DBTransferDAO(Connection con)`

Method Summary

All Methods Instance Methods Abstract Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`delete(Transfer transfer)` Remove the specified object from the persistance layer
`boolean`	`exist(long id, String requester, String requested, String owner)` Verify if a Transfer object with the specified Special ID exists in the persistance layer
`List<Transfer>`	`find(List<Filter> filters, int limit, int offset)` Retrieve all Transfer objects to the given filters in a List from the persistance layer
`protected String`	`getCountRequest()`
`protected String`	`getDeleteAllRequest()`
`protected String`	`getDeleteRequest()`
`protected String`	`getExistRequest()`
`Transfer`	`getFromResultSet(ResultSet set)`
`protected String`	`getGetAllRequest()`
`protected String`	`getId(Transfer e1)` `UnsupportedOperationException`
`protected String`	`getInsertRequest()`
`protected Object[]`	`getInsertValues(Transfer transfer)`
`protected abstract long`	`getNextId()`
`protected String`	`getSelectRequest()`
`protected String`	`getTable()`
`protected String`	`getUpdateRequest()`
`protected Object[]`	`getUpdateValues(Transfer transfer)`
`void`	`insert(Transfer transfer)` Insert the specified object in the persistance layer
`protected boolean`	`isCachedEnable()`
`protected boolean`	`isDbTransfer()`
`Transfer`	`select(long id, String requester, String requested, String owner)` Retrieve the Transfer object with the specified Special ID from the persistance layer
`void`	`updateRank(Transfer e1)`
`void`	`updateRankUpdatedInfoStepStatusStop(Transfer e1)`

Methods inherited from class org.waarp.openr66.dao.database.StatementExecutor
addToCache, clearCache, close, closeResultSet, closeStatement, count, delete, deleteAll, executeAction, executeQuery, executeUpdate, exist, find, find, find, find, find, getAll, getCache, getConnection, getFromCache, isInCache, prepareCountQuery, prepareDeleteQuery, prepareFindParams, prepareFindQuery, removeFromCache, select, setParameters, update, update

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.waarp.openr66.dao.TransferDAO
count, find, find, find, find

Methods inherited from interface org.waarp.openr66.dao.AbstractDAO
close, deleteAll, exist, find, getAll, select, update, update

- Field Detail
  - TABLE
```
protected static final String TABLE
```
    See Also:
    
    Constant Field Values
  - ID_FIELD
```
public static final String ID_FIELD
```
    See Also:
    
    Constant Field Values
  - GLOBAL_STEP_FIELD
```
public static final String GLOBAL_STEP_FIELD
```
    See Also:
    
    Constant Field Values
  - GLOBAL_LAST_STEP_FIELD
```
public static final String GLOBAL_LAST_STEP_FIELD
```
    See Also:
    
    Constant Field Values
  - STEP_FIELD
```
public static final String STEP_FIELD
```
    See Also:
    
    Constant Field Values
  - RANK_FIELD
```
public static final String RANK_FIELD
```
    See Also:
    
    Constant Field Values
  - STEP_STATUS_FIELD
```
public static final String STEP_STATUS_FIELD
```
    See Also:
    
    Constant Field Values
  - RETRIEVE_MODE_FIELD
```
public static final String RETRIEVE_MODE_FIELD
```
    See Also:
    
    Constant Field Values
  - FILENAME_FIELD
```
public static final String FILENAME_FIELD
```
    See Also:
    
    Constant Field Values
  - IS_MOVED_FIELD
```
public static final String IS_MOVED_FIELD
```
    See Also:
    
    Constant Field Values
  - ID_RULE_FIELD
```
public static final String ID_RULE_FIELD
```
    See Also:
    
    Constant Field Values
  - BLOCK_SIZE_FIELD
```
public static final String BLOCK_SIZE_FIELD
```
    See Also:
    
    Constant Field Values
  - ORIGINAL_NAME_FIELD
```
public static final String ORIGINAL_NAME_FIELD
```
    See Also:
    
    Constant Field Values
  - FILE_INFO_FIELD
```
public static final String FILE_INFO_FIELD
```
    See Also:
    
    Constant Field Values
  - TRANSFER_INFO_FIELD
```
public static final String TRANSFER_INFO_FIELD
```
    See Also:
    
    Constant Field Values
  - TRANSFER_MODE_FIELD
```
public static final String TRANSFER_MODE_FIELD
```
    See Also:
    
    Constant Field Values
  - TRANSFER_START_FIELD
```
public static final String TRANSFER_START_FIELD
```
    See Also:
    
    Constant Field Values
  - TRANSFER_STOP_FIELD
```
public static final String TRANSFER_STOP_FIELD
```
    See Also:
    
    Constant Field Values
  - INFO_STATUS_FIELD
```
public static final String INFO_STATUS_FIELD
```
    See Also:
    
    Constant Field Values
  - OWNER_REQUEST_FIELD
```
public static final String OWNER_REQUEST_FIELD
```
    See Also:
    
    Constant Field Values
  - REQUESTED_FIELD
```
public static final String REQUESTED_FIELD
```
    See Also:
    
    Constant Field Values
  - REQUESTER_FIELD
```
public static final String REQUESTER_FIELD
```
    See Also:
    
    Constant Field Values
  - UPDATED_INFO_FIELD
```
public static final String UPDATED_INFO_FIELD
```
    See Also:
    
    Constant Field Values
  - PRIMARY_KEY_WHERE
```
protected static final String PRIMARY_KEY_WHERE
```
    See Also:
    
    Constant Field Values
  - SQL_DELETE
```
protected static final String SQL_DELETE
```
    See Also:
    
    Constant Field Values
  - SQL_DELETE_ALL
```
protected static final String SQL_DELETE_ALL
```
    See Also:
    
    Constant Field Values
  - SQL_EXIST
```
protected static final String SQL_EXIST
```
    See Also:
    
    Constant Field Values
  - SQL_GET_ALL
```
protected static final String SQL_GET_ALL
```
    See Also:
    
    Constant Field Values
  - SQL_COUNT_ALL
```
protected static final String SQL_COUNT_ALL
```
    See Also:
    
    Constant Field Values
  - SQL_INSERT
```
protected static final String SQL_INSERT
```
    See Also:
    
    Constant Field Values
  - SQL_SELECT
```
protected static final String SQL_SELECT
```
    See Also:
    
    Constant Field Values
  - SQL_UPDATE
```
protected static final String SQL_UPDATE
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - DBTransferDAO
```
protected DBTransferDAO(Connection con)
```
- Method Detail
  - getDeleteRequest
```
protected final String getDeleteRequest()
```
    Specified by:
    
    getDeleteRequest in class StatementExecutor<Transfer>
  - getDeleteAllRequest
```
protected final String getDeleteAllRequest()
```
    Specified by:
    
    getDeleteAllRequest in class StatementExecutor<Transfer>
  - getExistRequest
```
protected final String getExistRequest()
```
    Specified by:
    
    getExistRequest in class StatementExecutor<Transfer>
  - getGetAllRequest
```
protected final String getGetAllRequest()
```
    Specified by:
    
    getGetAllRequest in class StatementExecutor<Transfer>
  - getInsertRequest
```
protected final String getInsertRequest()
```
    Specified by:
    
    getInsertRequest in class StatementExecutor<Transfer>
  - getSelectRequest
```
protected final String getSelectRequest()
```
    Specified by:
    
    getSelectRequest in class StatementExecutor<Transfer>
  - getCountRequest
```
protected final String getCountRequest()
```
    Specified by:
    
    getCountRequest in class StatementExecutor<Transfer>
  - getUpdateRequest
```
protected final String getUpdateRequest()
```
    Specified by:
    
    getUpdateRequest in class StatementExecutor<Transfer>
  - getTable
```
protected final String getTable()
```
    Specified by:
    
    getTable in class StatementExecutor<Transfer>
  - isCachedEnable
```
protected final boolean isCachedEnable()
```
    Specified by:
    
    isCachedEnable in class StatementExecutor<Transfer>
  - getInsertValues
```
protected final Object[] getInsertValues(Transfer transfer)
```
    Specified by:
    
    getInsertValues in class StatementExecutor<Transfer>
  - getUpdateValues
```
protected final Object[] getUpdateValues(Transfer transfer)
```
    Specified by:
    
    getUpdateValues in class StatementExecutor<Transfer>
  - updateRank
```
public final void updateRank(Transfer e1)
                      throws DAOConnectionException,
                             DAONoDataException
```
    Throws:
    
    DAOConnectionException
    
    DAONoDataException
  - updateRankUpdatedInfoStepStatusStop
```
public final void updateRankUpdatedInfoStepStatusStop(Transfer e1)
                                               throws DAOConnectionException,
                                                      DAONoDataException
```
    Throws:
    
    DAOConnectionException
    
    DAONoDataException
  - delete
```
public final void delete(Transfer transfer)
                  throws DAOConnectionException,
                         DAONoDataException
```
    Description copied from interface: AbstractDAO
    
    Remove the specified object from the persistance layer
    
    Specified by:
    
    delete in interface AbstractDAO<Transfer>
    
    Overrides:
    
    delete in class StatementExecutor<Transfer>
    
    Parameters:
    
    transfer - object to delete
    
    Throws:
    
    DAOConnectionException - If a data access error occurs
    
    DAONoDataException - if no data are available
  - find
```
public final List<Transfer> find(List<Filter> filters,
                                 int limit,
                                 int offset)
                          throws DAOConnectionException
```
    Description copied from interface: TransferDAO
    
    Retrieve all Transfer objects to the given filters in a List from the persistance layer
    
    Specified by:
    
    find in interface TransferDAO
    
    Parameters:
    
    filters - List of filter
    
    Throws:
    
    DAOConnectionException - If data access error occurs
  - exist
```
public final boolean exist(long id,
                           String requester,
                           String requested,
                           String owner)
                    throws DAOConnectionException
```
    Description copied from interface: TransferDAO
    
    Verify if a Transfer object with the specified Special ID exists in the persistance layer
    
    Specified by:
    
    exist in interface TransferDAO
    
    Parameters:
    
    id - special ID of the Transfer object verified
    
    Returns:
    
    true if a Transfer object with the specified Special ID exist; false if no Transfer object correspond to the specified Special ID.
    
    Throws:
    
    DAOConnectionException - If a data access error occurs
  - select
```
public final Transfer select(long id,
                             String requester,
                             String requested,
                             String owner)
                      throws DAOConnectionException,
                             DAONoDataException
```
    Description copied from interface: TransferDAO
    
    Retrieve the Transfer object with the specified Special ID from the persistance layer
    
    Specified by:
    
    select in interface TransferDAO
    
    Parameters:
    
    id - special ID of the Transfer object requested
    
    Throws:
    
    DAOConnectionException - If a data access error occurs
    
    DAONoDataException - if no data are available
  - getNextId
```
protected abstract long getNextId()
                           throws DAOConnectionException
```
    Throws:
    
    DAOConnectionException
  - insert
```
public final void insert(Transfer transfer)
                  throws DAOConnectionException
```
    Description copied from interface: AbstractDAO
    
    Insert the specified object in the persistance layer
    
    Specified by:
    
    insert in interface AbstractDAO<Transfer>
    
    Overrides:
    
    insert in class StatementExecutor<Transfer>
    
    Parameters:
    
    transfer - object to insert
    
    Throws:
    
    DAOConnectionException - If a data access error occurs
  - isDbTransfer
```
protected final boolean isDbTransfer()
```
    Specified by:
    
    isDbTransfer in class StatementExecutor<Transfer>
  - getFromResultSet
```
public final Transfer getFromResultSet(ResultSet set)
                                throws SQLException
```
    Specified by:
    
    getFromResultSet in class StatementExecutor<Transfer>
    
    Throws:
    
    SQLException
  - getId
```
protected final String getId(Transfer e1)
```
    UnsupportedOperationException
    
    Specified by:
    
    getId in class StatementExecutor<Transfer>
    
    Parameters:
    
    e1 - as Transfer
    
    Returns:
    
    never

Class DBTransferDAO

Field Summary

Fields inherited from class org.waarp.openr66.dao.database.StatementExecutor

Constructor Summary

Method Summary

Methods inherited from class org.waarp.openr66.dao.database.StatementExecutor

Methods inherited from class java.lang.Object

Methods inherited from interface org.waarp.openr66.dao.TransferDAO

Methods inherited from interface org.waarp.openr66.dao.AbstractDAO

Field Detail

TABLE

ID_FIELD

GLOBAL_STEP_FIELD

GLOBAL_LAST_STEP_FIELD

STEP_FIELD

RANK_FIELD

STEP_STATUS_FIELD

RETRIEVE_MODE_FIELD

FILENAME_FIELD

IS_MOVED_FIELD

ID_RULE_FIELD

BLOCK_SIZE_FIELD

ORIGINAL_NAME_FIELD

FILE_INFO_FIELD

TRANSFER_INFO_FIELD

TRANSFER_MODE_FIELD

TRANSFER_START_FIELD

TRANSFER_STOP_FIELD

INFO_STATUS_FIELD

OWNER_REQUEST_FIELD

REQUESTED_FIELD

REQUESTER_FIELD

UPDATED_INFO_FIELD

PRIMARY_KEY_WHERE

SQL_DELETE

SQL_DELETE_ALL

SQL_EXIST

SQL_GET_ALL

SQL_COUNT_ALL

SQL_INSERT

SQL_SELECT

SQL_UPDATE

Constructor Detail

DBTransferDAO

Method Detail

getDeleteRequest

getDeleteAllRequest

getExistRequest

getGetAllRequest

getInsertRequest

getSelectRequest

getCountRequest

getUpdateRequest

getTable

isCachedEnable

getInsertValues

getUpdateValues

updateRank

updateRankUpdatedInfoStepStatusStop

delete

find

exist

select

getNextId

insert

isDbTransfer

getFromResultSet

getId