|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.dse.base.DSENotifier | +--com.ibm.dse.base.Service | +--com.ibm.dse.services.appltables.ApplicationTables
The Application Tables Service provides a way to access static table data from an application. It provides a specific implementation of the following interfaces:
The ApplicationTablesService interface, that has been implemented using the JDBC interface. This implementation can then be used with any database management system providing JDBC connectivity.
The ApplicationTablesLoad interface, that read a table definition from an XML file. The way that this XML file is generated from the permanent database storage system is left to the application (various tools can be found to run this export/import process).
The ApplicationTablesMemoryCreation interface, to build the data table into system memory by using a JDBC interface both to create the table and add the table records.
Field Summary | |
protected boolean |
changesControl
A boolean value to control static table changes every time a request is done. |
protected java.lang.String |
classNameForTableAccess
Name of the class to be instantiated and used to access the static tables information. |
protected java.lang.String |
classNameForTableLoad
Name of the class to be instantiated and used to read the static tables information and load them into memory. |
protected java.lang.String |
classNameForTableMemoryCreation
Name of the class to be instantiated and used to create static tables into memory. |
static java.lang.String |
COMPID
Keeps the component identification that will be used by the traces tool. |
protected java.lang.String |
databaseInMemoryURL
The database URL where the table is created. |
protected java.lang.String |
enterprise
The enterprise attribute to be used to get a static table data. |
protected java.lang.String |
externalJDBCDriver
Name of the JDBC Driver that the service will use to request the connection to the permanent data storage for reading the tables information and loading them into memory. |
protected java.lang.String |
externalPassword
The password used to logon to the permanent data storage, if required. |
protected java.lang.String |
externalSourceURL
Location of the data source that contains the tables definition. |
protected java.lang.String |
externalUserid
The userID used to logon to the permanent data storage, if required. |
protected java.lang.String |
filter
Keeps the search condition to be applied when getting the records from the table. |
protected java.sql.Connection |
inMemoryConnection
The password used to logon to the database, if required. |
protected java.lang.String |
inMemoryJDBCDriver
Name of the JDBC Driver that the service will use to request the connection to the database or to execute the SQL statements. |
protected java.lang.String |
inMemoryPassword
The password used to logon to the database, if required. |
protected java.lang.String |
inMemoryUserid
The userID used to logon to the database, if it is required. |
protected java.lang.String |
language
The language attribute to be used to get a static table data. |
protected boolean |
loadAllTables
When set to true, all tables will be loaded into memory when the Application Tables service is initialized. |
protected boolean |
loadAllTablesFromServer
Flag indicating that the loading of all tables form a remote location is pending. |
protected java.lang.String |
order
Keeps the column name by which the table records will be ordered when executing next query. |
protected boolean |
searchRemotelly
When set to true, if the requested table data is not locally available, an operation will be started to get the information from the server. |
protected long |
timeout
Keeps the timeout for the ApplicationTablesServerOp execution. |
Fields inherited from class com.ibm.dse.base.Service |
externalizer |
Fields inherited from class com.ibm.dse.base.DSENotifier |
handlersList,
name |
Constructor Summary | |
ApplicationTables()
This constructor creates an instance of ApplicationTables. |
|
ApplicationTables(java.lang.String aName)
This constructor creates an instance of ApplicationTables and sets its name attribute to aName. |
Method Summary | |
void |
addRecord(java.lang.String aTableName,
Vector vectorOfColumnsValues)
Inserts in memory a new row in the table aTableName with the values set in the vectorOfColumnsValues vector. |
void |
addRecord(java.lang.String aTableName,
Vector vectorOfColumns,
Vector vectorOfColumnsValues)
Inserts a new row in a table that is in memory. |
protected IndexedCollection |
allRowsToIColl(java.sql.ResultSet aResultSet,
java.lang.String aTableName)
Converts all rows in the ResultSet obtained after executing a retrieve SQL statement to a indexed collection of keyed collections. |
protected Vector |
allRowsToRecords(java.sql.ResultSet aResultSet,
java.lang.String aTableName)
Converts all rows in the ResultSet obtained after executing a retrieve SQL statement to a vector of hashtables. |
boolean |
checkForTableInDatabase(java.lang.String aTableName)
Returns true if the table exists in memory or false if it does not. |
void |
connect(java.lang.String aDatabaseURL,
java.lang.String aUser,
java.lang.String aPassword)
Establishes a database connection |
void |
createTable(java.lang.String tableName)
Creates an empty table in memory. |
void |
createTable(java.lang.String tableName,
Vector vectorOfColumns)
Creates an empty table in memory with columns as specified in vectorOfColumns. |
void |
disconnect()
Closes the connection to the database. |
void |
dropTable(java.lang.String aTableName)
Deletes from memory the table aTableName. |
protected boolean |
existTable(java.lang.String aTableName)
Checks for the table existence either in memory or in the external data storage. |
protected boolean |
existTable(java.lang.String aTableName,
java.lang.String language,
java.lang.String enterprise)
Checks for the table existence either in memory or in the external data storage. |
Vector |
getAllRecords(java.lang.String aTableName)
Gets all columns of all the records in the table specified by aTableName. |
void |
getAllRecords(java.lang.String aTableName,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext)
Gets all columns of all records in table aTableName. |
void |
getAllRecords(java.lang.String aTableName,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext,
Vector vectorOfColumns)
Gets all columns of all records in table aTableName. |
void |
getAllRecords(java.lang.String aTableName,
java.lang.String aHashtableICollFormatName,
Context aContext)
Gets all columns of all records in table aTableName. |
void |
getAllRecords(java.lang.String aTableName,
java.lang.String aHashtableICollFormatName,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of all records in table aTableName. |
Vector |
getAllRecords(java.lang.String aTableName,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of all the records in table specified by aTableName. |
protected ApplicationTablesService |
getClassForTableAccess()
Returns an instance of the class that implements the ApplicationTablesService interface. |
protected ApplicationTablesLoad |
getClassForTableLoad()
Returns an instance of the class that implements the ApplicationTablesLoad interface. |
protected ApplicationTablesMemoryCreation |
getClassForTableMemoryCreation()
Returns an instance of the class that implements the ApplicationTablesMemoryCreation interface. |
protected java.lang.String |
getClassNameForTableAccess()
Returns the classNameForTableAccess attribute value. |
protected java.lang.String |
getClassNameForTableLoad()
Returns the classNameForTableLoad attribute value. |
protected java.lang.String |
getClassNameForTableMemoryCreation()
Returns the classNameForTableMemoryCreation attribute value. |
Vector |
getColumnsNames(java.lang.String aTableName)
Returns a Vector holding the names of the columns in the table. |
protected java.lang.String |
getDatabaseInMemoryURL()
Returns the databaseInMemoryURL attribute value. |
java.lang.String |
getEnterprise()
Returns the enterprise attribute value. |
protected java.lang.String |
getExternalJDBCDriver()
Returns the externalJDBCDriver attribute value. |
protected java.lang.String |
getExternalPassword()
Returns the externalPassword attribute value. |
protected java.lang.String |
getExternalSourceURL()
Returns the externalSourceURL attribute value. |
protected java.lang.String |
getExternalUserid()
Returns the externalUserid attribute value. |
protected java.lang.String |
getFilter()
Returns the filter attribute value. |
java.sql.Connection |
getInMemoryConnection()
Returns the inMemoryConnection attribute value. |
protected java.lang.String |
getInMemoryJDBCDriver()
Returns the inMemoryJDBCDriver attribute value. |
protected java.lang.String |
getInMemoryPassword()
Returns the inMemoryPassword attribute value. |
protected java.lang.String |
getInMemoryUserid()
Returns the inMemoryUserid attribute value. |
java.lang.String |
getLanguage()
Returns the language attribute value. |
Vector |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords)
Gets all columns of the next numberOfRecords records from the position set as cursorPosition in table aTableName. |
int |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext)
Gets all columns of the next numberOfRecords records from the cursor position set as cursorPosition in table aTableName. |
int |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the next numberOfRecords records from the cursor position set as cursorPosition in table aTableName. |
int |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
java.lang.String aHashtableICollFormatName,
Context aContext)
Gets all columns of the next numberOfRecords records from the cursor position set as cursorPosition in table aTableName. |
int |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
java.lang.String aHashtableICollFormatName,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the next numberOfRecords records from the cursor position set as cursorPosition in table aTableName. |
Vector |
getNextRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the next numberOfRecords records from the position set as cursorPosition in table aTableName. |
protected java.lang.String |
getOrder()
Returns the order attribute value. |
java.lang.String |
getPrimaryKey(java.lang.String aTableName)
Returns the name of the table aTableName column that is primary key. |
Hashtable |
getRecord(java.lang.String aTableName,
java.lang.Object key)
Gets all columns of the record identified by a key from the table aTableName. |
void |
getRecord(java.lang.String aTableName,
java.lang.Object key,
HashtableFormat aHashtableFormat,
Context aContext)
Gets all columns of the record identified by a key from the table aTableName. |
void |
getRecord(java.lang.String aTableName,
java.lang.Object key,
HashtableFormat aHashtableFormat,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the record identified by key from the table aTableName. |
void |
getRecord(java.lang.String aTableName,
java.lang.Object key,
java.lang.String aHashtableFormatName,
Context aContext)
Gets all columns of the record identified by key from the table aTableName. |
void |
getRecord(java.lang.String aTableName,
java.lang.Object key,
java.lang.String aHashtableFormatName,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the record identified by key from the table aTableName. |
Hashtable |
getRecord(java.lang.String aTableName,
java.lang.Object key,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the record identified by a key from the table aTableName. |
Vector |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo)
Gets all columns of the records with primary key between keyFrom and keyTo values from the table aTableName. |
void |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext)
Gets all columns of the records with primary key between keyFrom and keyTo from the table aTableName. |
void |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo,
HashtableIndexedCollectionFormat aHashtableICollFormat,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the records with primary key between keyFrom and keyTo from the table aTableName. |
void |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo,
java.lang.String aHashtableICollFormatName,
Context aContext)
Gets all columns of the records with primary key between keyFrom and keyTo from the table aTableName. |
void |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo,
java.lang.String aHashtableICollFormatName,
Context aContext,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the records with primary key between keyFrom and keyTo from the table aTableName. |
Vector |
getRecords(java.lang.String aTableName,
java.lang.Object keyFrom,
java.lang.Object keyTo,
Vector vectorOfColumns)
Gets the columns specified in vectorOfColumns argument of the records with primary key between keyFrom and keyTo from the table aTableName. |
Vector |
getTableNames()
Returns a Vector with the name of all tables created in the memory database. |
java.lang.Object |
getTableRecords(java.lang.String aTableName,
java.lang.String stOrder,
java.lang.String stFilter)
Returns an Object containing all the records in the table aTable name matching the stFilter search condition and ordered as set in the stOrder argument. |
java.lang.Object |
getTableRecords(java.lang.String aTableName,
java.lang.String stOrder,
java.lang.String stFilter,
Vector vectorOfColumns)
Returns an Object containing all records in the table aTable name matching the stFilter search condition and ordered as set in the stOrder argument. |
protected Hashtable |
getTablesCatalog()
Returns the tables catalog. |
protected long |
getTimeout()
Returns the timeout attribute value. |
java.lang.Object |
initializeFrom(Tag aTag)
Used by the ApplicationTables service externalizer to set the instance attributes as defined in the XML file. |
java.lang.Object |
initializeTableFrom(Tag aTag)
Used by the ApplicationTables service externalizer to create the tables catalog from its external definition. |
protected boolean |
isChangesControl()
Returns the changesControl attribute value. |
protected boolean |
isLoadAllTables()
Returns the loadAllTables attribute value. |
protected boolean |
isSearchRemotelly()
Returns the searchRemotelly attribute value. |
void |
loadTableFromExternalSource()
Reads the table and its contents from an external data storage and calls the ApplicationTablesMemoryCreation methods to create the table in memory. |
void |
loadTableFromExternalSource(java.lang.String language,
java.lang.String enterprise)
Reads the table and its contents from an external data storage and calls the ApplicationTablesMemoryCreation methods to create the table in memory. |
boolean |
loadTableFromExternalSource(java.lang.String aTableName,
java.lang.String version,
java.lang.String release,
java.lang.String language,
java.lang.String enterprise)
Reads the table aTableName and its contents from an external data storage and calls the ApplicationTablesMemoryCreation methods to create the table in memory. |
Hashtable |
manageRecord(java.lang.String aTableName,
java.lang.Object records)
Returns a Hashtable containing the data of the record retrieved by executing the getTableRecords() method. |
Vector |
manageRecords(java.lang.String aTableName,
int cursorPosition,
int numberOfRecords,
java.lang.Object records)
Returns a Vector of Hashtables. |
Vector |
manageRecords(java.lang.String aTableName,
java.lang.Object records)
Returns a Vector of Hashtables. |
protected java.sql.ResultSet |
selectTable(java.lang.String stTable,
Vector vColumns,
Vector vValues,
java.lang.String stOrder,
java.lang.String stFilter)
Executes a database query to get the requested records from the table. |
protected void |
setChangesControl(boolean newChangesControl)
Sets the changesControl attribute value to newChangesControl. |
protected void |
setClassNameForTableAccess(java.lang.String newClassNameForTableAccess)
Sets the classNameForTableAccess attribute value to newClassNameForTableAccess. |
protected void |
setClassNameForTableLoad(java.lang.String newClassNameForTableLoad)
Sets the classNameForTableLoad attribute value to newClassNameForTableLoad. |
protected void |
setClassNameForTableMemoryCreation(java.lang.String newClassNameForTableMemoryCreation)
Sets the classNameForTableMemoryCreation attribute value to newClassForTableMemoryCreation. |
protected void |
setDatabaseInMemoryURL(java.lang.String newDatabaseURL)
Sets the databaseInMemoryURL attribute value to newDatabaseURL. |
protected void |
setEnterprise(java.lang.String newEnterprise)
Sets the enterprise attribute value to newEnterprise. |
protected void |
setExternalJDBCDriver(java.lang.String newJDBCDriver)
Sets the externalJDBCDriver attribute value to newJDBCDriver. |
protected void |
setExternalPassword(java.lang.String newExternalPassword)
Sets the externalPassword attribute value to newExternalPassword. |
protected void |
setExternalSourceURL(java.lang.String newExternalSourceURL)
Sets the externalSourceURL attribute value to newExternalSourceURL. |
protected void |
setExternalUserid(java.lang.String newExternalUserid)
Sets the externalUserid attribute value to newExternalUserid. |
void |
setFilter(java.lang.String newFilter)
Sets the filter attribute value to newFilter. |
protected void |
setInMemoryJDBCDriver(java.lang.String newJDBCDriver)
Sets the inMemoryJDBCDriver attribute value to newJDBCDriver. |
protected void |
setInMemoryPassword(java.lang.String newPassword)
Sets the inMemoryPassword attribute value to newPassword. |
protected void |
setInMemoryUserid(java.lang.String newUserid)
Sets the inMemoryUserid attribute value to newUserid. |
protected void |
setLanguage(java.lang.String newLanguage)
Sets the language attribute value to newLanguage. |
protected void |
setLoadAllTables(boolean newLoadAllTables)
Sets the loadAllTables attribute value to newLoadAllTables. |
void |
setOrder(java.lang.String newOrder)
Sets the order attribute value to newOrder. |
protected void |
setSearchRemotelly(boolean newSearchRemotelly)
Sets the searchRemotelly attribute value to newSearchRemotelly. |
protected void |
setTimeout(long newTimeout)
Sets the timeout attribute value to newTimeout. |
void |
terminate()
Contains all needed code to be executed when the service is no more being used. |
Vector |
toStrings()
Used by the ApplicationTables service externalizer. |
protected void |
updateAllTablesInMemory(IndexedCollection allTables)
This method is call when getting the reply from the server after the ApplicationTablesClientOp operation execution with table name "allTables". |
protected void |
updateTablesInMemory(IndexedCollection responseData)
This method is call when getting the reply from the server after the ApplicationTablesClientOp operation execution. |
Methods inherited from class com.ibm.dse.base.Service |
externalizer,
getExternalizer,
getTagName,
readExternal,
readExternal,
readObject,
removeExternal,
setExternalizer,
toString,
toTags,
writeExternal,
writeExternal |
Methods inherited from class com.ibm.dse.base.DSENotifier |
addHandler,
getHandlersList,
getName,
removeHandler,
setName,
signalEvent,
signalEvent,
signalEvent |
Methods inherited from class java.lang.Object |
clone,
equals,
finalize,
getClass,
hashCode,
notify,
notifyAll,
wait,
wait,
wait |
Field Detail |
protected java.lang.String databaseInMemoryURL
protected java.lang.String inMemoryUserid
protected java.lang.String inMemoryPassword
protected java.lang.String inMemoryJDBCDriver
protected boolean changesControl
protected java.lang.String externalSourceURL
protected java.lang.String externalUserid
protected java.lang.String externalPassword
protected java.lang.String externalJDBCDriver
protected java.sql.Connection inMemoryConnection
public static final java.lang.String COMPID
protected boolean loadAllTables
protected boolean searchRemotelly
protected java.lang.String order
protected java.lang.String filter
protected java.lang.String language
protected java.lang.String enterprise
protected java.lang.String classNameForTableAccess
protected java.lang.String classNameForTableLoad
protected boolean loadAllTablesFromServer
protected java.lang.String classNameForTableMemoryCreation
protected long timeout
Constructor Detail |
public ApplicationTables()
public ApplicationTables(java.lang.String aName) throws java.io.IOException
aName
- java.lang.StringMethod Detail |
public void addRecord(java.lang.String aTableName, Vector vectorOfColumnsValues) throws DSESQLException, DSEInvalidArgumentException
aTableName
- String, the name of the tablevectorOfColumnsValues
- Vector, vector with the values of the records columnspublic void addRecord(java.lang.String aTableName, Vector vectorOfColumns, Vector vectorOfColumnsValues) throws DSESQLException
aTableName
- String, the name of the tablevectorOfColumns
- Vector, vector with the names of the records columnsvectorOfColumnsValues
- Vector, vector with the values of the records columnsprotected IndexedCollection allRowsToIColl(java.sql.ResultSet aResultSet, java.lang.String aTableName) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException
aResultSet
- ResultSet, the rows as a ResultSetaTableName
- String, the table name to be put as name of the indexed collectionprotected Vector allRowsToRecords(java.sql.ResultSet aResultSet, java.lang.String aTableName) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException
aResultSet
- ResultSet, the rows as a ResultSetpublic boolean checkForTableInDatabase(java.lang.String aTableName) throws DSESQLException
aTableName
- java.lang.Stringpublic void connect(java.lang.String aDatabaseURL, java.lang.String aUser, java.lang.String aPassword) throws DSESQLException
aDatabaseURL
- java.lang.String, the database URLaUser
- java.lang.String, the user identification to connect to the databaseaPassword
- java.lang.String, the user password to connect to the databasepublic void createTable(java.lang.String tableName) throws DSESQLException, DSEInvalidRequestException
aTableName
- String, the name of the tablepublic void createTable(java.lang.String tableName, Vector vectorOfColumns) throws DSESQLException
aTableName
- String, the name of the tablevectorOfColumns
- Vector, vector with the names of the records columnspublic void disconnect() throws DSESQLException
public void dropTable(java.lang.String aTableName) throws DSESQLException
protected boolean existTable(java.lang.String aTableName) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- java.lang.Stringprotected boolean existTable(java.lang.String aTableName, java.lang.String language, java.lang.String enterprise) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- java.lang.Stringpublic Vector getAllRecords(java.lang.String aTableName) throws DSEInvalidArgumentException, DSESQLException, DSEException
aTableName
- String, the name of the tablevectorOfColumnsValues
- Vector, vector with the values of the records columnspublic void getAllRecords(java.lang.String aTableName, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext) throws DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getAllRecords(java.lang.String aTableName, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext, Vector vectorOfColumns) throws DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Vector getAllRecords(java.lang.String aTableName, Vector vectorOfColumns) throws DSEInvalidArgumentException, DSESQLException, DSEException
aTableName
- String, the name of the tablevectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic void getAllRecords(java.lang.String aTableName, java.lang.String aHashtableICollFormatName, Context aContext) throws DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getAllRecords(java.lang.String aTableName, java.lang.String aHashtableICollFormatName, Context aContext, Vector vectorOfColumns) throws DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tableprotected ApplicationTablesService getClassForTableAccess()
protected ApplicationTablesLoad getClassForTableLoad()
protected ApplicationTablesMemoryCreation getClassForTableMemoryCreation()
protected java.lang.String getClassNameForTableAccess()
protected java.lang.String getClassNameForTableLoad()
protected java.lang.String getClassNameForTableMemoryCreation()
public Vector getColumnsNames(java.lang.String aTableName) throws DSESQLException
aTableName
- java.lang.Stringprotected java.lang.String getDatabaseInMemoryURL()
public java.lang.String getEnterprise()
protected java.lang.String getExternalJDBCDriver()
protected java.lang.String getExternalPassword()
protected java.lang.String getExternalSourceURL()
protected java.lang.String getExternalUserid()
protected java.lang.String getFilter()
public java.sql.Connection getInMemoryConnection()
protected java.lang.String getInMemoryJDBCDriver()
protected java.lang.String getInMemoryPassword()
protected java.lang.String getInMemoryUserid()
public java.lang.String getLanguage()
public Vector getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords) throws DSESQLException, DSEInvalidArgumentException, DSEException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedpublic int getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEException, java.io.IOException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic int getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEException, java.io.IOException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Vector getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedvectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic int getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, java.lang.String aHashtableICollFormatName, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEException, java.io.IOException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic int getNextRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, java.lang.String aHashtableICollFormatName, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInternalErrorException, DSEException, java.io.IOException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrievedaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tableprotected java.lang.String getOrder()
public java.lang.String getPrimaryKey(java.lang.String aTableName) throws DSESQLException
aTableName
- java.lang.Stringpublic Hashtable getRecord(java.lang.String aTableName, java.lang.Object key) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tablekey
- Object, Object with the key value that identifies the record to be retrievedpublic void getRecord(java.lang.String aTableName, java.lang.Object key, HashtableFormat aHashtableFormat, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tablekey
- Object, Object with the key value that identifies the record to be retrievedaHashtableFormat
- HashtableFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getRecord(java.lang.String aTableName, java.lang.Object key, HashtableFormat aHashtableFormat, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tableaHashtableFormat
- HashtableFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Hashtable getRecord(java.lang.String aTableName, java.lang.Object key, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tablekey
- Object, Object with the key value that identifies the record to be retrievedvectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic void getRecord(java.lang.String aTableName, java.lang.Object key, java.lang.String aHashtableFormatName, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getRecord(java.lang.String aTableName, java.lang.Object key, java.lang.String aHashtableFormatName, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tableaHashtableFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Vector getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedpublic void getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo, HashtableIndexedCollectionFormat aHashtableICollFormat, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedaHashtableICollFormat
- HashtableIndexedCollectionFormat, the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Vector getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedvectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic void getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo, java.lang.String aHashtableICollFormatName, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datapublic void getRecords(java.lang.String aTableName, java.lang.Object keyFrom, java.lang.Object keyTo, java.lang.String aHashtableICollFormatName, Context aContext, Vector vectorOfColumns) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
aTableName
- String, the name of the tablekeyFrom
- Object, Object with a key value. Only records with primary key value exceeding this value will be retrievedkeyTo
- Object, Object with a key value. Only records with primary key value minor than this value will be retrievedaHashtableICollFormatName
- String, the name of the formatter to be used to unformat the retrieved dataaContext
- Context, the context that will be updated with the retrieved datavectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tablepublic Vector getTableNames() throws DSESQLException
public java.lang.Object getTableRecords(java.lang.String aTableName, java.lang.String stOrder, java.lang.String stFilter) throws DSESQLException
aTableName
- String, the name of the tablestOrder
- String, name of the column the retrieve records will be ordered bystFilter
- String, additional search conditionpublic java.lang.Object getTableRecords(java.lang.String aTableName, java.lang.String stOrder, java.lang.String stFilter, Vector vectorOfColumns) throws DSESQLException
aTableName
- String, the name of the tablestOrder
- String, name of the column the retrieve records will be ordered bystFilter
- String, additional search conditionvectorOfColumns
- Vector, vector with the name of the columns that will be retrieved from the tableprotected Hashtable getTablesCatalog()
protected long getTimeout()
public java.lang.Object initializeFrom(Tag aTag) throws java.io.IOException, DSEInvalidArgumentException, DSEException, DSESQLException
aTag
- com.ibm.dse.base.Tagpublic java.lang.Object initializeTableFrom(Tag aTag)
aTag
- com.ibm.dse.base.Tagprotected boolean isChangesControl()
protected boolean isLoadAllTables()
protected boolean isSearchRemotelly()
public void loadTableFromExternalSource() throws DSEInvalidArgumentException, DSESQLException, DSEException
public void loadTableFromExternalSource(java.lang.String language, java.lang.String enterprise) throws DSEInvalidArgumentException, DSESQLException, DSEException
language
- String, language of the table to be loadedenterprise
- String, enterprise of the table to be loadedpublic boolean loadTableFromExternalSource(java.lang.String aTableName, java.lang.String version, java.lang.String release, java.lang.String language, java.lang.String enterprise) throws DSESQLException, DSEInvalidArgumentException, DSEException
aTableName
- String, the name of the tableversion
- String, version of the table to be loadedrelease
- String, release of the table to be loadedlanguage
- String, language of the table to be loadedenterprise
- String, enterprise of the table to be loadedpublic Hashtable manageRecord(java.lang.String aTableName, java.lang.Object records) throws DSEInvalidArgumentException, DSESQLException, DSEInternalErrorException
aTableName
- String, the name of the tablerecords
- Object, an Object with the retrieved record informationpublic Vector manageRecords(java.lang.String aTableName, int cursorPosition, int numberOfRecords, java.lang.Object records) throws DSEInvalidArgumentException, DSESQLException, DSEInternalErrorException
aTableName
- String, the name of the tablecursorPosition
- int, the cursor position to start retrieving the records fromnumberOfRecords
- int, number of records to be retrieved from the set of all retrieved recordsrecords
- Object, an Object with the retrieved record informationpublic Vector manageRecords(java.lang.String aTableName, java.lang.Object records) throws DSEInvalidArgumentException, DSESQLException, DSEInternalErrorException
aTableName
- String, the name of the tablerecords
- Object, an Object with the retrieved record informationprotected java.sql.ResultSet selectTable(java.lang.String stTable, Vector vColumns, Vector vValues, java.lang.String stOrder, java.lang.String stFilter) throws DSESQLException
stTable
- String, the name of the tablevColumns
- Vector, vector with the name of the columns that will be retrieved from the tablevValues
- Vector, vector with the values of the columns that will be retrieved from the tablestOrder
- String, name of the column the retrieve records will be ordered bystFilter
- String, additional search conditionprotected void setChangesControl(boolean newChangesControl)
newChangesControl
- booleanprotected void setClassNameForTableAccess(java.lang.String newClassNameForTableAccess)
newClassNameForTableAccess
- java.lang.Stringprotected void setClassNameForTableLoad(java.lang.String newClassNameForTableLoad)
newClassNameForTableLoad
- java.lang.Stringprotected void setClassNameForTableMemoryCreation(java.lang.String newClassNameForTableMemoryCreation)
newClassNameForTableMemoryCreation
- java.lang.Stringprotected void setDatabaseInMemoryURL(java.lang.String newDatabaseURL)
newDatabaseURL
- java.lang.Stringprotected void setEnterprise(java.lang.String newEnterprise)
newEnterprise
- java.lang.Stringprotected void setExternalJDBCDriver(java.lang.String newJDBCDriver)
newJDBCDriver
- java.lang.Stringprotected void setExternalPassword(java.lang.String newExternalPassword)
newExternalPassword
- java.lang.Stringprotected void setExternalSourceURL(java.lang.String newExternalSourceURL)
newExternalSourceURL
- java.lang.Stringprotected void setExternalUserid(java.lang.String newExternalUserid)
newExternalUserid
- java.lang.Stringpublic void setFilter(java.lang.String newFilter)
newFilter
- java.lang.Stringprotected void setInMemoryJDBCDriver(java.lang.String newJDBCDriver)
newJDBCDriver
- java.lang.Stringprotected void setInMemoryPassword(java.lang.String newPassword)
newPassword
- java.lang.Stringprotected void setInMemoryUserid(java.lang.String newUserid)
newUserid
- java.lang.Stringprotected void setLanguage(java.lang.String newLanguage)
newLanguage
- java.lang.Stringprotected void setLoadAllTables(boolean newLoadAllTables)
newLoadAllTables
- booleanpublic void setOrder(java.lang.String newOrder)
newOrder
- java.lang.Stringprotected void setSearchRemotelly(boolean newSearchRemotelly)
newSearchRemotelly
- booleanprotected void setTimeout(long newTimeout)
newTimeout
- longpublic void terminate() throws DSEException
public Vector toStrings()
protected void updateAllTablesInMemory(IndexedCollection allTables) throws DSESQLException, DSEInvalidRequestException, DSEObjectNotFoundException
responseData
- IndexedCollection, the collection of tables information as returned from the serverprotected void updateTablesInMemory(IndexedCollection responseData) throws DSESQLException, DSEInvalidRequestException, DSEObjectNotFoundException
responseData
- IndexedCollection, the table information as returned from the server
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |