ifs.fnd.services.plsqlserver.service.security

Class DataDictionaryCache

java.lang.Object

ifs.fnd.services.plsqlserver.service.security.DataDictionaryCache

public class DataDictionaryCache
extends java.lang.Object

Framework internal class: LRU cache with information from data dictionary.

This is a framework internal class! Backward compatibility is not guaranteed.

Constructor Summary

Constructors

Constructor and Description
DataDictionaryCache(int coreTableCount, int maxColumnCount, int maxPackageCount, int coreSize, int maxSize, int poolKeepAlive) Creates a new DataDictionaryCache instance.

Method Summary

Methods

Modifier and Type	Method and Description
boolean	doesPackageExist(java.lang.String schema, java.lang.String pkgName) Checks if a PLSQL package is registered in the data dictionary.
java.lang.String	getApplicationOwner() Gets the application owner.
java.lang.String	getIalOwner() Gets the database owner of IAL tables (Information Access Layer).
java.util.Set<java.lang.String>	getRecordFields(java.lang.String schema, java.lang.String pkg, java.lang.String record) Gets the fields for a specified PLSQL record type.
static DataDictionaryCache	getStaticInstance() Gets the singleton instance of this class.
java.util.Set<java.lang.String>	getTableColumns(java.lang.String schema, java.lang.String table) Gets the columns for a specified table or view.
void	removeAll() Removes all tables and PLSQL packages from the data dictionary cache.
void	removePackage(java.lang.String schema, java.lang.String pkgName) Removes a specified PLSQL package from the data dictionary cache.
void	removeTable(java.lang.String schema, java.lang.String table) Removes a specified table from the data dictionary cache.

Methods inherited from class java.lang.Object

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

Constructor Detail

DataDictionaryCache

public DataDictionaryCache(int coreTableCount,
                   int maxColumnCount,
                   int maxPackageCount,
                   int coreSize,
                   int maxSize,
                   int poolKeepAlive)
                    throws IfsException

Creates a new DataDictionaryCache instance.

Parameters:

coreTableCount - the core number of tables in the table cache

maxColumnCount - the maximum number of columns in the table cache

maxPackageCount - the maximum number of packages in the PLSQL package cache

coreSize - the core number of accessors (connections) in the data dictionary connection pool

maxSize - the maximum number of accessors (connections) in the data dictionary connection pool

poolKeepAlive - the number of seconds to wait before removing an idle accessor (connection) from the data dictionary connection pool

Throws:

IfsException

Method Detail

getStaticInstance

public static DataDictionaryCache getStaticInstance()

Gets the singleton instance of this class.

Returns:

the current instance of DataDictionaryCache or null if PlsqlAnalyzer has not been initialized.

getTableColumns

public java.util.Set<java.lang.String> getTableColumns(java.lang.String schema,
                                              java.lang.String table)
                                                throws IfsException

Gets the columns for a specified table or view.

Returns:

non-empty set of column names, or null if the table/view has not been found in the data dictionary.

Throws:

IfsException

doesPackageExist

public boolean doesPackageExist(java.lang.String schema,
                       java.lang.String pkgName)
                         throws IfsException

Checks if a PLSQL package is registered in the data dictionary.

Returns:

true if the package exists in the data dictionary, false otherwise

Throws:

IfsException

getRecordFields

public java.util.Set<java.lang.String> getRecordFields(java.lang.String schema,
                                              java.lang.String pkg,
                                              java.lang.String record)
                                                throws IfsException

Gets the fields for a specified PLSQL record type.

Returns:

non-empty set of field names, or null if the record type has not been found in the data dictionary.

Throws:

IfsException

removeAll

public void removeAll()
               throws IfsException

Removes all tables and PLSQL packages from the data dictionary cache.

Throws:

IfsException

removeTable

public void removeTable(java.lang.String schema,
               java.lang.String table)
                 throws IfsException

Removes a specified table from the data dictionary cache.

Throws:

IfsException

removePackage

public void removePackage(java.lang.String schema,
                 java.lang.String pkgName)
                   throws IfsException

Removes a specified PLSQL package from the data dictionary cache.

Throws:

IfsException

getApplicationOwner

public java.lang.String getApplicationOwner()

Gets the application owner. The application owner acts as default value for schema (is not stored in cache).

getIalOwner

public java.lang.String getIalOwner()
                             throws IfsException

Gets the database owner of IAL tables (Information Access Layer).

Throws:

IfsException