com.ontimize.db

Class UserEntity

java.lang.Object

java.rmi.server.RemoteObject

java.rmi.server.RemoteServer

java.rmi.server.UnicastRemoteObject

com.ontimize.db.TableEntity

com.ontimize.db.UserEntity

All Implemented Interfaces:

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

public class UserEntity
extends TableEntity

This class allows to use encrypted password automatically in database
It uses a 64 base encryption to obtain a valid character set for encrypted password. So, password could be stored in any database engine.

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	UserEntity.EncryptWindow Frame to obtains the encrypted value for a specified text

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 boolean	checkPeriodical
static boolean	encrypt Enable or disable encrypt.
protected static String	FIRST_LOGIN_STRING
protected String	firstLogin
protected static String	LAST_PASSWORD_UPDATE
protected static String	Password
protected String	passwordLastUpdate
protected long	period
protected static String	PERIOD_STRING
protected static String	PERIODICAL
protected static String	User
protected static String	USER_BLOCKED_STRING
protected String	userBlock

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
UserEntity(EntityReferenceLocator locator, DatabaseConnectionManager databaseConnectionManager, int port)

Method Summary

Methods

Modifier and Type	Method and Description
String	getFirstLoginColumn()
String	getPasswordLastUpdateColumn()
long	getPeriod()
String	getUserBlockColumn()
static String	getUserColumn()
EntityResult	insert(Hashtable attributesValues, int sessionId, Connection con) Executes an insert operation with the provided Connection.
boolean	isPeriodical()
static void	main(String[] arg)
EntityResult	query(Hashtable keysValues, Vector attributes, int sessionId, Connection con) Executes a query operation using the provided Connection, with the conditions and attributes required.
protected void	readProperties(Properties prop, URL uRLProp) Loads and analyzes the properties prop.
EntityResult	update(Hashtable attributesValues, Hashtable keysValues, int sessionId, Connection con) Executes an update operation with the provided Connection.

Methods inherited from class com.ontimize.db.TableEntity

addEntityDataChangeListener, buildConditionsString, cancelReceiving, checkAmbiguousColumns, checkAvailableLocaleTables, checkBasicExpresionLocalesInKv, checkBasicExpresionLocalesInKv, checkConditionsWithTablePreffix, checkDeleteKeys, checkFinishedSession, checkInsertKeys, checkLocalesInKV, checkOrderColumns, checkOtherLocaleTables, checkPermissions, 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, getExtendedAliasPropertiesName, getExtendedPropertiesName, 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, insertAutonumericalAlias, insertInLocaleTableLocaleColumns, insertInLocaleTablesForOneToOne, insertLocaleColumn, insertOtherEntities, isBinaryType, loadAliasFile, loadAliasFile, logToLogKeys, logUpdate, modifyBexpWithOtherLocaleTableAlias, modifyBexpWithOtherLocaleTableAlias, parseProperties, parseStringValue, particularizeConditions, performExtendedAliasProperties, performExtendedProperties, postDelete, postInsert, postUpdate, preDelete, preInsert, prepareToReceive, prepareToReceive, prepareToReceive, prepareToTransfer, prepareToTransfer, preUpdate, processColumnsWithoutLocale, processFileColumnsAttributes, processFileColumnsAttributes, processFileResults, processingMultipleValueAttributes, processingReferenceDataFieldAttributes, processingReferenceDataFieldAttributes, processMultipleAttributeKey, processMultipleTableAttribute, processMultipleTableAttribute, processOtherEntities, processValidLocaleColumnsValues, putBytes, query, query, query, query, queryOtherEntities, readProperties, readProperties, registerAttributeDispatcher, reloadScripts, removeEntityDataChangeListener, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceAliasByColumn, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAlias, replaceColumnByAliasKeepColumns, resultSetToEntityResult, resultSetToEntityResult, resultSetToEntityResult, retrieveDataToInsert, setLimitQueryOthersEntities, setName, setObject, setObject, setPrivilegedId, tagAttributes, tagAttributesWithoutAlias, tagKeysValues, toVectorOfBooleans, truncateDataToHour_00_00_00, truncateDateToMinutes, 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

encrypt

public static boolean encrypt

Enable or disable encrypt.
When UserEntity.encrypt is false, this entity is the same as TableEntity

checkPeriodical

protected boolean checkPeriodical

Password

protected static String Password

User

protected static String User

PERIODICAL

protected static final String PERIODICAL

See Also:

Constant Field Values

FIRST_LOGIN_STRING

protected static final String FIRST_LOGIN_STRING

See Also:

Constant Field Values

LAST_PASSWORD_UPDATE

protected static final String LAST_PASSWORD_UPDATE

See Also:

Constant Field Values

USER_BLOCKED_STRING

protected static final String USER_BLOCKED_STRING

See Also:

Constant Field Values

PERIOD_STRING

protected static final String PERIOD_STRING

See Also:

Constant Field Values

firstLogin

protected String firstLogin

passwordLastUpdate

protected String passwordLastUpdate

userBlock

protected String userBlock

period

protected long period

Constructor Detail

UserEntity

public UserEntity(EntityReferenceLocator locator,
          DatabaseConnectionManager databaseConnectionManager,
          int port)
           throws Exception

Throws:

Exception

Method Detail

isPeriodical

public boolean isPeriodical()

getFirstLoginColumn

public String getFirstLoginColumn()

getPasswordLastUpdateColumn

public String getPasswordLastUpdateColumn()

getUserBlockColumn

public String getUserBlockColumn()

getPeriod

public long getPeriod()

getUserColumn

public static String getUserColumn()

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

query

public EntityResult query(Hashtable keysValues,
                 Vector attributes,
                 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

insert

public EntityResult insert(Hashtable attributesValues,
                  int sessionId,
                  Connection con)
                    throws Exception

Description copied from class: TableEntity

Executes an insert operation with the provided Connection.

The attributesValues object determines the columns and values that will be inserted.

The sessionId number identifies the session.

When overriding, this method must suppose that the connection provided is not in autocommit mode, so all operations are executed in a transaction. This means that in an error ocurrs this method should throw an Exception to ensure that the calling method is properly notified.

The following methods of this class are called:

• checkPermissions with INSERT_ACTION
• processMultipleTableAttribute
• processingReferenceDataFieldAttributes
• processingMultipleValueAttributes
• processFileColumnsAttributes
• replaceAliasByColumn
• processingReferenceDataFieldAttributes
• processFileColumnsAttributes
• replaceAliasByColumn
• checkInsertKeys
• getValidInsertingAttributesValues
• SQLStatementBuilder.createInsertQuery
• executePreparedStatement
• insertAutonumericalAlias

If no valid attributes-values are contained in attributesValues no insert is performed and no error is produced.

If there is no error, a TransactionDataChangeEvent is fired and all listeners are notified.

Specified by:

insert in interface TransactionalEntity

Overrides:

insert in class TableEntity

Parameters:

attributesValues - the table columns and corresponding values to insert

sessionId - the session identifier

con - the Connection to use when executing the PreparedStatement

Returns:

an EntityResult. This result will contain the autonumerical as a key-value pair, where the key is the autonumerical column and the value the autonumerical value

Throws:

Exception - if an error ocurrs or the caller has not permission to execute the action.

update

public EntityResult update(Hashtable attributesValues,
                  Hashtable keysValues,
                  int sessionId,
                  Connection con)
                    throws Exception

Description copied from class: TableEntity

Executes an update operation with the provided Connection.

The attributesValues object determines the columns that will be updated and to which values.

The keysValues object determines the conditions that the records that will be updated must fulfill, that is, the WHERE clause.

The sessionId number identifies the session.

When overriding, this method must suppose that the connection provided is not in autocommit mode, so all operations are executed in a transaction. This means that in an error ocurrs this method should throw an Exception to ensure that the calling method is properly notified.

The following methods of this class are called:

• checkPermissions with UPDATE_ACTION
• processMultipleTableAttribute
• processingReferenceDataFieldAttributes
• processingMultipleValueAttributes
• processFileColumnsAttributes
• replaceAliasByColumn
• processingReferenceDataFieldAttributes
• processFileColumnsAttributes
• replaceAliasByColumn
• checkUpdateKeys
• getValidUpdatingAttributesValues
• getValidUpdatingKeysValues
• SQLStatementBuilder.createUpdateQuery
• executePreparedStatement

If no valid attributes-values are contained in attributesValues no update is performed and no error is produced.

If there is no error, a TransactionDataChangeEvent is fired and all listeners are notified.

Specified by:

update in interface TransactionalEntity

Overrides:

update in class TableEntity

Parameters:

attributesValues - the table columns and corresponding values to insert

keysValues - the table columns and corresponding values to use as conditions that the records to be updated must fulfill

sessionId - the session identifier

con - the Connection to use when executing the PreparedStatement

Returns:

an EntityResult This result is empty in the standard implementation.

Throws:

Exception - if an error ocurrs or the caller has not permission to execute the action.

main

public static final void main(String[] arg)