|
|||||||||
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.jdbc.JDBCService | +--com.ibm.dse.services.jdbc.Journal | +--com.ibm.dse.services.jdbc.JDBCJournal
The JDBCJournal class is a concrete class that provides an implementation of the Journal abstraction (a financial electronic journal). The JDBCJournal uses the JDBC interface to access the database and then can be used with any DBMS providing an implementation of this interface.
Field Summary | |
protected boolean |
createSchema
Keeps whether the journal schema was also created in the database or not. |
protected java.lang.String |
JDBCDriver
Keeps the name of the JDBC driver to be used to access the database. |
protected java.lang.String |
schemaName
Keeps the name of the schema where all journal tables are defined. |
protected java.lang.String |
tableName
Keeps the table name which is schemaName.entity_wrapNumber |
Fields inherited from class com.ibm.dse.services.jdbc.Journal |
COMPID,
date,
entity,
lastRecordNumber |
Fields inherited from class com.ibm.dse.services.jdbc.JDBCService |
autoCommit,
connectionProperties,
databaseConnection,
databaseURL,
dataSourceName,
metaData,
password,
poolName,
sharedConnection,
user,
waitRetry |
Fields inherited from class com.ibm.dse.base.Service |
externalizer |
Fields inherited from class com.ibm.dse.base.DSENotifier |
handlersList,
name |
Constructor Summary | |
JDBCJournal()
This constructor creates a JDBCJournal object. |
|
JDBCJournal(java.lang.String anEntityName,
java.lang.String aSchemaName)
This constructor creates a JDBCJournal object. |
Method Summary | |
int |
addRecord(Context aContext,
HashtableFormat aHashtableFormat)
Calls the formatter (HashtableFormat parameter) format method by passing aContext as an argument. |
int |
addRecord(Context aContext,
java.lang.String aFormatName)
Instantiates the journal format with the name aFormatName and calls its format method by passing aContext as an argument. |
int |
addRecord(Hashtable aDataHashtable)
Inserts the data in aDataHashtable as a new row in the current journal table. |
protected void |
buildConnectionProperties()
Build the hashtable containing all details needed to request the database connection. |
void |
commit()
Commits all changes to the database. |
protected java.lang.String |
controlTableName()
Returns the current control table name. |
java.sql.Date |
currentGenerationDate()
Returns the last date that the journal service was used by a specific entity to the journal instance as soon as it is created. |
protected int |
currentWrapNumber()
Returns the current table generation number being used by the journal instance for the schema set in the schemaName attribute. |
protected int |
currentWrapNumberForSchema(java.lang.String aSchemaName)
Returns the current table generation number being used by the journal instance for the schema aSchemaName. |
protected void |
deleteJournalContent(int aGeneration)
Internally used to delete the contents of a current journal table. |
protected void |
deleteRecord(int aRecordNumber)
Internally used to delete a record in the current journal table |
Hashtable |
getColumnsTable()
Returns the columnsTable attribute value of the current journal. |
protected java.sql.Connection |
getDatabaseConnection()
Returns the databaseConnection attribute value. |
Vector |
getEntities()
Retrieves all entities from the Database. |
java.lang.String |
getJDBCDriver()
Returns the JDBCDriver attribute value. |
int |
getNumberOfGenerations()
Returns the number of journal generations. |
java.lang.String |
getSchemaName()
Returns the schemaName attribute value. |
java.lang.String |
getTableName()
Returns the current journal tableName. |
protected int |
getWrapNumber()
Returns the wrapNumber attribute value |
java.lang.Object |
initializeColumnFrom(Tag aTag)
Used by the JDBCJournal service externalizer to create the contents of the columnsTable instance attribute. |
java.lang.Object |
initializeFrom(Tag aTag)
Used by the services externalizer to set the JDBCJournal instance attributes as defined in the XML file. |
boolean |
isConnected()
Returns true if there is a connection to the database or false if there is not. |
boolean |
isCreateSchema()
Returns the createSchema attribute value. |
boolean |
isValidEntity()
Returns true if the entity set for the current journal is valid or false if it is not. |
void |
loadDriver()
Loads the JDBC Driver given in the external definition of the service or the default JDBC Driver as set in the JournalConstants EJ_DEFAULT_JDBCDRIVER attribute. |
void |
loadDriver(java.lang.String aDriverName)
Loads the JDBC Driver explicitly provided as an argument. |
static JDBCJournal |
newFor(java.lang.String anEntityName,
java.lang.String aSchemaName)
Returns a new JDBCJournal instance with the entityName and schemaName attributes set to the provided values. |
protected int |
nextWrapNumber()
Returns the next generation number to be used for the default schema. |
protected int |
nextWrapNumberForSchema(java.lang.String aSchemaName)
Returns the next generation number available for the specified schema |
void |
open(java.lang.String anEntity,
int aGeneration)
Opens the journal service with an entity and a generation number |
void |
open(java.lang.String aSchemaName,
java.lang.String anEntity,
int aGeneration)
Opens the journal service with an specific shema, an entity and a generation number |
void |
openForEntity(java.lang.String anEntity)
Decides which is going to be the current journal table for entity anEntity. |
void |
openForEntity(java.lang.String anEntity,
java.lang.String aSchemaName)
Decides which is going to be the current journal table for entity anEntity. |
void |
openForSchema(java.lang.String aSchemaName)
Decides which is going to be the current journal table. |
void |
openOnCurrentTable()
Selects the already selected table generation for the current schema as the current journal table. |
void |
openOnCurrentTableForSchema(java.lang.String aSchemaName)
Selects the already selected table generation for the specified schema as the current journal table. |
void |
openOnNextTable()
Selects the next available table generation for the current schema as the current journal table. |
void |
openOnNextTableForSchema(java.lang.String aSchemaName)
Selects the next available table generation for the specified schema as the current journal table. |
int |
queryLastRecordNumber()
Returns the last record number in the current journal table. |
Hashtable |
retrieveLastRecord()
Retrieves the last record of the current journal table. |
void |
retrieveLastRecord(Context aContext,
HashtableFormat aHashtableFormat)
Retrieves the last record of the current journal table by calling the retrieveRecord(int, Context, HashtableFormat) with the last record number as first parameter. |
void |
retrieveLastRecord(Context aContext,
java.lang.String aFormatName)
Retrieves the last record of the current journal table by calling the retrieveRecord(int, Context, String) with the last record number as first parameter. |
Vector |
retrieveLastRecords(int aNumber)
It returns a vector with aNumber or any number between 0 and aNumber of hashtables with the records information. |
void |
retrieveLastRecords(int aNumber,
Context aContext,
HashtableIndexedCollectionFormat anOutputFormat)
Retrieves the last aNumber records from the journal table and unformats them into the context aContext using the formatter anOutputFormat. |
void |
retrieveLastRecords(int aNumber,
Context aContext,
java.lang.String anOutputFormatName)
Retrieves the last aNumber records from the journal table and unformats them into the context aContext using the formatter named anOutputFormatName. |
Hashtable |
retrieveRecord(int aRecordNumber)
Retrieves the record with record identification in the database equal to aRecordNumber. |
void |
retrieveRecord(int aRecordNumber,
Context aContext,
HashtableFormat aHashtableFormat)
Retrieves the record with record identification in the database equal to aRecordNumber. |
void |
retrieveRecord(int aRecordNumber,
Context aContext,
java.lang.String aFormatName)
Retrieves the record with record identification in the database equal to aRecordNumber. |
Vector |
retrieveRecords(java.lang.String aSearchCondition)
Retrieves all the records within the current journal that match aSearchCondition. |
void |
retrieveRecords(java.lang.String aSearchCondition,
Context aContext,
HashtableIndexedCollectionFormat anOutputFormat)
Retrieves all the records within the current journal that match aSearchCondition. |
void |
retrieveRecords(java.lang.String aSearchCondition,
Context aContext,
java.lang.String anOutputFormatName)
Retrieves all the records within the current journal that match aSearchCondition. |
Vector |
retrieveRecords(java.lang.String aSearchCondition,
Vector aColumnsVector)
Retrieves the columns in aColumnsVector of all the records within the current journal that match aSearchCondition. |
void |
retrieveRecords(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
HashtableIndexedCollectionFormat anOutputFormat)
Retrieves the columns in aColumnsVector of all the records within the current journal that match aSearchCondition. |
void |
retrieveRecords(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
java.lang.String anOutputFormatName)
Retrieves the columns in aColumnsVector of all the records within the current journal that match aSearchCondition. |
void |
rollback()
Rolls back all database changes. |
protected void |
setColumnsTable(Hashtable aColumnsHashtable)
Sets the columnsTable attribute to aColumnsHashtable value. |
void |
setCreateSchema(boolean newCreateSchema)
Sets the createSchema attribute to newCreateSchema. |
protected void |
setDatabaseConnection(java.sql.Connection aDatabaseConnection)
Sets the database connection attribute to aDatabaseConnection. |
void |
setEntity(java.lang.String anEntityName)
Sets the entity attribute value to anEntityName. |
void |
setJDBCDriver(java.lang.String newJDBCDriver)
Sets the JDBCDriver attribute value to newJDBCDriver. |
void |
setSchemaName(java.lang.String aSchemaName)
Sets the schemaName attribute to aSchemaName |
protected void |
setTableName(java.lang.String aTableName)
Sets the tableName. |
protected java.lang.String |
tableName(java.lang.String aSchemaName,
java.lang.String anEntityName,
int aGeneration)
Returns the journal table name for a specific schema name, entity name and generation. |
Vector |
toStrings()
Used by the Db2Journal service externalizer. |
int |
updateLastRecord(Context aContext,
HashtableFormat aHashtableFormat)
Updates the last record of the current journal table by calling the updateRecords(String, Context, HashtableFormat) method. |
int |
updateLastRecord(Context aContext,
HashtableFormat aHashtableFormat,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for the last record of the current journal table by calling the updateRecords(String, Context, HashtableFormat, Vector) method. |
int |
updateLastRecord(Context aContext,
java.lang.String aFormatName)
Updates the last record of the current journal table by calling the updateRecords(String, Context, String) method. |
int |
updateLastRecord(Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
Updates the columns in aColumnsVector for the last record of the current journal table by calling the updateRecords(String, Context, String, Vector) method. |
int |
updateLastRecord(Hashtable aDataHashtable)
Updates the last record of the current journal table with the data in aDataHashtable. |
int |
updateLastRecord(Hashtable aDataHashtable,
Vector aColumnsVector)
Updates the columns in aColumnsVector for the last record of the current journal table with the data in aDataHashtable. |
int |
updateRecord(int aRecordNumber,
Context aContext,
HashtableFormat aHashtableFormat)
Updates the record identified by aRecordNumber within the journal table by calling the updateRecords(String, Context, HashtableFormat) method. |
int |
updateRecord(int aRecordNumber,
Context aContext,
HashtableFormat aHashtableFormat,
Vector aColumnsVector)
Updates the columns in aColumnsVector for the record identified by aRecordNumber within the journal table by calling the updateRecords(String, Context, HashtableFormat, Vector) method. |
int |
updateRecord(int aRecordNumber,
Context aContext,
java.lang.String aFormatName)
Updates the record identified by aRecordNumber within the journal table by calling the updateRecords(String, Context, String) method. |
int |
updateRecord(int aRecordNumber,
Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
Updates the columns in aColumnsVector for the record identified by aRecordNumber within the journal table by calling the updateRecords(String, Context, String, Vector) method. |
int |
updateRecord(int aRecordNumber,
Hashtable aDataHashtable)
Updates the record identified by aRecordNumber within the journal table with the data provided in aDataHashtable by calling the updateRecords(String, Hashtable) method. |
int |
updateRecord(int aRecordNumber,
Hashtable aDataHashtable,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector, for the record identified by aRecordNumber within the journal table, with the data provided in aDataHashtable. |
int |
updateRecords(java.lang.String aSearchCondition,
Context aContext,
HashtableFormat aHashtableFormat)
Updates all the current journal table records that match the search condition passed as an argument, with the data obtained by formatting aContext with the journal formatter aHashtableFormat. |
int |
updateRecords(java.lang.String aSearchCondition,
Context aContext,
HashtableFormat aHashtableFormat,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for all the current journal table records that match the search condition passed as an argument, with the data obtained by formatting aContext with the journal formatter aHashtableFormat. |
int |
updateRecords(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName)
Updates all the current journal table records that match the search condition passed as an argument, with the data obtained by formatting aContext with the formatter defined by aFormatName. |
int |
updateRecords(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for all the current journal table records that match the search condition passed as an argument, with the data obtained by formatting aContext with the formatter defined by aFormatName. |
int |
updateRecords(java.lang.String aSearchCondition,
Hashtable aDataHashtable)
Updates all the current journal table records that match the search condition with the aDataHashtable data. |
int |
updateRecords(java.lang.String aSearchCondition,
Hashtable aDataHashtable,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for the records matching the search condition within the journal table, with the data provided in aDataHashtable. |
Methods inherited from class com.ibm.dse.services.jdbc.Journal |
close,
getDate,
getEntity,
getLastRecordNumber,
getState,
isActive,
open,
setLastRecordNumber,
setState,
today |
Methods inherited from class com.ibm.dse.services.jdbc.JDBCService |
connect,
connect,
connect,
connect,
connect,
connect,
disconnect,
getAutoCommit,
getConnectionManager,
getConnectionProperties,
getDatabaseURL,
getDataSourceName,
getPassword,
getPoolName,
getSharedConnection,
getUser,
isWaitRetry,
requestConnectionToConnectionManager,
requestConnectionToConnectionManager,
setAutoCommit,
setConnectionManager,
setConnectionProperties,
setDatabaseURL,
setDataSourceName,
setPassword,
setPoolName,
setSharedConnection,
setUser,
setWaitRetry,
verifyConnection |
Methods inherited from class com.ibm.dse.base.Service |
externalizer,
getExternalizer,
getTagName,
readExternal,
readExternal,
readObject,
removeExternal,
setExternalizer,
terminate,
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 JDBCDriver
protected boolean createSchema
protected java.lang.String schemaName
protected java.lang.String tableName
Constructor Detail |
public JDBCJournal()
public JDBCJournal(java.lang.String anEntityName, java.lang.String aSchemaName) throws DSEInvalidRequestException
anEntityName
- java.lang.String the Entity nameaSchemaName
- java.lang.String the Schema nameMethod Detail |
public int addRecord(Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException
aContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic int addRecord(Context aContext, java.lang.String aFormatName) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException
aContext
- com.ibm.dse.base.Context, the context where the data isaFormatName
- java.lang.String, the format name of the formatter to be usedpublic int addRecord(Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException
aDataHashtable
- Hashtable, the Hashtable with the data to be inserted in the database tableprotected void buildConnectionProperties()
public void commit() throws DSESQLException
protected java.lang.String controlTableName()
public java.sql.Date currentGenerationDate() throws DSEInternalErrorException, DSESQLException
protected int currentWrapNumber() throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
protected int currentWrapNumberForSchema(java.lang.String aSchemaName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSchemaName
- java.lang.String, the journal schema nameprotected void deleteJournalContent(int aGeneration) throws DSEInternalErrorException, DSESQLException
aGeneration
- intprotected void deleteRecord(int aRecordNumber) throws DSEInternalErrorException, DSESQLException
aRecordNumber
- intpublic Hashtable getColumnsTable()
protected java.sql.Connection getDatabaseConnection()
public Vector getEntities() throws DSESQLException, DSEInternalErrorException
public java.lang.String getJDBCDriver()
public int getNumberOfGenerations() throws DSESQLException, DSEInternalErrorException
public java.lang.String getSchemaName()
public java.lang.String getTableName()
protected int getWrapNumber()
public java.lang.Object initializeColumnFrom(Tag aTag)
aTag
- com.ibm.dse.base.Tagpublic java.lang.Object initializeFrom(Tag aTag) throws java.io.IOException
aTag
- com.ibm.dse.base.Tagpublic boolean isConnected() throws DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEObjectNotFoundException, DSEException
public boolean isCreateSchema()
public boolean isValidEntity() throws DSEInternalErrorException, DSESQLException
public void loadDriver() throws DSEInternalErrorException
public void loadDriver(java.lang.String aDriverName) throws DSEInternalErrorException
aDriverName
- java.lang.String, the driver name (full path)public static JDBCJournal newFor(java.lang.String anEntityName, java.lang.String aSchemaName) throws DSEInvalidRequestException
anEntityName
- java.lang.String, the name of the EntityaSchemaName
- java.lang.String, the name of the Schemaprotected int nextWrapNumber() throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
protected int nextWrapNumberForSchema(java.lang.String aSchemaName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSchemaName
- java.lang.String, the journal schema namepublic void open(java.lang.String anEntity, int aGeneration) throws DSEInvalidRequestException, DSEInternalErrorException, DSESQLException
anEntity
- java.lang.StringaGeneration
- intpublic void open(java.lang.String aSchemaName, java.lang.String anEntity, int aGeneration) throws DSEInvalidRequestException, DSEInternalErrorException, DSESQLException
aSchemaName
- java.lang.StringanEntity
- java.lang.StringaGeneration
- intpublic void openForEntity(java.lang.String anEntity) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
anEntity
- java.lang.String, the name of the entitypublic void openForEntity(java.lang.String anEntity, java.lang.String aSchemaName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
anEntity
- java.lang.String, the name of the entityaSchemaName
- java.lang.String, the name of the schemapublic void openForSchema(java.lang.String aSchemaName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSchemaName
- java.lang.String, the name of the schemapublic void openOnCurrentTable() throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
public void openOnCurrentTableForSchema(java.lang.String aSchemaName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSchemaName
- java.lang.String, the journal schema namepublic void openOnNextTable() throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
public void openOnNextTableForSchema(java.lang.String aSchemaName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSchemaName
- java.lang.String, the journal schema namepublic int queryLastRecordNumber() throws DSESQLException, DSEInternalErrorException
public Hashtable retrieveLastRecord() throws DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
public void retrieveLastRecord(Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic void retrieveLastRecord(Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.ContextaFormatName
- java.lang.Stringpublic Vector retrieveLastRecords(int aNumber) throws DSEInternalErrorException, DSEInvalidArgumentException, DSEInvalidRequestException, DSESQLException
aNumber
- int, the number of records to retrievepublic void retrieveLastRecords(int aNumber, Context aContext, HashtableIndexedCollectionFormat anOutputFormat) throws DSEInternalErrorException, DSEInvalidArgumentException, DSEInvalidRequestException, DSESQLException, DSEObjectNotFoundException
aNumber
- int, the number of records to retrieveaContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormat
- com.ibm.dse.base.HashtableIndexedCollectionFormat, the formatter to unformat the retrieved recordspublic void retrieveLastRecords(int aNumber, Context aContext, java.lang.String anOutputFormatName) throws DSEInternalErrorException, DSEInvalidArgumentException, DSEInvalidRequestException, DSESQLException, DSEObjectNotFoundException
aNumber
- int, the number of records to retrieveaContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormatName
- java.lang.String, the name of the formatter to unformat the retrieved recordspublic Hashtable retrieveRecord(int aRecordNumber) throws DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the record numberpublic void retrieveRecord(int aRecordNumber, Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- intaContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic void retrieveRecord(int aRecordNumber, Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- intaContext
- com.ibm.dse.base.ContextaFormatName
- java.lang.Stringpublic Vector retrieveRecords(java.lang.String aSearchCondition) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.String, the search condition in SQL formatpublic void retrieveRecords(java.lang.String aSearchCondition, Context aContext, HashtableIndexedCollectionFormat anOutputFormat) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEObjectNotFoundException
aSearchCondition
- java.lang.String, the search condition in SQL formataContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormat
- com.ibm.dse.base.HashtableIndexedCollectionFormat, the formatter to unformat the retrieved recordspublic void retrieveRecords(java.lang.String aSearchCondition, Context aContext, java.lang.String anOutputFormatName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEObjectNotFoundException
aSearchCondition
- java.lang.String, the search condition in SQL formataContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormatName
- java.lang.String, the name of the formatter to unformat the retrieved recordspublic Vector retrieveRecords(java.lang.String aSearchCondition, Vector aColumnsVector) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.String, the search condition in SQL formataColumnsVector
- com.ibm.dse.base.Vector, the vector that contains the columns to be retrievedpublic void retrieveRecords(java.lang.String aSearchCondition, Vector aColumnsVector, Context aContext, HashtableIndexedCollectionFormat anOutputFormat) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEObjectNotFoundException
aSearchCondition
- java.lang.String, the search condition in SQL formataColumnsVector
- com.ibm.dse.base.Vector, the vector that contains the columns to be retrievedaContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormat
- com.ibm.dse.base.HashtableIndexedCollectionFormat, the formatter to unformat the retrieved recordspublic void retrieveRecords(java.lang.String aSearchCondition, Vector aColumnsVector, Context aContext, java.lang.String anOutputFormatName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEObjectNotFoundException
aSearchCondition
- java.lang.String, the search condition in SQL formataColumnsVector
- com.ibm.dse.base.Vector, the vector that contains the columns to be retrievedaContext
- com.ibm.dse.base.Context the context to where the retrieved records will be unformattedanOutputFormatName
- java.lang.String, the name of the formatter to unformat the retrieved recordspublic void rollback() throws DSESQLException
protected void setColumnsTable(Hashtable aColumnsHashtable)
aColumnsHashtable
- Hashtablepublic void setCreateSchema(boolean newCreateSchema)
newCreateSchema
- booleanprotected void setDatabaseConnection(java.sql.Connection aDatabaseConnection)
aDatabaseConnection
- Connectionpublic void setEntity(java.lang.String anEntityName)
anEntityName
- java.lang.Stringpublic void setJDBCDriver(java.lang.String newJDBCDriver)
newJDBCDriver
- java.lang.Stringpublic void setSchemaName(java.lang.String aSchemaName)
aSchemaName
- java.lang.String, the journal schema nameprotected void setTableName(java.lang.String aTableName)
aTableName
- java.lang.Stringprotected java.lang.String tableName(java.lang.String aSchemaName, java.lang.String anEntityName, int aGeneration)
aSchemaName
- java.lang.String, the schema nameanEntityName
- java.lang.String, the entity nameaGeneration
- int, the generation numberpublic Vector toStrings()
public int updateLastRecord(Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic int updateLastRecord(Context aContext, HashtableFormat aHashtableFormat, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormataColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateLastRecord(Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name to be usedpublic int updateLastRecord(Context aContext, java.lang.String aFormatName, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name to be usedaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateLastRecord(Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aDataHashtable
- Hashtable, the Hashtable that contains the datapublic int updateLastRecord(Hashtable aDataHashtable, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aDataHashtable
- Hashtable, the Hashtable that contains the dataaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecord(int aRecordNumber, Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic int updateRecord(int aRecordNumber, Context aContext, HashtableFormat aHashtableFormat, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormataColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecord(int aRecordNumber, Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name to be usedpublic int updateRecord(int aRecordNumber, Context aContext, java.lang.String aFormatName, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name to be usedaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecord(int aRecordNumber, Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaDataHashtable
- Hashtable, the Hashtable containing the new datapublic int updateRecord(int aRecordNumber, Hashtable aDataHashtable, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInternalErrorException, DSEInvalidRequestException, DSESQLException
aRecordNumber
- int, the number of the record to be updatedaDataHashtable
- com.ibm.dse.base.Hashtable, the Hashtable that contains the new dataaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecords(java.lang.String aSearchCondition, Context aContext, HashtableFormat aHashtableFormat) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.StringaContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormatpublic int updateRecords(java.lang.String aSearchCondition, Context aContext, HashtableFormat aHashtableFormat, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.StringaContext
- com.ibm.dse.base.ContextaHashtableFormat
- com.ibm.dse.base.HashtableFormataColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecords(java.lang.String aSearchCondition, Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.String, the search conditionaContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name that defines the formatter to be usedpublic int updateRecords(java.lang.String aSearchCondition, Context aContext, java.lang.String aFormatName, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.String, the search conditionaContext
- com.ibm.dse.base.Context, the context with the dataaFormatName
- java.lang.String, the journal format name that defines the formatter to be usedaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changedpublic int updateRecords(java.lang.String aSearchCondition, Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException
aSearchCondition
- java.lang.String, the search conditionaDataHashtable
- Hashtable, the Hashtable that contains the new datapublic int updateRecords(java.lang.String aSearchCondition, Hashtable aDataHashtable, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInternalErrorException, DSEInvalidRequestException, DSESQLException
aSearchCondition
- java.lang.String, the search conditionaDataHashtable
- com.ibm.dse.base.Hashtable, the Hashtable that contains the new dataaColumnsVector
- com.ibm.dse.base.Vector, the columns to be changed
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |