com.ontimize.db

Class StandardAttachmentEntity

java.lang.Object

java.rmi.server.RemoteObject

java.rmi.server.RemoteServer

java.rmi.server.UnicastRemoteObject

com.ontimize.db.TableEntity

com.ontimize.db.DefaultTableEntity

com.ontimize.db.StandardAttachmentEntity

All Implemented Interfaces:

AdvancedEntity, AdvancedQueryEntity, Entity, EntityDataChangeNotifier, FileManagementEntity, IdentifiedEntity, MetadataEntity, PrivilegedSecurityEntity, SecureEntity, TransactionalEntity, UtilEntity, Serializable, Remote

public class StandardAttachmentEntity
extends DefaultTableEntity

Class that must be inherit to be able to use the functionality of attaching files for each application form. In order that this entity works correctly, it is necessary to define a properties file for this entity. This file must contain the following parameters:
- AttachmentFileNameColumn: name of the column, in which the name of the attached file is stored
- AttachmentFileOriginalNameColumn: name of the column, in which the name of the file (before its attachment) is stored.
- AttachmentFileDescriptionColumn: name of the column, in which the description, that is added at this file, is stored.
- AttachmentFilePath: path, in which the attached files are stored.
- AttachmentFileNameKeys: columns that are used to created the name of the attached file
- InsertAutomaticlyAttachment: it must be fixed to 'yes'.

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class com.ontimize.db.TableEntity

TableEntity.AttachmentReceiving, TableEntity.FileInfo, TableEntity.FileInfoList, TableEntity.Receiving

Field Summary

Fields

Modifier and Type	Field and Description
protected String	attachmentDate
protected String	attachmentId
protected String	attachmentKeys
protected String	attachmentKeysColumns
protected String	attachmentPrivate
protected String	attachmentUser
protected boolean	checkPermissions
protected String	dataBaseTable
static boolean	DEBUG
static String	DEFAULT_ATTACHMENT_DATABASE_TABLE
protected String	fileDescription
protected String	fileName
protected static String	KEY_NAME_COLUMN
protected static String	KEY_VALUE_COLUMN
protected String	originalFileName
protected String	size
protected String	sourceAttachmentTable
static boolean	useMAXFunction

Fields inherited from class com.ontimize.db.DefaultTableEntity

props

Fields inherited from class com.ontimize.db.TableEntity

alias, aliasPropertiesParser, aliasReverse, ASTERISK, ATTACHMENT_FILE_DESCRIPTION_COLUMN, ATTACHMENT_FILE_NAME_COLUMN, ATTACHMENT_FILE_NAME_KEYS, ATTACHMENT_FILE_ORIGINAL_NAME_COLUMN, ATTACHMENT_FILE_ORIGINAL_PATH_COLUMN, ATTACHMENT_FILE_PATH, ATTACHMENT_FILE_SIZE_COLUMN, ATTACHMENT_SEPARATOR, ATTACHMENT_TABLE, attachmentFileNameColumn, attachmentFileNameKeys, attachmentFilePath, attachmentFileSizeColumn, attachTable, auditorLog, AUTOCONFIGURATION, AUTONUMERICAL, autonumericalColumn, calendar, checkOperationResult, columnNames, COLUMNS, connectionRequestTime, COUNT_COLUMNS, countColumns, dataChangeListeners, dBLocalErrorMessage, defaultEntityScriptManagerClassName, DELETE_ACTION, DELETE_KEYS, deleteKeys, descendantColumnsOrder, descriptionAttachmentFileColumn, enableScripting, entitiesPropertiesParser, entitiesTableAttribute, entityName, entityScripting, FETCH_SIZE, fetchSize, FILE_COLUMNS, fileInfoList, FORCE_DISTINCT, forceDistinct, GENERATED_KEY, generatedKeyList, hOtherLocaleTablesColumns, hOtherLocaleTablesKey, INSERT_ACTION, INSERT_AUTOMATICLY_ATTACHMENT, INSERT_COLUMNS, INSERT_KEYS, insertAttachmentAutomatically, insertColumn, insertKeys, INTERROG, keys, KEYS, LIMIT_QUERY_OTHERS_ENTITIES, limitQueryOthersEntities, LOCALE_COLUMNS, LOCALE_TABLE, localeTable, locator, LOG_KEYS, logDelete, logInsert, logkeys, logQuery, logUpdate, M_ERROR_OPERATION, M_IT_HAS_NOT_CHANGED_ANY_RECORD, M_LICENSE_PERMISSION_ERROR, M_TEMPORALY_RESTRICTED_BY_PERMISSION_ACTION, M_YOU_DO_NOT_HAVE_PERMISSION_TO_EXECUTE_ACTION, manager, maxConnectionWaitTime, oneToOneMode, orderColumns, originalAttachmentFileNameColumn, originalAttachmentFilePathColumn, OTHER_ENTITIES, OTHER_LOCALE_TABLES, OTHER_LOCALE_TABLES_COLUMNS, OTHER_LOCALE_TABLES_KEY, othersEntities, PERCENT, PRINCIPAL_COLUMNS, PRINCIPAL_KEYS, PRINCIPAL_TABLE, principalColumnNames, principalKeyName, principalTable, privilegedId, properties, propertiesPath, QUERY_ACTION, QUERY_TABLE, queryTable, receivedAttachmentFile, receivedTempFiles, RECORD_OPERATIONS, registeredDispatcher, REPORT_ADVANCED_QUERY_COLUMNS, REPORT_ADVANCED_QUERY_TYPES, reportAvancedQueryColumns, reportAvancedQueryTypes, SECONDARY_COLUMNS, SECONDARY_KEYS, SECONDARY_TABLE, secondaryColumnsNames, secondaryKeyName, secondaryTable, sendAttachmentFile, SORT, SORT_DESC, table, TABLE, TABLE_ATTRIBUTE_ENTITIES, tempFiles, TRUNCATE_DATE_DEFAULT_VALUE, TRUNCATE_DATES, truncateDates, UNDERSCORE, UPDATE_ACTION, UPDATE_COLUMNS, UPDATE_KEYS, updateColumn, updateKeys, USE_SETSTRING_LONG_STRINGS, useAlwaysTableAttributeEntities, vLocaleColumns, vOtherLocaleTables, WILDCARD_COLUMNS, wildcardColumns

Fields inherited from class java.rmi.server.RemoteObject

ref

Constructor Summary

Constructors

Constructor and Description
StandardAttachmentEntity(EntityReferenceLocator referenceLocator, DatabaseConnectionManager dbConnectionManager, int port, String properties)

Method Summary

Methods

Modifier and Type	Method and Description
void	checkPermissions(int sessionId, String action) Checks if the user/session identified by sessionId has the permission defined by action This method calls ServerManager.getServerSecurityManager() and then, if a manager exists, calls manager.checkActionPermission(int, String, String)
Hashtable	createAttachmentKeys(Hashtable kv)
protected void	createProperties()
protected Integer	increment()
protected void	initAlias()
protected void	initId()
protected void	loadAliasFile(String path) Loads the alias properties file in path.
protected void	loadAttachmentAliasFile(String path)
String	prepareToReceive(Hashtable keys, String fileName, String fileDescription, int sessionId) This method calls TableEntity.prepareToReceive(Hashtable, String, String, String, int) with null argument for originalFilePath
String	prepareToReceive(Hashtable keys, String fileName, String originalFilePath, String fileDescription, int sessionId) Indicates to this entity that must be ready for receiving the contents of a file.
EntityResult	query(Hashtable keys, Vector values, int sessionId, Connection con) Executes a query operation using the provided Connection, with the conditions and attributes required.
protected EntityResult	queryNoPrivate(Hashtable keys, Vector values, int sessionId, Connection con)
protected EntityResult	queryPrivate(Hashtable keys, Vector values, int sessionId, Connection con)
protected void	readAdditionalProperties()
protected void	readAttachmentProperties(String path)
protected void	readProperties(Properties prop, URL urlProp) Loads and analyzes the properties prop.
protected void	readProperties(String path) Loads a Properties object located in path using this.getClass().getClassLoader().getResource(path).
void	setPathAttachment(String path)

Methods inherited from class com.ontimize.db.DefaultTableEntity

getExtendedAliasPropertiesName, getExtendedPropertiesName, loadAliasFile, readProperties, setName

Methods inherited from class com.ontimize.db.TableEntity

addEntityDataChangeListener, buildConditionsString, cancelReceiving, checkAmbiguousColumns, checkAvailableLocaleTables, checkBasicExpresionLocalesInKv, checkBasicExpresionLocalesInKv, checkConditionsWithTablePreffix, checkDeleteKeys, checkFinishedSession, checkInsertKeys, checkLocalesInKV, checkOrderColumns, checkOtherLocaleTables, checkUpdateKeys, configureReverseAlias, connect, connect, createAdvancedEntityResultForSessionId, createAdvancedEntityResultForSessionId, createEntityResultForSessionId, createEntityResultForSessionId, createEntityResultForSessionId, createEntityResultForSessionId, createEntityResultForSessionId, createEntityScriptManager, delete, delete, deleteAttachmentFile, deleteAttachmentFile, deleteHOtherLocaleTablesAlias, deleteLocaleColumns, deleteMultipleTableAttributesColumns, disconnect, disconnect, dispatcherAttribute, executePreparedStatement, executePreparedStatement, executePreparedStatement, executePreparedStatement, executePreparedStatement, executePreparedStatement, executePreparedStatement, executeStatement, filterAttributes, filterKeys, finishReceiving, fireDataChangeEvent, fireDataChangeEvent, fireTransactionDataChangeEvent, fireTransactionDataChangeEvent, generatedKeysToEntityResult, generateRandomId, getActions, getAliasForColumn, getAttachmentFileNameForKeys, getAttachmentFilePath, getAttachmentFilePath, getAutonumericalColumn, getBaseEntityName, getBytes, getColumnForAlias, getColumnListForAvancedQuery, getColumns, getColumnsWithoutLocale, getConditionsWithTablePreffix, getContidionsWithoutFilterKeys, getDatabaseConnectionManager, getDeleteKeys, getDescOrderColumns, getDescription, getEntityPrivilegedId, getEntityReference, getErrorMessage, getExtension, gethOtherLocaleTablesColumns, getInsertKeys, getJoinConditions, getKeys, getKeysVector, getLocaleColumnsFromTable, getLocaleIdFromSession, getLocaleTableName, getLocaleTableName, getMetadata, getName, getOrderColumns, getPrivilegedId, getPropertiesPath, getQueryRecordNumber, getQueryRecordNumber, getQueryTable, getSchemaQueryTable, getSchemaTable, getSecondaryColumnsWithoutKey, getSize, getSQLTypesFromMetaData, getStringsOn, getSubGroupValues, getSubGroupValues, getTable, getTypeFromMetadata, getUpdateColumns, getUpdateKeys, getUser, getValidAttributes, getValidDeletingKeysValues, getValidInsertingAttributesValues, getValidQueryingKeysValues, getValidUpdatingAttributesValues, getValidUpdatingKeysValues, getvLocaleColumns, getWildCardColumns, insert, insert, insertAutonumericalAlias, insertInLocaleTableLocaleColumns, insertInLocaleTablesForOneToOne, insertLocaleColumn, insertOtherEntities, isBinaryType, logToLogKeys, logUpdate, modifyBexpWithOtherLocaleTableAlias, modifyBexpWithOtherLocaleTableAlias, parseProperties, parseStringValue, particularizeConditions, performExtendedAliasProperties, performExtendedProperties, postDelete, postInsert, postUpdate, preDelete, preInsert, prepareToReceive, prepareToTransfer, prepareToTransfer, preUpdate, processColumnsWithoutLocale, processFileColumnsAttributes, processFileColumnsAttributes, processFileResults, processingMultipleValueAttributes, processingReferenceDataFieldAttributes, processingReferenceDataFieldAttributes, processMultipleAttributeKey, processMultipleTableAttribute, processMultipleTableAttribute, processOtherEntities, processValidLocaleColumnsValues, putBytes, query, query, query, query, queryOtherEntities, registerAttributeDispatcher, reloadScripts, removeEntityDataChangeListener, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAliasKeepColumns, resultSetToEntityResult, resultSetToEntityResult, resultSetToEntityResult, retrieveDataToInsert, setLimitQueryOthersEntities, setObject, setObject, setPrivilegedId, tagAttributes, tagAttributesWithoutAlias, tagKeysValues, toVectorOfBooleans, truncateDataToHour_00_00_00, truncateDateToMinutes, update, update, updateAttachmentValues, updateInLocaleTablesForOneToOne, updateLocaleColumns, vectorToStringSeparateBySemicolon

Methods inherited from class java.rmi.server.UnicastRemoteObject

clone, exportObject, exportObject, exportObject, unexportObject

Methods inherited from class java.rmi.server.RemoteServer

getClientHost, getLog, setLog

Methods inherited from class java.rmi.server.RemoteObject

equals, getRef, hashCode, toString, toStub

Methods inherited from class java.lang.Object

finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

DEBUG

public static boolean DEBUG

KEY_VALUE_COLUMN

protected static final String KEY_VALUE_COLUMN

See Also:

Constant Field Values

KEY_NAME_COLUMN

protected static final String KEY_NAME_COLUMN

See Also:

Constant Field Values

DEFAULT_ATTACHMENT_DATABASE_TABLE

public static final String DEFAULT_ATTACHMENT_DATABASE_TABLE

See Also:

Constant Field Values

useMAXFunction

public static boolean useMAXFunction

dataBaseTable

protected String dataBaseTable

attachmentId

protected String attachmentId

attachmentKeys

protected String attachmentKeys

attachmentKeysColumns

protected String attachmentKeysColumns

sourceAttachmentTable

protected String sourceAttachmentTable

attachmentDate

protected String attachmentDate

attachmentPrivate

protected String attachmentPrivate

attachmentUser

protected String attachmentUser

fileName

protected String fileName

originalFileName

protected String originalFileName

fileDescription

protected String fileDescription

size

protected String size

checkPermissions

protected boolean checkPermissions

Constructor Detail

StandardAttachmentEntity

public StandardAttachmentEntity(EntityReferenceLocator referenceLocator,
                        DatabaseConnectionManager dbConnectionManager,
                        int port,
                        String properties)
                         throws Exception

Throws:

Exception

Method Detail

readProperties

protected void readProperties(String path)
                       throws Exception

Description copied from class: TableEntity

Loads a Properties object located in path using this.getClass().getClassLoader().getResource(path).
Then calls TableEntity.readProperties(Properties, URL)

Overrides:

readProperties in class TableEntity

Parameters:

path - path from which the properties will be loaded

Throws:

Exception

readAttachmentProperties

protected void readAttachmentProperties(String path)
                                 throws Exception

Throws:

Exception

setPathAttachment

public void setPathAttachment(String path)

createProperties

protected void createProperties()

readProperties

protected void readProperties(Properties prop,
                  URL urlProp)
                       throws Exception

Description copied from class: TableEntity

Loads and analyzes the properties prop. The parameters for this entity are read from the properties and this entity is configured according to them.
If the 'autoconfiguration' parameter is specified and the uRLProp protocol is 'file', then a properties file is generated located in uRLProp.getPath()

Overrides:

readProperties in class TableEntity

Parameters:

prop - the properties object

urlProp - the properties file URL

Throws:

Exception

loadAliasFile

protected void loadAliasFile(String path)

Description copied from class: TableEntity

Loads the alias properties file in path.

