|
IBM Branch Transformation Toolkit Javadoc | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.ibm.btt.base.Service
com.ibm.btt.services.BTTServiceRequester
com.ibm.btt.services.PooledServiceRequester
com.ibm.btt.services.jdbcservicesinfra.JDBCService
com.ibm.btt.services.jdbctableservice.JDBCTableService
The JDBCTable class provides the interface to access any database table. It can use, as the underlying data store, any DBMS that implements the JDBC protocol.
Field Summary | |
---|---|
protected boolean |
autoConnect
Keeps the connection criteria that the JDBCTable service must follow. |
protected java.lang.String |
catalog
The name of database catalog where the table is created. |
protected Hashtable |
columnsTable
Contains information about the relationship between a column in the database table and a data field in the context. |
static java.lang.String |
COMPID
Keeps the component identification that will be used by the traces tool. |
protected java.lang.String |
JDBCDriver
Keeps the name of the JDBC driver to be used to access the database. |
protected boolean |
primaryKeys
Keeps whether the service must prevent the application from modify a primary key when updating a record (the service will automatically remove any column set in the update statement that is a primary key for the table) or the application itself will take care of this issue and then the service will throw an exception if the application tries to update a primary key. |
protected Hashtable |
primaryKeysHashtable
Keeps the table primary keys for all the tables being accessed using a JDBCTable instance. |
protected java.lang.String |
schema
The name of database schema where the table is created. |
protected java.lang.String |
tableName
The name of the table the JDBCTable service will work with. |
protected static Hashtable |
tablesMetaData
Keeps the table meta data information for all the tables being accessed using a JDBCTable instance. |
Fields inherited from class com.ibm.btt.services.jdbcservicesinfra.JDBCService |
---|
addPstmt, addString, autoCommit, connectionProperties, databaseConnection, databaseURL, dataSourceName, metaData, password, poolName, sharedConnection, STMT_POOL_SIZE_DEFAULT, stmtPool, stmtPoolSize, updateString, user, waitRetry |
Fields inherited from class com.ibm.btt.services.PooledServiceRequester |
---|
poolable, poolId |
Fields inherited from class com.ibm.btt.base.Service |
---|
externalizer, name |
Constructor Summary | |
---|---|
JDBCTableService()
This constructor creates a JDBCTable object. |
Method Summary | |
---|---|
void |
addRecord(Context aContext,
FormatElement aHashtableFormat)
Calls the format method of the hashtable formatter aHashtableFormat by passing the aContext context as an argument. |
void |
addRecord(Context aContext,
FormatElement aHashtableFormat,
Vector aColumnsVector)
Calls the format method of the hashtable formatter aHashtableFormat by passing the aContext context as an argument. |
void |
addRecord(Context aContext,
java.lang.String aFormatName)
Instantiates the table format named aFormatName and calls its format method by passing the aContext as an argument. |
void |
addRecord(Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
Instantiates the table format named aFormatName and calls its format method by passing the aContext context as an argument. |
void |
addRecord(Hashtable aDataHashtable)
Inserts the data from aDataHashtable as a new row into the table assigned to the table service. |
void |
addRecord(Hashtable aDataHashtable,
Vector aColumnsVector)
Inserts a record in the database only passing values to the columns specified in aColumnsVector. |
void |
commit()
Commits all changes to the database. |
void |
connect(java.lang.String aUser,
java.lang.String aPassword)
Connects to the Database set in the DataSource definition using aUser and aPassword. |
void |
deleteRecordsMatching(java.lang.String aSearchCondition)
Deletes the records in the table that match the search criteria. |
void |
disconnect()
Closes the database connection. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
FormatElement aHashtableInputFormat)
Builds a data Hashtable by calling the format method of the aHashtableInputFormat with the aContext as an argument. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
FormatElement aHashtableInputFormat,
FormatElement aHashtableOutputFormat)
Builds a data Hashtable by calling the format method of the aHashtableFormat with the aContext as an argument. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
FormatElement aHashtableInputFormat,
java.lang.String aHashtableOutputFormatName)
Builds a data Hashtable by calling the format method of the aHashtableFormat with the aContext as an argument. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
Hashtable dataHashtable,
FormatElement aHashtableOutputFormat)
Executes the stored procedure procedureName with the parameters given in the dataHashtable. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
Hashtable dataHashtable,
java.lang.String aHashtableOutputFormatName)
Executes the stored procedureName with the parameters given in the dataHashtable. |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
java.lang.String aHashtableInputFormatName)
Instantiates the HashtableFormat defined as aHashtableInputFormatName and passes it as an argument to the method executeProcedure(String, Context, HashtableFormat). |
void |
executeProcedure(java.lang.String procedureName,
Context aContext,
java.lang.String aHashtableInputFormatName,
java.lang.String aHashtableOutputFormatName)
Instantiates the HashtableFormat defined as aHashtableInputFormatName and passes it as an argument to the executeProcedure(String, Context, HashtableFormat, String) method. |
void |
executeProcedure(java.lang.String procedureName,
Hashtable dataHashtable)
Pass the s procedureName with the parameters given in the dataHashtable to execute storedproecdure in service object |
Hashtable |
executeProcedureWithReply(java.lang.String procedureName,
Hashtable dataHashtable)
Pass the stored procedureName with the parameters given in the dataHashtable. |
void |
executeSQLQuery(java.lang.String anSQLStatement,
java.lang.String outputFormatName,
Context aContext)
Executes an SQL statement that returns a single ResultSet and unformats it into aContext using the outputFormatName. |
int |
executeSQLUpdate(java.lang.String anSQLStatement)
Executes an SQL INSERT, UPDATE ,DELETE statement, or an SQL statement that returns nothing. |
boolean |
getAutoConnect()
Returns the autoConnect attribute value. |
java.lang.String |
getCatalogName()
Returns the catalog attribute value. |
Hashtable |
getColumnsTable()
Returns the columnsTable attribute value. |
java.lang.String |
getFullProcedureName(java.lang.String procedureName)
Builds and returns the full name for the Stored Procedure, adding the schema name if it is set. |
java.lang.String |
getFullTableName()
Builds and returns the full table name, adding the schema name if it is set. |
java.lang.String |
getSchemaName()
Returns the schema attribute value. |
java.lang.String |
getTableName()
Returns the tableName attribute value. |
void |
initialize()
Performs any required actions after service instanciation and before starting using it. |
boolean |
isConnected()
Returns true if there is a connection to the database or false if there is not. |
boolean |
isPrimaryKeys()
Returns the primaryKeys attribute value. |
Vector |
retrieveRecordsMatching(java.lang.String aSearchCondition)
Retrieves all the records within the database table that match the search condition. |
void |
retrieveRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
FormatElement anOutputFormat)
Retrieves all the records within the database table that match the search condition. |
void |
retrieveRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String anOutputFormatName)
Retrieves all the records within the database table that match the search condition. |
Vector |
retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector)
Retrieves the columns in aColumnsVector of all the records within the database table that match the search condition. |
void |
retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
FormatElement anOutputFormat)
Retrieves the columns in aColumnsVector of all the records within the database table that match the search condition. |
void |
retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
java.lang.String anOutputFormatName)
Retrieves the columns in aColumnsVector of all the records within the database table that match the search condition. |
void |
rollback()
Rolls back all the database changes if the autoCommit attribute is set to false. |
void |
setAutoConnect(boolean b)
Sets the autoConnect attribute to a boolean. |
void |
setCatalogName(java.lang.String s)
Sets the catalog attribute to the string provided as argument. |
void |
setPrimaryKeys(boolean newPrimaryKeys)
Sets the primaryKeys attribute value to newPrimaryKeys. |
void |
setSchemaName(java.lang.String s)
Sets the schema attribute to the string provided as an argument. |
void |
setTableName(java.lang.String s)
Sets the tableName attribute to the string provided as an argument. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
FormatElement aHashtableFormat)
Updates all of the table records that match the search condition with the result from formatting the context data using the aHashtableFormat. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
FormatElement aHashtableFormat,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for the records that match the search condition with the data provided in the operation context. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName)
Updates all the table records that match the search condition with the result from formatting the context data using the formatter defined as aFormatName. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for the records that match the search condition with the data provided in the operation context. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Hashtable aDataHashtable)
Updates all the table records that match the search condition with the Hashtable data. |
int |
updateRecordsMatching(java.lang.String aSearchCondition,
Hashtable aDataHashtable,
Vector aColumnsVector)
Updates the columns specified in aColumnsVector for all the records which match the search condition with the data provided in aDataHashtable. |
Methods inherited from class com.ibm.btt.services.jdbcservicesinfra.JDBCService |
---|
connect, getAutoCommit, getDataSourceName, getPassword, getUser, isWaitRetry, setAutoCommit, setDataSourceName, setPassword, setUser, setWaitRetry, verifyConnection |
Methods inherited from class com.ibm.btt.services.PooledServiceRequester |
---|
getGrantTime, getPoolable, getPoolable, getPoolId, getServiceID, grantServiceID, initializeFrom, initializeFrom, processRequest, releaseOrphan, releaseOrphan, releasePoolable, releaseServiceRequester, setGrantTime, setPoolId |
Methods inherited from class com.ibm.btt.services.BTTServiceRequester |
---|
getCachingEnabled, getInactiveTimeout, getLastAccess, getServiceInvocation, getServiceType, HashMapToHashtable, newInstance, setCachingEnabled, setInactiveTimeout, setLastAccess, setServiceID, setServiceInvocation, setServiceType |
Methods inherited from class com.ibm.btt.base.Service |
---|
externalizer, getExternalizer, getName, getTagName, readExternal, readExternal, readObject, removeExternal, setExternalizer, setName, terminate, toString, toStrings, toTags, writeExternal, writeExternal |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Methods inherited from interface com.ibm.btt.services.jdbctableservice.TableService |
---|
getAutoCommit, getPassword, getUser, setAutoCommit, setPassword, setUser |
Methods inherited from interface com.ibm.btt.services.jdbcservicesinfra.DatabaseConnect |
---|
getDataSourceName, isWaitRetry, setDataSourceName, setWaitRetry |
Field Detail |
public static final java.lang.String COMPID
protected boolean autoConnect
protected java.lang.String tableName
protected java.lang.String schema
protected boolean primaryKeys
protected java.lang.String catalog
protected Hashtable columnsTable
protected java.lang.String JDBCDriver
protected Hashtable primaryKeysHashtable
protected static Hashtable tablesMetaData
Constructor Detail |
public JDBCTableService()
Method Detail |
public void addRecord(Context aContext, FormatElement aHashtableFormat) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, DSEInvalidClassException, java.lang.Exception
addRecord
in interface TableService
aContext
- ContextaHashtableFormat
- HashtableFormat - the table formatter
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.lang.Exception
public void addRecord(Context aContext, FormatElement aHashtableFormat, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, DSEInvalidClassException, java.lang.Exception
addRecord
in interface TableService
aContext
- ContextaHashtableFormat
- HashtableFormat - the table formatteraColumnsVector
- Vector - the vector that contains the columns to be added
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.lang.Exception
public void addRecord(Context aContext, java.lang.String aFormatName) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, DSEInvalidClassException, java.io.IOException, java.lang.Exception
addRecord
in interface TableService
aContext
- ContextaFormatName
- java.lang.String - the table formatter name
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.io.IOException
- if there is an error instanciating the formatter from its external definition
java.lang.Exception
public void addRecord(Context aContext, java.lang.String aFormatName, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, DSEInvalidClassException, java.io.IOException, java.lang.Exception
addRecord
in interface TableService
aContext
- ContextaFormatName
- java.lang.String - the table formatter nameaColumnsVector
- Vector - the vector that contains the columns to be added
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.io.IOException
- if there is an error instanciating the formatter from its external definition
java.lang.Exception
public void addRecord(Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEException, java.lang.Exception
addRecord
in interface TableService
aDataHashtable
- Hashtable
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.lang.Exception
public void addRecord(Hashtable aDataHashtable, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInternalErrorException, DSEInvalidRequestException, DSESQLException, DSEException, java.lang.Exception
addRecord
in interface TableService
aDataHashtable
- Hashtable - the Hashtable that contains the dataaColumnsVector
- Vector - the vector that contains the columns to be added
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSEInvalidRequestException
- if the request is not valid
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.lang.Exception
public void commit() throws DSESQLException, java.lang.Exception
commit
in interface TableService
DSESQLException
- if commit fails
java.lang.Exception
public void connect(java.lang.String aUser, java.lang.String aPassword) throws DSEInternalErrorException, DSEInvalidRequestException, DSESQLException, DSEObjectNotFoundException, DSEException
connect
in interface DatabaseConnect
connect
in class JDBCService
aUser
- java.lang.String - the user identificationaPassword
- java.lang.String - the user password
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEObjectNotFoundException
- if the JDBCServicesConnectionManager cannot be found
DSEException
- if an exception is thrown when calling the pool of connections managerpublic void deleteRecordsMatching(java.lang.String aSearchCondition) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, java.lang.Exception
deleteRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search criteria in SQL format
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.lang.Exception
public void disconnect() throws DSEInvalidRequestException, DSESQLException, DSEException
disconnect
in interface DatabaseConnect
disconnect
in class JDBCService
DSESQLException
- if a SQLException occurs
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidRequestException
- if the database connection is nullpublic void executeProcedure(java.lang.String procedureName, Context aContext, Hashtable dataHashtable, FormatElement aHashtableOutputFormat) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSESQLException, DSEInternalErrorException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringdataHashtable
- HashtableaContext
- ContextaHashtableOutputFormat
- HashtableFormat
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
public void executeProcedure(java.lang.String procedureName, Context aContext, Hashtable dataHashtable, java.lang.String aHashtableOutputFormatName) throws DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringdataHashtable
- HashtableaContext
- ContextaHashtableOutputFormatName
- java.lang.String
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic Hashtable executeProcedureWithReply(java.lang.String procedureName, Hashtable dataHashtable) throws DSEInternalErrorException, DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEException, java.io.IOException
executeProcedureWithReply
in interface TableService
procedureName
- java.lang.StringdataHashtable
- Hashtable
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void executeProcedure(java.lang.String procedureName, Context aContext, FormatElement aHashtableInputFormat) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEInvalidRequestException, DSEException
executeProcedure
in interface TableService
procedureName
- java.lang.StringaContext
- ContextaHashtableInputFormat
- HashtableFormat
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connectionspublic void executeProcedure(java.lang.String procedureName, Context aContext, FormatElement aHashtableInputFormat, FormatElement aHashtableOutputFormat) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEInvalidRequestException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringaContext
- ContextaHashtableInputFormat
- HashtableFormataHashtableOutputFormat
- HashtableFormat
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
public void executeProcedure(java.lang.String procedureName, Context aContext, FormatElement aHashtableInputFormat, java.lang.String aHashtableOutputFormatName) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEInvalidRequestException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringaContext
- ContextaHashtableInputFormat
- HashtableFormataHashtableOutputFormatName
- java.lang.String
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void executeProcedure(java.lang.String procedureName, Context aContext, java.lang.String aHashtableInputFormatName) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEInvalidRequestException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringaContext
- ContextaHashtableInputFormatName
- java.lang.String
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQL Exception is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void executeProcedure(java.lang.String procedureName, Context aContext, java.lang.String aHashtableInputFormatName, java.lang.String aHashtableOutputFormatName) throws DSEInvalidArgumentException, DSEInternalErrorException, DSESQLException, DSEInvalidRequestException, DSEException, java.io.IOException
executeProcedure
in interface TableService
procedureName
- java.lang.StringaContext
- ContextaHashtableInputFormatName
- java.lang.StringaHashtableOutputFormatName
- java.lang.String
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void executeProcedure(java.lang.String procedureName, Hashtable dataHashtable) throws DSESQLException, DSEInvalidRequestException, DSEInternalErrorException, DSEException
executeProcedure
in interface TableService
procedureName
- java.lang.StringdataHashtable
- Hashtable
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSEException
- if an exception is thrown when calling the pool of connectionspublic void executeSQLQuery(java.lang.String anSQLStatement, java.lang.String outputFormatName, Context aContext) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSEException, DSEObjectNotFoundException, java.io.IOException
executeSQLQuery
in interface TableService
anSQLStatement
- java.lang.StringoutputFormatName
- java.lang.StringaContext
- Context
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEObjectNotFoundException
- if there is an error in the unformatting process
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic int executeSQLUpdate(java.lang.String anSQLStatement) throws DSESQLException, DSEInvalidArgumentException, DSEInvalidRequestException, DSEInternalErrorException, DSEException
executeSQLUpdate
in interface TableService
anSQLStatement
- java.lang.String
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEInvalidRequestException
- if the request is not valid
DSEException
- if an exception is thrown when calling the pool of connectionspublic boolean getAutoConnect() throws DSEException
getAutoConnect
in interface TableService
DSEException
public java.lang.String getCatalogName() throws DSEException
getCatalogName
in interface TableService
DSEException
public Hashtable getColumnsTable() throws DSEException
DSEException
public java.lang.String getFullProcedureName(java.lang.String procedureName) throws DSEException
DSEException
public java.lang.String getFullTableName() throws DSEException
getFullTableName
in interface TableService
DSEException
public java.lang.String getSchemaName() throws DSEException
getSchemaName
in interface TableService
DSEException
public java.lang.String getTableName() throws DSEException
getTableName
in interface TableService
DSEException
public void initialize() throws DSEException
DSEException
public boolean isConnected() throws DSEInvalidRequestException, DSEInternalErrorException, DSESQLException, DSEException
isConnected
in interface DatabaseConnect
isConnected
in class JDBCService
DSEInvalidRequestException
- if the request is not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connectionspublic boolean isPrimaryKeys() throws DSEException
isPrimaryKeys
in interface TableService
DSEException
public Vector retrieveRecordsMatching(java.lang.String aSearchCondition) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL format
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connectionspublic void retrieveRecordsMatching(java.lang.String aSearchCondition, Context aContext, FormatElement anOutputFormat) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL formataContext
- Context - the context to where the retrieved records will be unformattedanOutputFormat
- FormatElement - the formatter to unformat the retrieved records
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void retrieveRecordsMatching(java.lang.String aSearchCondition, Context aContext, java.lang.String anOutputFormatName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL formataContext
- Context - the context into which the retrieved records will be unformattedanOutputFormatName
- java.lang.String - the name of the formatter to unformat the retrieved records
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQL Exception is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic Vector retrieveRecordsMatching(java.lang.String aSearchCondition, Vector aColumnsVector) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL formataColumnsVector
- Vector - the vector that contains the columns to be retrieved
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connectionspublic void retrieveRecordsMatching(java.lang.String aSearchCondition, Vector aColumnsVector, Context aContext, FormatElement anOutputFormat) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL formataColumnsVector
- Vector - the vector that contains the columns to be retrievedaContext
- Context - the context into which the retrieved records will be unformattedanOutputFormat
- FormatElement - the formatter to unformat the retrieved records
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connectionspublic void retrieveRecordsMatching(java.lang.String aSearchCondition, Vector aColumnsVector, Context aContext, java.lang.String anOutputFormatName) throws DSEInternalErrorException, DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException, java.io.IOException
retrieveRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search condition in SQL formataColumnsVector
- Vector - the vector that contains the columns to be retrievedaContext
- Context - the context into which the retrieved records will be unformattedanOutputFormatName
- java.lang.String - the name of the formatter to unformat the retrieved records
DSEInvalidRequestException
- if the request is not valid
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic void rollback() throws DSESQLException, DSEException
rollback
in interface TableService
DSESQLException
- when rollback fails
DSEException
public void setAutoConnect(boolean b) throws DSEException
setAutoConnect
in interface TableService
b
- boolean
DSEException
public void setCatalogName(java.lang.String s) throws DSEException
setCatalogName
in interface TableService
s
- java.lang.String
DSEException
public void setPrimaryKeys(boolean newPrimaryKeys) throws DSEException
setPrimaryKeys
in interface TableService
newPrimaryKeys
- boolean
DSEException
public void setSchemaName(java.lang.String s) throws DSEException
setSchemaName
in interface TableService
s
- java.lang.String
DSEException
public void setTableName(java.lang.String s) throws DSEException
setTableName
in interface TableService
s
- java.lang.String
DSEException
public int updateRecordsMatching(java.lang.String aSearchCondition, Context aContext, FormatElement aHashtableFormat) throws DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.StringaContext
- ContextaHashtableFormat
- HashtableFormat
DSEInvalidArgumentException
- if an argument is not valid
DSEInvalidRequestException
- if the input parameters are not valid
DSEException
- if an exception is thrown when calling the pool of connections
DSESQLException
- if an SQLException is caughtpublic int updateRecordsMatching(java.lang.String aSearchCondition, Context aContext, FormatElement aHashtableFormat, Vector aColumnsVector) throws DSEInvalidRequestException, DSEInvalidArgumentException, DSESQLException, DSEException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.StringaContext
- ContextaHashtableFormat
- HashtableFormataColumnsVector
- Vector the vector that contains the columns to be updated
DSEInvalidArgumentException
- if an argument is not valid
DSEInvalidRequestException
- if the input parameters are not valid
DSEException
- if an exception is thrown when calling the pool of connections
DSESQLException
- if an SQLException is caughtpublic int updateRecordsMatching(java.lang.String aSearchCondition, Context aContext, java.lang.String aFormatName) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException, DSEInvalidClassException, DSEException, java.io.IOException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search conditionaContext
- Context - the context containing the new data valuesaFormatName
- java.lang.String - the name of the formatter that needs to be instantiated to format the data that is in the context
DSEInvalidArgumentException
- if an argument is not valid
DSEInvalidRequestException
- if the input parameters are not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic int updateRecordsMatching(java.lang.String aSearchCondition, Context aContext, java.lang.String aFormatName, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInternalErrorException, DSEInvalidRequestException, DSESQLException, DSEInvalidClassException, DSEException, java.io.IOException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.StringaContext
- Context - the context containing the new data valuesaFormatName
- java.lang.String - the name of the format that needs to be instantiated to format the data that is in the contextaColumnsVector
- Vector - the vector that contains the columns to be updated
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSEInvalidRequestException
- if the request is not valid
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
DSEInvalidClassException
- if there is an error in the formatting process
java.io.IOException
- if there is an error instanciating the formatter from its external definitionpublic int updateRecordsMatching(java.lang.String aSearchCondition, Hashtable aDataHashtable) throws DSEInvalidRequestException, DSEInternalErrorException, DSEInvalidArgumentException, DSESQLException, DSEException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.String - the search conditionaDataHashtable
- Hashtable - the Hashtable that contains the new data
DSEInvalidArgumentException
- if an argument is not valid
DSEInvalidRequestException
- if the input parameters are not valid
DSEInternalErrorException
- if an internal program error occurs
DSESQLException
- is an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connectionspublic int updateRecordsMatching(java.lang.String aSearchCondition, Hashtable aDataHashtable, Vector aColumnsVector) throws DSEInvalidArgumentException, DSEInternalErrorException, DSEInvalidRequestException, DSESQLException, DSEException
updateRecordsMatching
in interface TableService
aSearchCondition
- java.lang.StringaDataHashtable
- Hashtable - the Hashtable that contains the new dataaColumnsVector
- Vector - the vector that contains the columns to be changed
DSEInvalidArgumentException
- if the argument(s) is(are) not valid
DSEInternalErrorException
- if an internal program error occurs
DSEInvalidRequestException
- if the request is not valid
DSESQLException
- if an SQLException is caught
DSEException
- if an exception is thrown when calling the pool of connections
|
IBM Branch Transformation Toolkit Javadoc | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |