void |
addRecord(Context aContext,
HashtableFormat aHashtableFormat)
Methods inherited from class com.ibm.btt.services.jdbc.JDBCService |
buildStatementArray, connect, getAddPstmt, getAddString, getAutoCommit, getConnectionManager, getConnectionProperties, getConnMgrID, getDatabaseConnection, getDatabaseURL, getDataSourceName, getPassword, getPoolName, getSharedConnection, getUpdateString, getUser, isWaitRetry, requestConnectionToConnectionManager, requestConnectionToConnectionManager, setAddPstmt, setAddString, setAutoCommit, setConnectionManager, setConnectionProperties, setConnMgrID, setDatabaseConnection, setDatabaseURL, setDataSourceName, setPassword, setPoolName, setSharedConnection, setStatementPoolSize, setUpdateString, setUser, verifyConnection |
Methods inherited from class com.ibm.btt.base.Service |
externalizer, getExternalizer, getTagName, readExternal, readExternal, readObject, removeExternal, setExternalizer, toString, toTags, writeExternal, writeExternal |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
COMPID
public static final java.lang.String COMPID
- Keeps the component identification that will be used by the traces tool.
- See Also:
- Constant Field Values
autoConnect
protected boolean autoConnect
- Keeps the connection criteria that the JDBCTable service must follow. If
it is set to true, the service will take care of managing the connection
to the database.
tableName
protected java.lang.String tableName
- The name of the table the JDBCTable service will work with.
schema
protected java.lang.String schema
- The name of database schema where the table is created. It is used to get
the database table primary keys.
primaryKeys
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. The first one is the default behavior and requires the
getPrimaryKeys() method to be implemented by the JDBC driver being used.
catalog
protected java.lang.String catalog
- The name of database catalog where the table is created. It is used to
get the database table primary keys.
columnsTable
protected Hashtable columnsTable
- Contains information about the relationship between a column in the
database table and a data field in the context. Has the following
structure: key = column_name, value = data_field_name.
JDBCDriver
protected java.lang.String JDBCDriver
- Keeps the name of the JDBC driver to be used to access the database.
primaryKeysHashtable
protected Hashtable primaryKeysHashtable
- Keeps the table primary keys for all the tables being accessed using a
JDBCTable instance. The key is the full table name and the value is a
Vector with the names of the table columns that are primary keys.
tablesMetaData
protected static Hashtable tablesMetaData
- Keeps the table meta data information for all the tables being accessed
using a JDBCTable instance. The key is the full table name and the value
is an instance of the DatabaseResultSetMetaData class.
JDBCTable
public JDBCTable()
- This constructor creates a JDBCTable object.
JDBCTable
public JDBCTable(java.lang.String aName)
throws java.io.IOException
- This constructor creates a JDBCTable object. It sets the service name to
be aName.
- Parameters:
aName - java.lang.String
- Throws:
java.io.IOException - if an I/O exception has occurred.
addRecord
public void addRecord(Context aContext,
HashtableFormat aHashtableFormat)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException,
DSEInvalidClassException
- Calls the format method of the hashtable formatter aHashtableFormat by
passing the aContext context as an argument. The returned object, a
Hashtable instance, is then used to build the table record by calling the
addRecord(Hashtable) method.
- Specified by:
addRecord in interface TableService
- Parameters:
aContext - com.ibm.dse.base.ContextaHashtableFormat - com.ibm.dse.base.HashtableFormat - the table formatter
- Throws:
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
addRecord
public void addRecord(Context aContext,
HashtableFormat aHashtableFormat,
Vector aColumnsVector)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException,
DSEInvalidClassException
- Calls the format method of the hashtable formatter aHashtableFormat by
passing the aContext context as an argument. The returned object, a
Hashtable instance, is then used to build the table record by calling the
addRecord(Hashtable, Vector) method. The aColumnsVector argument contains
the columns that will be added for the new record in the database; the
formatter definition must only contain the reference to these columns.
- Specified by:
addRecord in interface TableService
- Parameters:
aContext - com.ibm.dse.base.ContextaHashtableFormat - com.ibm.dse.base.HashtableFormat - the table formatteraColumnsVector - com.ibm.dse.base.Vector - the vector that contains the columns
to be added
- Throws:
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
addRecord
public void addRecord(Context aContext,
java.lang.String aFormatName)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException,
DSEInvalidClassException,
java.io.IOException
- Instantiates the table format named aFormatName and calls its format
method by passing the aContext as an argument. The returned object, a
Hashtable instance, is then used to build the table record by calling the
addRecord(Hashtable) method.
- Specified by:
addRecord in interface TableService
- Parameters:
aContext - com.ibm.btt.base.ContextaFormatName - java.lang.String - the table formatter name
- Throws:
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
addRecord
public void addRecord(Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException,
DSEInvalidClassException,
java.io.IOException
- Instantiates the table format named aFormatName and calls its format
method by passing the aContext context as an argument. The returned
object, a Hashtable instance, is then used to build the table record by
calling the addRecord(Hashtable, Vector) method. The aColumnsVector
argument contains the columns that will be added for the new record in
the database; the formatter definition must only contain the reference to
these columns.
- Specified by:
addRecord in interface TableService
- Parameters:
aContext - com.ibm.btt.base.ContextaFormatName - java.lang.String - the table formatter nameaColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be added
- Throws:
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
addRecord
public void addRecord(Hashtable aDataHashtable)
throws DSEInvalidRequestException,
DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException,
DSEException
- Inserts the data from aDataHashtable as a new row into the table assigned
to the table service. The data hashtable has the following format:
key=data_field_name, value=data_field_value
- Specified by:
addRecord in interface TableService
- Parameters:
aDataHashtable - Hashtable
- Throws:
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
addRecord
public void addRecord(Hashtable aDataHashtable,
Vector aColumnsVector)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEException
- Inserts a record in the database only passing values to the columns
specified in aColumnsVector. The aDataHashtable must contain only the
data field values of the columns that have to be added to the database.
- Specified by:
addRecord in interface TableService
- Parameters:
aDataHashtable - com.ibm.btt.base.Hashtable - the Hashtable that contains the
dataaColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be added
- Throws:
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
buildAddString
public void buildAddString()
throws DSESQLException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSEException
- Builds an instance variable that is used when adding a records.
- Specified by:
buildAddString in class JDBCService
- Throws:
DSEInvalidRequestException - if the request is not valid
DSEInternalErrorException - if an internal program error occurs
DSEInvalidArgumentException - if the argument(s) is(are) not valid
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
buildAddString
public void buildAddString(Vector aColumnsVector)
throws DSESQLException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSEException
- Builds an instance variable that is used when adding a record with only
specific columns values set by the application.
- Throws:
DSEInvalidRequestException - if the request is not valid
DSEInternalErrorException - if an internal program error occurs
DSEInvalidArgumentException - if the argument(s) is(are) not valid
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
buildConnectionProperties
protected void buildConnectionProperties()
- Build the Hashtable containing all details needed to request the database
connection. It is called by the initializeFrom() method.
- Overrides:
buildConnectionProperties in class JDBCService
buildUpdateString
public void buildUpdateString()
throws DSESQLException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSEException
- Builds an instance variable that is used when updating all columns of a
record.
- Specified by:
buildUpdateString in class JDBCService
- Throws:
DSEInvalidRequestException - if the request is not valid
DSEInternalErrorException - if an internal program error occurs
DSEInvalidArgumentException - if the argument(s) is(are) not valid
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
commit
public void commit()
throws DSESQLException
- Commits all changes to the database. Nothing is done if the autoCommit
attribute is set to true.
- Specified by:
commit in interface TableService
- Throws:
DSESQLException - if commit fails
connect
public void connect(java.lang.String aDatabaseURL)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database. A logon panel is shown by the database system
in which the user enters an ID and password, which are needed to run any
operation to the requested database. For mandatory user ID and passwords
(as occurs when using the JDBC DB2 net driver), an incorrect user ID or
password results in an exception (DSESQLException).
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aDatabaseURL - java.lang.String - the database URL
- Throws:
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 manager
connect
public void connect(java.lang.String aUser,
java.lang.String aPassword)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database set in the DataSource definition using aUser and
aPassword. This method can only be used if the connection is requested
using a pool of connections implemented as a DataSource with the database
URL specified as part of the DataSource definition.
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aUser - java.lang.String - the user identificationaPassword - java.lang.String - the user password
- Throws:
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 manager
connect
public void connect(java.lang.String aDatabaseURL,
java.lang.String aUser,
java.lang.String aPassword)
throws DSESQLException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database in the URL aDatabaseURL using aUser and
aPassword.
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aDatabaseURL - java.lang.String - the database URLaUser - java.lang.String - the user identificationaPassword - java.lang.String - the user password
- Throws:
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 manager
connect
public void connect(java.lang.String aDatabaseURL,
Context aContext)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database. A logon panel is shown by the database system
in which the user enters an ID and password, which are needed to run any
operation to the requested database. For mandatory user ID and passwords
(as occurs when using the JDBC DB2 net driver), an incorrect user ID or
password results in an exception (DSESQLException).
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aDatabaseURL - java.lang.String - the database URLaContext - com.ibm.btt.base.Context - the context where the
JDBCServiceConnectionManager is defined
- Throws:
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 manager
connect
public void connect(java.lang.String aUser,
java.lang.String aPassword,
Context aContext)
throws DSESQLException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database set in the DataSource definition using aUser and
aPassword. This method can only be used if the connection is requested
using a pool of connections implemented as a DataSource with the database
URL specified as part of the DataSource definition.
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aUser - java.lang.String - the user identificationaPassword - java.lang.String - the user passwordaContext - com.ibm.btt.base.Context - the context where the
JDBCServiceConnectionManager is defined
- Throws:
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 manager
connect
public void connect(java.lang.String aDatabaseURL,
java.lang.String aUser,
java.lang.String aPassword,
Context aContext)
throws DSESQLException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEObjectNotFoundException,
DSEException
- Connects to the Database in the URL aDatabaseURL using aUser and
aPassword.
- Specified by:
connect in interface DatabaseConnect - Overrides:
connect in class JDBCService
- Parameters:
aDatabaseURL - java.lang.String - the database URLaUser - java.lang.String - the user identificationaPassword - java.lang.String - the user passwordaContext - com.ibm.btt.base.Context - the context where the
JDBCServiceConnectionManager is defined
- Throws:
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 manager
deleteRecordsMatching
public void deleteRecordsMatching(java.lang.String aSearchCondition)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException
- Deletes the records in the table that match the search criteria.
- Specified by:
deleteRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search criteria in SQL format
- Throws:
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
disconnect
public void disconnect()
throws DSEInvalidRequestException,
DSESQLException,
DSEException
- Closes the database connection.
- Specified by:
disconnect in interface DatabaseConnect - Overrides:
disconnect in class JDBCService
- Throws:
DSESQLException - if a SQLException occurs
DSEException - if an exception is thrown when calling the pool of
connections
DSEInvalidRequestException - if the database connection is null
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
Hashtable dataHashtable,
HashtableFormat aHashtableOutputFormat)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSESQLException,
DSEInternalErrorException,
DSEException
- Executes the stored procedure procedureName with the parameters given in
the dataHashtable. The output parameters are unformatted with
aHashtableOutputFormat into aContext.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringdataHashtable - com.ibm.btt.base.HashtableaContext - com.ibm.btt.base.ContextaHashtableOutputFormat - com.ibm.btt.base.HashtableFormat
- Throws:
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
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
Hashtable dataHashtable,
java.lang.String aHashtableOutputFormatName)
throws DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException,
java.io.IOException
- Executes the stored procedureName with the parameters given in the
dataHashtable. The output parameters are unformatted with
aHashtableFormatName into the aContext.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringdataHashtable - com.ibm.btt.base.HashtableaContext - com.ibm.btt.base.ContextaHashtableOutputFormatName - java.lang.String
- Throws:
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 definition
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
HashtableFormat aHashtableInputFormat)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException,
DSEInvalidRequestException,
DSEException
- Builds a data Hashtable by calling the format method of the
aHashtableInputFormat with the aContext as an argument. The returned
Hashtable instance is then passed as parameter of the
executeProcedure(String, Hashtable) method.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableInputFormat - com.ibm.btt.base.HashtableFormat
- Throws:
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
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
HashtableFormat aHashtableInputFormat,
HashtableFormat aHashtableOutputFormat)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException,
DSEInvalidRequestException,
DSEException
- Builds a data Hashtable by calling the format method of the
aHashtableFormat with the aContext as an argument. The returned Hashtable
is then passed as a parameter of the executeProcedure(String, Context,
Hashtable, HashtableFormat) method.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableInputFormat - com.ibm.btt.base.HashtableFormataHashtableOutputFormat - com.ibm.btt.base.HashtableFormat
- Throws:
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
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
HashtableFormat aHashtableInputFormat,
java.lang.String aHashtableOutputFormatName)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException,
DSEInvalidRequestException,
DSEException,
java.io.IOException
- Builds a data Hashtable by calling the format method of the
aHashtableFormat with the aContext as an argument. The returned Hashtable
is then passed as a parameter of the executeProcedure(String, Context,
Hashtable, String) method.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableInputFormat - com.ibm.btt.base.HashtableFormataHashtableOutputFormatName - java.lang.String
- Throws:
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 definition
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Context aContext,
java.lang.String aHashtableInputFormatName)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException,
DSEInvalidRequestException,
DSEException,
java.io.IOException
- Instantiates the HashtableFormat defined as aHashtableInputFormatName and
passes it as an argument to the method executeProcedure(String, Context,
HashtableFormat).
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableInputFormatName - java.lang.String
- Throws:
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 definition
executeProcedure
public 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
- Instantiates the HashtableFormat defined as aHashtableInputFormatName and
passes it as an argument to the executeProcedure(String, Context,
HashtableFormat, String) method.
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableInputFormatName - java.lang.StringaHashtableOutputFormatName - java.lang.String
- Throws:
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 definition
executeProcedure
public void executeProcedure(java.lang.String procedureName,
Hashtable dataHashtable)
throws DSESQLException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEException
- Executes the stored procedure procedureName with the parameters given in
the dataHashtable
- Specified by:
executeProcedure in interface TableService
- Parameters:
procedureName - java.lang.StringdataHashtable - com.ibm.btt.base.Hashtable
- Throws:
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
connections
executeSQLQuery
public void executeSQLQuery(java.lang.String anSQLStatement,
java.lang.String outputFormatName,
Context aContext)
throws DSESQLException,
DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEException,
DSEObjectNotFoundException,
java.io.IOException
- Executes an SQL statement that returns a single ResultSet and unformats
it into aContext using the outputFormatName.
- Specified by:
executeSQLQuery in interface TableService
- Parameters:
anSQLStatement - java.lang.StringoutputFormatName - java.lang.StringaContext - com.ibm.btt.base.Context
- Throws:
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 definition
executeSQLQuery
public void executeSQLQuery(java.lang.String anSQLStatement,
HashtableIndexedCollectionFormat formatter,
Context aContext)
throws DSESQLException,
DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEException,
DSEObjectNotFoundException,
java.io.IOException
- Executes an SQL statement that returns a single ResultSet and unformats
it into aContext using the formatter.
- Parameters:
anSQLStatement - java.lang.Stringformatter - com.ibm.btt.base.HashtableIndexedCollectionFormataContext - com.ibm.btt.base.Context
- Throws:
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 definition
executeSQLUpdate
public int executeSQLUpdate(java.lang.String anSQLStatement)
throws DSESQLException,
DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEInternalErrorException,
DSEException
- Executes an SQL INSERT, UPDATE ,DELETE statement, or an SQL statement
that returns nothing. The method returns the row count for INSERT, UPDATE
or DELETE or 0 for a SQL statement that returns nothing.
- Specified by:
executeSQLUpdate in interface TableService
- Parameters:
anSQLStatement - java.lang.String
- Returns:
- int
- Throws:
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
getAutoConnect
public boolean getAutoConnect()
- Returns the autoConnect attribute value.
- Specified by:
getAutoConnect in interface TableService
- Returns:
- boolean
getCatalogName
public java.lang.String getCatalogName()
- Returns the catalog attribute value.
- Specified by:
getCatalogName in interface TableService
- Returns:
- java.lang.String
getColumnsTable
public Hashtable getColumnsTable()
- Returns the columnsTable attribute value.
- Returns:
- com.ibm.btt.base.Hashtable
getFullProcedureName
public 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.
- Returns:
- java.lang.String
getFullTableName
public java.lang.String getFullTableName()
- Builds and returns the full table name, adding the schema name if it is
set.
- Specified by:
getFullTableName in interface TableService
- Returns:
- java.lang.String
getInUse
public boolean getInUse()
- Returns the value of the inUse attribute.
- Specified by:
getInUse in interface Poolable
- Returns:
- boolean - The value of the inUse attribute
getJDBCDriver
public java.lang.String getJDBCDriver()
- Returns the JDBCDriver attribute value.
- Specified by:
getJDBCDriver in interface TableService
- Returns:
- java.lang.String
getMetaData
protected DatabaseResultSetMetaData getMetaData(java.lang.String aTableName)
throws DSEInternalErrorException,
DSESQLException,
DSEInvalidArgumentException,
DSEInvalidRequestException,
DSEException
- Returns a DatabaseResultSetMetaData instance with the table metadata
information. This method always gets this information from the database.
- Parameters:
aTableName - java.lang.String - the table name
- Returns:
- DatabaseResultSetMetaData
- Throws:
DSEInternalErrorException - if an internal program error occurs
DSESQLException - if an SQL Exception is caught
DSEInvalidArgumentException - if the argument is empty or null
DSEInvalidRequestException - if the request is not valid
DSEException - if an exception is thrown when calling the pool of
connections
getSchemaName
public java.lang.String getSchemaName()
- Returns the schema attribute value.
- Specified by:
getSchemaName in interface TableService
- Returns:
- java.lang.String
getTableName
public java.lang.String getTableName()
- Returns the tableName attribute value.
- Specified by:
getTableName in interface TableService
- Returns:
- java.lang.String
initialize
public void initialize()
throws DSEException
- Performs any required actions after service instanciation and before
starting using it.
- Specified by:
initialize in interface Poolable
- Throws:
DSEException
initializeColumnFrom
public java.lang.Object initializeColumnFrom(Tag aTag)
- Used by the JDBCTable service externalizer to create the contents of the
columnsTable instance attribute. The columnsTable is a Hashtable with a
key that is equal to the column name and a value that is equal to the
data field name in the context.
- Parameters:
aTag - com.ibm.btt.base.Tag
- Returns:
- java.lang.Object
initializeFrom
public java.lang.Object initializeFrom(Tag aTag)
throws java.io.IOException
- Used by the JDBCTable service externalizer to set the instance attributes
as defined in the XML file.
- Overrides:
initializeFrom in class Service
- Parameters:
aTag - com.ibm.btt.base.Tag
- Returns:
- java.lang.Object
- Throws:
java.io.IOException - if an I/O Exception has occurred
isConnected
public boolean isConnected()
throws DSEInvalidRequestException,
DSEInternalErrorException,
DSESQLException,
DSEException
- Returns true if there is a connection to the database or false if there
is not. If the autoConnect attribute has been set to true and the
connection to the database does not already exist, it creates its own
connection.
- Specified by:
isConnected in interface DatabaseConnect - Overrides:
isConnected in class JDBCService
- Returns:
- boolean
- Throws:
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
isConnectionOpen
public boolean isConnectionOpen()
throws DSESQLException,
DSEException
- Returns true if there is a connection to the database or false if there
is not. If the autoConnect attribute is false it has the same behaviour
than the isConnected method, but if it is true it does not try to
reconnect.
- Throws:
DSESQLException - if an SQLException is caught
DSEException - if an exception is thrown when checking the database
connection availability by calling the connection manager
For APAR JR18674
isPrimaryKeys
public boolean isPrimaryKeys()
- Returns the primaryKeys attribute value.
- Specified by:
isPrimaryKeys in interface TableService
- Returns:
- boolean
loadDriver
public void loadDriver()
throws DSEInternalErrorException
- Loads the JDBC Driver set in the service external definition file or the
default database JDBC Driver as set in the TableConstants
TB_DEFAULT_JDBCDRIVER attribute.
- Specified by:
loadDriver in interface TableService
- Throws:
DSEInternalErrorException - if an internal program error occurs
loadDriver
public void loadDriver(java.lang.String aDriverName)
throws DSEInternalErrorException
- Loads the specified database JDBC Driver.
- Specified by:
loadDriver in interface TableService
- Parameters:
aDriverName - java.lang.String - the driver name (full path)
- Throws:
DSEInternalErrorException - if an internal program error occurs
reset
public void reset()
throws DSEException
- Resets the table. This method is invoked when releasing the Poolable
object
- Specified by:
reset in interface Poolable
- Throws:
DSEException
retrieveRecordsMatching
public Vector retrieveRecordsMatching(java.lang.String aSearchCondition)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Retrieves all the records within the database table that match the search
condition.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL format
- Returns:
- com.ibm.btt.base.Vector - the vector of hash tables with the
retrieved records
- Throws:
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
retrieveRecordsMatching
public void retrieveRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
HashtableIndexedCollectionFormat anOutputFormat)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException,
java.io.IOException
- Retrieves all the records within the database table that match the search
condition. The retrieved records are then unformatted into the aContext
using anOutputFormat.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL formataContext - com.ibm.btt.base.Context - the context to where the retrieved
records will be unformattedanOutputFormat - com.ibm.btt.base.HashtableIndexedCollectionFormat - the
formatter to unformat the retrieved records
- Throws:
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 definition
retrieveRecordsMatching
public void retrieveRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String anOutputFormatName)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException,
java.io.IOException
- Retrieves all the records within the database table that match the search
condition. The retrieved records are then unformatted into the aContext
using the format named anOutputFormatName.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL formataContext - com.ibm.btt.base.Context - the context into which the
retrieved records will be unformattedanOutputFormatName - java.lang.String - the name of the formatter to unformat the
retrieved records
- Throws:
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 definition
retrieveRecordsMatching
public Vector retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Retrieves the columns in aColumnsVector of all the records within the
database table that match the search condition. The format used to put
the retrieved data into the operation context must only unformat the
returned column values.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL formataColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be retrieved
- Returns:
- com.ibm.btt.base.Vector - the vector of Hashtables with the
retrieved records
- Throws:
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
retrieveRecordsMatching
public void retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
HashtableIndexedCollectionFormat anOutputFormat)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Retrieves the columns in aColumnsVector of all the records within the
database table that match the search condition. The retrieved records are
then unformatted into the aContext using anOutputFormat.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL formataColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be retrievedaContext - com.ibm.btt.base.Context - the context into which the
retrieved records will be unformattedanOutputFormat - com.ibm.btt.base.HashtableIndexedCollectionFormat - the
formatter to unformat the retrieved records
- Throws:
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
retrieveRecordsMatching
public void retrieveRecordsMatching(java.lang.String aSearchCondition,
Vector aColumnsVector,
Context aContext,
java.lang.String anOutputFormatName)
throws DSEInternalErrorException,
DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException,
java.io.IOException
- Retrieves the columns in aColumnsVector of all the records within the
database table that match the search condition. The retrieved records are
then unformatted into the aContext using the format named
anOutputFormatName.
- Specified by:
retrieveRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search condition in SQL formataColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be retrievedaContext - com.ibm.btt.base.Context - the context into which the
retrieved records will be unformattedanOutputFormatName - java.lang.String - the name of the formatter to unformat the
retrieved records
- Throws:
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 definition
rollback
public void rollback()
throws DSESQLException
- Rolls back all the database changes if the autoCommit attribute is set to
false.
- Specified by:
rollback in interface TableService
- Throws:
DSESQLException - when rollback fails
rowToRecord
protected Hashtable rowToRecord(java.sql.ResultSet aResultSet)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSESQLException
- Converts a row in the ResultSet, which is obtained after executing the
SQL statement, to a data Hashtable.
- Parameters:
aResultSet - ResultSet - the retrieved row as a ResultSet
- Returns:
- com.ibm.btt.base.Hashtable - the retrieved row as a Hashtable
- Throws:
DSEInvalidArgumentException - if the parameters are not correct
DSEInternalErrorException - if an internal program error occurs
DSESQLException - if an other problem occurs
setAutoConnect
public void setAutoConnect(boolean b)
- Sets the autoConnect attribute to a boolean.
- Specified by:
setAutoConnect in interface TableService
- Parameters:
b - boolean
setCatalogName
public void setCatalogName(java.lang.String s)
- Sets the catalog attribute to the string provided as argument.
- Specified by:
setCatalogName in interface TableService
- Parameters:
s - java.lang.String
setColumnsTable
protected void setColumnsTable(Hashtable h)
- Sets the columnsTable attribute to a Hashtable.
- Parameters:
h - com.ibm.btt.base.Hashtable
setInUse
public void setInUse(boolean b)
- Sets the value of the inUse attribute.
- Specified by:
setInUse in interface Poolable
- Parameters:
b - -
The new value of the inUse attribute
setJDBCDriver
public void setJDBCDriver(java.lang.String newJDBCDriver)
- Sets the JDBCDriver attribute value to newJDBCDriver.
- Specified by:
setJDBCDriver in interface TableService
- Parameters:
newJDBCDriver - java.lang.String
setPrimaryKeys
public void setPrimaryKeys(boolean newPrimaryKeys)
- Sets the primaryKeys attribute value to newPrimaryKeys.
- Specified by:
setPrimaryKeys in interface TableService
- Parameters:
newPrimaryKeys - boolean
setSchemaName
public void setSchemaName(java.lang.String s)
- Sets the schema attribute to the string provided as an argument.
- Specified by:
setSchemaName in interface TableService
- Parameters:
s - java.lang.String
setTableName
public void setTableName(java.lang.String s)
- Sets the tableName attribute to the string provided as an argument.
- Specified by:
setTableName in interface TableService
- Parameters:
s - java.lang.String
setWaitRetry
public void setWaitRetry(boolean newWaitRetry)
- Sets the waitRetry attribute value to newWaitRetry.
- Specified by:
setWaitRetry in interface DatabaseConnect - Overrides:
setWaitRetry in class JDBCService
- Parameters:
newWaitRetry - boolean
terminate
public void terminate()
throws DSEException
- Performs any required actions before the service instance can be stopped.
- Specified by:
terminate in interface ProcessorNotifier - Specified by:
terminate in interface Poolable - Overrides:
terminate in class Service
- Throws:
DSEException
toStrings
public Vector toStrings()
- Creates a visual representation of the object. This is used by the
externalizer.
- Overrides:
toStrings in class Service
- Returns:
- com.ibm.btt.base.Vector
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
HashtableFormat aHashtableFormat)
throws DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Updates all of the table records that match the search condition with the
result from formatting the context data using the aHashtableFormat.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableFormat - com.ibm.btt.base.HashtableFormat
- Returns:
- int - the number of updated records
- Throws:
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 caught
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
HashtableFormat aHashtableFormat,
Vector aColumnsVector)
throws DSEInvalidRequestException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Updates the columns specified in aColumnsVector for the records that
match the search condition with the data provided in the operation
context. The aHashtableFormat must only format the new data values.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.StringaContext - com.ibm.btt.base.ContextaHashtableFormat - com.ibm.btt.base.HashtableFormataColumnsVector - com.ibm.btt.base.Vector the vector that contains the columns
to be updated
- Returns:
- int - the number of updated records
- Throws:
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 caught
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName)
throws DSEInvalidRequestException,
DSEInternalErrorException,
DSEInvalidArgumentException,
DSESQLException,
DSEInvalidClassException,
DSEException,
java.io.IOException
- Updates all the table records that match the search condition with the
result from formatting the context data using the formatter defined as
aFormatName.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search conditionaContext - com.ibm.btt.base.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
- Returns:
- int - the number of updated records
- Throws:
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 definition
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Context aContext,
java.lang.String aFormatName,
Vector aColumnsVector)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEInvalidClassException,
DSEException,
java.io.IOException
- Updates the columns specified in aColumnsVector for the records that
match the search condition with the data provided in the operation
context. The format identified by aHashtableFormatName must only format
the new data values.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.StringaContext - com.ibm.btt.base.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 - com.ibm.btt.base.Vector - the vector that contains the columns
to be updated
- Returns:
- int - the number of updated records
- Throws:
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 definition
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Hashtable aDataHashtable)
throws DSEInvalidRequestException,
DSEInternalErrorException,
DSEInvalidArgumentException,
DSESQLException,
DSEException
- Updates all the table records that match the search condition with the
Hashtable data.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.String - the search conditionaDataHashtable - Hashtable - the Hashtable that contains the new data
- Returns:
- int - the number of updated records
- Throws:
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
connections
updateRecordsMatching
public int updateRecordsMatching(java.lang.String aSearchCondition,
Hashtable aDataHashtable,
Vector aColumnsVector)
throws DSEInvalidArgumentException,
DSEInternalErrorException,
DSEInvalidRequestException,
DSESQLException,
DSEException
- Updates the columns specified in aColumnsVector for all the records which
match the search condition with the data provided in aDataHashtable. The
aDataHashtable must contain only the data field values of the columns
that have to be updated in the database.
- Specified by:
updateRecordsMatching in interface TableService
- Parameters:
aSearchCondition - java.lang.StringaDataHashtable - com.ibm.btt.base.Hashtable - the Hashtable that contains the
new dataaColumnsVector - com.ibm.btt.base.Vector - the vector that contains the columns
to be changed
- Returns:
- int - the number of updated records
- Throws:
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
(c) Copyright IBM Corporation 1998, 2009
|