If file does not exist, no error is produced. If file exists, resulting alias are loaded in alias and aliasReverse fields.

Overrides:

loadAliasFile in class TableEntity

Parameters:

path - the file location, relative to this entity's class file.

loadAttachmentAliasFile

protected void loadAttachmentAliasFile(String path)

initAlias

protected void initAlias()

readAdditionalProperties

protected void readAdditionalProperties()
                                 throws Exception

Throws:

Exception

initId

protected void initId()

increment

protected Integer increment()

prepareToReceive

public String prepareToReceive(Hashtable keys,
                      String fileName,
                      String fileDescription,
                      int sessionId)
                        throws Exception

Description copied from class: TableEntity

This method calls TableEntity.prepareToReceive(Hashtable, String, String, String, int) with null argument for originalFilePath

Specified by:

prepareToReceive in interface FileManagementEntity

Overrides:

prepareToReceive in class TableEntity

Throws:

Exception

prepareToReceive

public String prepareToReceive(Hashtable keys,
                      String fileName,
                      String originalFilePath,
                      String fileDescription,
                      int sessionId)
                        throws Exception

Description copied from class: TableEntity

Indicates to this entity that must be ready for receiving the contents of a file. The file will be associated (linked) to the record identified by keysValues. The method returns a String identifier for use when sending new bytes.

This method performs a query, so QUERY_ACTION must be granted to the caller.

If insertAttachmentAutomatically is true, then a new record is automatically inserted using the values contained in keysValues. (So, INSERT_ACTION must be granted.)

The supplied fileName, originalFilePath and fileDescription will be used when inserting if not null and TableEntity.attachmentFileNameColumn, TableEntity.originalAttachmentFileNameColumn and TableEntity.descriptionAttachmentFileColumn are not null.

If insertAttachmentAutomatically is false, a record must exist.

Specified by:

prepareToReceive in interface FileManagementEntity

Overrides:

prepareToReceive in class TableEntity

Parameters:

keys - the keys-values that identify the record or the new values for the new record

fileName - the attachment file name. The resulting file name will be the generated by a call to getAttachmentFileNameForKeys. May be null

originalFilePath - may be null

fileDescription - an optional file description. May be null

sessionId - the caller id

Returns:

a identifier for the transfer

Throws:

Exception - if attachment file path or attachment filename column are null for this entity, or an error ocurrs

createAttachmentKeys

public Hashtable createAttachmentKeys(Hashtable kv)
                               throws Exception

Throws:

Exception

query

public EntityResult query(Hashtable keys,
                 Vector values,
                 int sessionId,
                 Connection con)
                   throws Exception

Description copied from class: TableEntity

Executes a query operation using the provided Connection, with the conditions and attributes required.

This method calls TableEntity.query(Hashtable, Vector, int, Connection, Vector, boolean) using null and true as the last two parameters.

Specified by:

query in interface TransactionalEntity

Overrides:

query in class TableEntity

Throws:

Exception - if an error ocurrs

queryNoPrivate

protected EntityResult queryNoPrivate(Hashtable keys,
                          Vector values,
                          int sessionId,
                          Connection con)
                               throws Exception

Throws:

Exception

queryPrivate

protected EntityResult queryPrivate(Hashtable keys,
                        Vector values,
                        int sessionId,
                        Connection con)
                             throws Exception

Throws:

Exception

checkPermissions

public void checkPermissions(int sessionId,
                    String action)
                      throws NotInPeriodException,
                             GeneralSecurityException

Description copied from class: TableEntity

Checks if the user/session identified by sessionId has the permission defined by action

This method calls ServerManager.getServerSecurityManager() and then, if a manager exists, calls manager.checkActionPermission(int, String, String)

Overrides:

checkPermissions in class TableEntity

Parameters:

sessionId - the identifier to check

action - the action to check

Throws:

NotInPeriodException - if the action is restricted by time constraints

GeneralSecurityException - it the action is not allowed

SessionNotFoundException - if the identifier sessionId has not an associated session.