| java.lang.Object
 com.salmonllc.sql.DataStoreBuffer
com.salmonllc.sql.DataStoreProxy
| DataStoreProxy | | public class DataStoreProxy extends DataStoreBuffer implements Runnable,Serializable,DataStoreInterface(Code) | | This class provides a storage buffer for data in SQL ResultSets for applets. The data is retrieved from a RemoteDataStore on a server via the DataServer servlet.
This class is intended to be used by applets served up by framework html pages that need to get data from a database. For each ProxyDataStore in the applet there needs to be one RemoteDataStore on the server. The following classes need to be in the applets jar file in order for the DataStoreProxy to work correctly:DataStoreBuffer, DataStoreEvaluator, DataStoreException, DataStoreInterface, DataStoreProxy, DataStoreRow, DSColumnDescriptor, DSDataRow, DSDataSourceProxy, DSDataStoreDescriptor, DSJoinDescriptor, DSQuickSort, DSTableAliasDescriptor
|
| Constructor Summary | |
| public | DataStoreProxy(String url, String sessionID)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver. | | public | DataStoreProxy(String url, String sessionID, boolean useCompression)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver. | | public | DataStoreProxy(String url, String userID, String passWord)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. | | public | DataStoreProxy(String url, String userID, String passWord, boolean useCompression)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. | | public | DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. | | public | DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword, String criteria)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. | | public | DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword, String criteria, boolean useCompression)
Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. |
| Method Summary | |
| public boolean | allDataRetrieved()
This method indicates whether all the data in the result set that is to be returned by the last retrieve statement has in fact been retrieved. | | public void | cancelRetrieve()
If a retrieve is in progress, this method will cancel it. | | public void | destroy()
This method will destroy the remote data store on the data server. | | public int | estimateRowsRetrieved()
Use this method to get the amount of rows that will be retrieved when a data store retrieve is executed. | | public int | estimateRowsRetrieved(String criteria)
Use this method to get the amount of rows that will be retrieved when a data store retrieve is executed. | | public String | getAlias(int tableNo)
This method returns the name of one of the aliases used by the datastore. | | public int | getAliasCount()
This method returns the number of aliases used by the datastore. | | public boolean | getCheckConcurrency()
Use this method to get whether or not the datastore will do a concurrency check when rows are updated and deleted. | | public String | getColumnDatabaseName(int col)
This method returns the database name of the column in the data store given its index. | | public String | getColumnTableName(int col)
This method returns the name of the database table that the column is for. | | public ColumnDefinition[] | getColumnsForTable(String table)
Returns a list of column definitions for a particular table in the database that the datastore is using. | | public boolean | getConcurrencyCheckColumn(int col)
This method is used to get whether a column should be used in the update, delete concurrency check. | | public boolean | getConcurrencyCheckColumn(String col)
This method is used to get whether a column should be used in the update, delete concurrency check. | | public String | getCriteria()
This method is used to get selection criteria filtering for the result set of the datastore. | | public String | getDBMS()
| | DSDataSourceProxy | getDataSourceProxy()
| | public String | getDefaultTable()
| | public boolean | getDistinct()
This method will return whether the distinct flag in the data store is set. | | public boolean | getEnableThreads()
Use this method to get whether or not the datastore does a retrieve in a separate thread. | | public String | getGroupBy()
This method returns the column list in the group by clause. | | public String | getHaving()
This method returns the having clause for the datastore. | | public int | getJoinColumnCount(int joinNo)
This method returns the number of columns in a particular join. | | public int | getJoinCount()
This method returns the number of joins in the datastore. | | public String | getJoinLeftColumn(int joinNo, int colNo)
This method returns a column on the left side of the join. | | public boolean | getJoinOuter(int joinNo)
This method returns the true if a particular join is outer. | | public int | getJoinRelationType(int joinNo)
This method returns the relation type of the join. | | public String | getJoinRightColumn(int joinNo, int colNo)
This method returns a column on the right side of the join. | | public boolean | getKeepDataOnServer()
| | public int | getMaxRows()
This method will return the maximum number of rows that the datastore will retrieve. | | public String | getOrderBy()
This method returns the order by clause for the datastore. | | public Properties | getProperties()
This method creates a properties object containing the definition of the data store. | | public String | getRemoteID()
| | public String | getSessionID()
| | public String | getTable(int tableNo)
This method returns the name of one of the tables used by the datastore. | | public String[] | getTableList(boolean updateable)
This method returns an array of all the tables referenced in the datastore. | | public boolean | getTrimStrings()
| | public int | getUpdateMethod()
Gets the update method for the datastore. | | public String | getUpdateResults()
Returns the results of the previous update. | | public int | getUseBindColumn(int col)
This method is used to get whether a column should use bind variables for inserts and updates. | | public int | getUseBindColumn(String col)
This method is used to get whether a column should use bind variables for inserts and updates. | | public boolean | getUseBindForUpdate()
Use this method to get whether or not the datastore will use bind variables as the default for updating or inserting columns. | | public boolean | getUseCompression()
| | public boolean | isPrimaryKey(int col)
| | public boolean | isPrimaryKey(String col)
| | public boolean | isUpdateable(int col)
| | public boolean | isUpdateable(String col)
| | public void | notifyListeners(ModelChangedEvent e)
| | public boolean | ping()
This method will ping the server for this particular data store. | | public synchronized void | reset()
This method will clear all rows in the dataStore. | | public void | retrieve()
Executes the sql statement and retrieves to data. | | public void | retrieve(String criteria)
Executes the sql statement and retrieves to data. | | public void | run()
The run method for the thread that retrieves the data from the database. | | public void | setEnableThreads(boolean truefalse)
| | public void | setKeepDataOnServer(boolean keepDataOnServer)
| | public void | setProperties(Properties p)
This method builds the datastore from the information in the properties object. | | public void | setRemoteID(String remoteID)
| | void | setUpdateResults(String updateResults)
| | public void | setUseCompression(boolean b)
Set to true for the DataStore to use compression to transmit data back and forth to the server. | | public int | unDeleteRow(int row)
This method will take a row from the datastores deleted buffer and move it back to the standard buffer.
Parameters:
row - The number of the row to undelete. | | public void | update()
This method will cause the database to reflect the changes made in the data store's buffer. | | public static void | update(DataStoreProxy[] ds)
| | void | updateDs(DSDataSourceProxy out)
| | protected void | validateColumn(int rowNo, int colNo, Vector v, DBConnection conn)
|
| BIND_DEFAULT | | final public static int BIND_DEFAULT(Code) | | |
| BIND_FALSE | | final public static int BIND_FALSE(Code) | | |
| BIND_TRUE | | final public static int BIND_TRUE(Code) | | |
| KEEP_DATA_ON_SERVER | | final public static String KEEP_DATA_ON_SERVER(Code) | | |
| OPERATION_CANCEL | | final public static String OPERATION_CANCEL(Code) | | |
| OPERATION_COUNT | | final public static String OPERATION_COUNT(Code) | | |
| OPERATION_CREATE | | final public static String OPERATION_CREATE(Code) | | |
| OPERATION_DESTROY | | final public static String OPERATION_DESTROY(Code) | | |
| OPERATION_GET_TABLE_COLUMNS | | final public static String OPERATION_GET_TABLE_COLUMNS(Code) | | |
| OPERATION_PING | | final public static String OPERATION_PING(Code) | | |
| OPERATION_RETRIEVE | | final public static String OPERATION_RETRIEVE(Code) | | |
| OPERATION_UPDATE | | final public static String OPERATION_UPDATE(Code) | | |
| OPERATION_VALIDATE | | final public static String OPERATION_VALIDATE(Code) | | |
| REMOTE_STATUS_ACCESS_DENIED | | final public static int REMOTE_STATUS_ACCESS_DENIED(Code) | | |
| REMOTE_STATUS_BAD_REQUEST | | final public static int REMOTE_STATUS_BAD_REQUEST(Code) | | |
| REMOTE_STATUS_NOT_FOUND | | final public static int REMOTE_STATUS_NOT_FOUND(Code) | | |
| REMOTE_STATUS_OK | | final public static int REMOTE_STATUS_OK(Code) | | |
| REMOTE_STATUS_SQL_ERROR | | final public static int REMOTE_STATUS_SQL_ERROR(Code) | | |
| UPDATEMETHOD_DELETEINSERTS | | final public static int UPDATEMETHOD_DELETEINSERTS(Code) | | |
| UPDATEMETHOD_UPDATES | | final public static int UPDATEMETHOD_UPDATES(Code) | | |
| USE_COMPRESSION | | final public static String USE_COMPRESSION(Code) | | |
| DataStoreProxy | | public DataStoreProxy(String url, String sessionID) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver. This class is intended to be use by applets served up by framework html pages that need to get data from a database. For each ProxyDataStore in the applet there needs to be one RemoteDataStore on the server. The following classes need to be in the applets jar file in order for the DataStoreProxy to work correctly:DataStoreBuffer, DataStoreEvaluator, DataStoreException, DataStoreProxy, DataStoreRow, DSColumnDescriptor, DSDataRow, DSDataSourceProxy, DSDataStoreDescriptor, DSJoinDescriptor, DSQuickSort, DSTableAliasDescriptor
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/DataServerURI/RemoteDataStoreClassName
Parameters:
sessionID - The server side session id to use. |
| DataStoreProxy | | public DataStoreProxy(String url, String sessionID, boolean useCompression) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver. This class is intended to be use by applets served up by framework html pages that need to get data from a database. For each ProxyDataStore in the applet there needs to be one RemoteDataStore on the server. The following classes need to be in the applets jar file in order for the DataStoreProxy to work correctly:DataStoreBuffer, DataStoreEvaluator, DataStoreException, DataStoreProxy, DataStoreRow, DSColumnDescriptor, DSDataRow, DSDataSourceProxy, DSDataStoreDescriptor, DSJoinDescriptor, DSQuickSort, DSTableAliasDescriptor
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/DataServerURI/RemoteDataStoreClassName
Parameters:
sessionID - The server side session id to use.
Parameters:
useCompression - Use zip compression to transfer data back from the server |
| DataStoreProxy | | public DataStoreProxy(String url, String userID, String passWord) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/DataServerURI/RemoteDataStoreClassName
Parameters:
userID - The user id to use.
Parameters:
passWord - The password to use. |
| DataStoreProxy | | public DataStoreProxy(String url, String userID, String passWord, boolean useCompression) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/DataServerURI/RemoteDataStoreClassName
Parameters:
userID - The user id to use.
Parameters:
passWord - The password to use.
Parameters:
useCompression - Use zip compression to transfer data back from the server |
| DataStoreProxy | | public DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/servlet/DataServer/Application/RemoteDataStore
Parameters:
userID - The user id to use.
Parameters:
passWord - The password to use.
Parameters:
proxyHost - The host name of a proxy server to use
Parameters:
proxyPort - The port number of a proxy server to use
Parameters:
proxyUser - The user id to get through the proxy server
Parameters:
proxyPassword - The password to get through the proxy server |
| DataStoreProxy | | public DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword, String criteria) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/servlet/DataServer/Application/RemoteDataStore
Parameters:
userID - The user id to use.
Parameters:
passWord - The password to use.
Parameters:
proxyHost - The host name of a proxy server to use
Parameters:
proxyPort - The port number of a proxy server to use
Parameters:
proxyUser - The user id to get through the proxy server
Parameters:
proxyPassword - The password to get through the proxy server
Parameters:
criteria - Additional criteria to pass to the server |
| DataStoreProxy | | public DataStoreProxy(String url, String userID, String passWord, String proxyHost, String proxyPort, String proxyUser, String proxyPassword, String criteria, boolean useCompression) throws DataStoreException(Code) | | Creates a new empty DataStore that will retrieve it's data from a remote dataserver.
Parameters:
url - The url of the RemoteDataStore. Remote DataStores urls follow the following convention http://hostname/servlet/DataServer/Application/RemoteDataStore
Parameters:
userID - The user id to use.
Parameters:
passWord - The password to use.
Parameters:
proxyHost - The host name of a proxy server to use
Parameters:
proxyPort - The port number of a proxy server to use
Parameters:
proxyUser - The user id to get through the proxy server
Parameters:
proxyPassword - The password to get through the proxy server
Parameters:
criteria - Additional criteria to pass to the server
Parameters:
useCompression - Use zip compression to transfer data back from the server |
| allDataRetrieved | | public boolean allDataRetrieved()(Code) | | This method indicates whether all the data in the result set that is to be returned by the last retrieve statement has in fact been retrieved.
true if all the data has been retrieved and false if the retrieve is still in progress. |
| cancelRetrieve | | public void cancelRetrieve()(Code) | | If a retrieve is in progress, this method will cancel it.
|
| destroy | | public void destroy() throws Exception(Code) | | This method will destroy the remote data store on the data server. All resources on the server will be reclaimed.
|
| estimateRowsRetrieved | | public int estimateRowsRetrieved() throws DataStoreException(Code) | | Use this method to get the amount of rows that will be retrieved when a data store retrieve is executed.
|
| estimateRowsRetrieved | | public int estimateRowsRetrieved(String criteria) throws DataStoreException(Code) | | Use this method to get the amount of rows that will be retrieved when a data store retrieve is executed.
Parameters:
criteria - The selection criteria to use for the select. |
| getAlias | | public String getAlias(int tableNo) throws DataStoreException(Code) | | This method returns the name of one of the aliases used by the datastore. Use the method getAliasCount() to find out how many tables or aliases are used by the datastore.
The table name. |
| getAliasCount | | public int getAliasCount()(Code) | | This method returns the number of aliases used by the datastore.
|
| getCheckConcurrency | | public boolean getCheckConcurrency()(Code) | | Use this method to get whether or not the datastore will do a concurrency check when rows are updated and deleted.
|
| getColumnDatabaseName | | public String getColumnDatabaseName(int col) throws DataStoreException(Code) | | This method returns the database name of the column in the data store given its index.
|
| getColumnTableName | | public String getColumnTableName(int col) throws DataStoreException(Code) | | This method returns the name of the database table that the column is for.
|
| getColumnsForTable | | public ColumnDefinition[] getColumnsForTable(String table)(Code) | | Returns a list of column definitions for a particular table in the database that the datastore is using. Note, the datastore must have an app name for this method to work.
|
| getConcurrencyCheckColumn | | public boolean getConcurrencyCheckColumn(int col) throws DataStoreException(Code) | | This method is used to get whether a column should be used in the update, delete concurrency check.
|
| getConcurrencyCheckColumn | | public boolean getConcurrencyCheckColumn(String col) throws DataStoreException(Code) | | This method is used to get whether a column should be used in the update, delete concurrency check.
|
| getCriteria | | public String getCriteria()(Code) | | This method is used to get selection criteria filtering for the result set of the datastore.
|
| getDBMS | | public String getDBMS()(Code) | | Returns the name of the database engine being used
|
| getDefaultTable | | public String getDefaultTable()(Code) | | This method returns the default table for the datastore
|
| getDistinct | | public boolean getDistinct()(Code) | | This method will return whether the distinct flag in the data store is set. The flag indicates that the distinct keyword should be placed at the beginning of a select statement.
|
| getEnableThreads | | public boolean getEnableThreads()(Code) | | Use this method to get whether or not the datastore does a retrieve in a separate thread.
|
| getGroupBy | | public String getGroupBy()(Code) | | This method returns the column list in the group by clause.
|
| getHaving | | public String getHaving()(Code) | | This method returns the having clause for the datastore.
|
| getJoinColumnCount | | public int getJoinColumnCount(int joinNo)(Code) | | This method returns the number of columns in a particular join.
|
| getJoinCount | | public int getJoinCount()(Code) | | This method returns the number of joins in the datastore.
|
| getJoinLeftColumn | | public String getJoinLeftColumn(int joinNo, int colNo)(Code) | | This method returns a column on the left side of the join.
|
| getJoinOuter | | public boolean getJoinOuter(int joinNo)(Code) | | This method returns the true if a particular join is outer.
|
| getJoinRelationType | | public int getJoinRelationType(int joinNo)(Code) | | This method returns the relation type of the join. (RELATION_ONE_TO_ONE, RELATION_ONE_TO_MANY, RELATION_MANY_TO_ONE)
|
| getJoinRightColumn | | public String getJoinRightColumn(int joinNo, int colNo)(Code) | | This method returns a column on the right side of the join.
|
| getKeepDataOnServer | | public boolean getKeepDataOnServer()(Code) | | Returns whether the data for this Proxy Datastore is also kept on the server
Default Value is false
true if the DataStore is keeping the data also on the server. |
| getMaxRows | | public int getMaxRows()(Code) | | This method will return the maximum number of rows that the datastore will retrieve. If the max is set to -1, the datastore will retrieve all rows in the result set. Otherwise it will stop retrieving when the max is reached.
|
| getOrderBy | | public String getOrderBy()(Code) | | This method returns the order by clause for the datastore.
|
| getProperties | | public Properties getProperties()(Code) | | This method creates a properties object containing the definition of the data store.
|
| getRemoteID | | public String getRemoteID()(Code) | | Used to get the remote id for the datastore
|
| getSessionID | | public String getSessionID()(Code) | | The id of the server session this proxy is using |
| getTable | | public String getTable(int tableNo) throws DataStoreException(Code) | | This method returns the name of one of the tables used by the datastore. Use the method getAliasCount() to find out how many tables or aliases are used by the datastore.
The table name. |
| getTableList | | public String[] getTableList(boolean updateable)(Code) | | This method returns an array of all the tables referenced in the datastore.
Parameters:
updateable - True if the table list should only include updateable tables and false if it should include all. |
| getTrimStrings | | public boolean getTrimStrings()(Code) | | Use this method to get whether the DataStore will trim (remove trailing spaces) from columns retrieved from the database;
|
| getUpdateResults | | public String getUpdateResults()(Code) | | Returns the results of the previous update.
|
| getUseBindColumn | | public int getUseBindColumn(int col) throws DataStoreException(Code) | | This method is used to get whether a column should use bind variables for inserts and updates. Valid values and BIND_TRUE, BIND_FALSE and BIND_DEFAULT (Use default for datastore)
|
| getUseBindColumn | | public int getUseBindColumn(String col) throws DataStoreException(Code) | | This method is used to get whether a column should use bind variables for inserts and updates. Valid values and BIND_TRUE, BIND_FALSE and BIND_DEFAULT (Use default for datastore)
|
| getUseBindForUpdate | | public boolean getUseBindForUpdate()(Code) | | Use this method to get whether or not the datastore will use bind variables as the default for updating or inserting columns.
|
| getUseCompression | | public boolean getUseCompression()(Code) | | true if the DataStore is using compression to transmit data back and forth to the server. |
| isPrimaryKey | | public boolean isPrimaryKey(int col) throws DataStoreException(Code) | | This method returns whether a column is part of the primary key
|
| isUpdateable | | public boolean isUpdateable(int col) throws DataStoreException(Code) | | This method returns whether a column is updateable
|
| notifyListeners | | public void notifyListeners(ModelChangedEvent e)(Code) | | Notifies all listeners that a model changed event occurred
|
| ping | | public boolean ping() throws Exception(Code) | | This method will ping the server for this particular data store. Pinging from time to time will prevent the server session from expiring.
true if the ping succeeds and false if not. |
| reset | | public synchronized void reset()(Code) | | This method will clear all rows in the dataStore.
|
| retrieve | | public void retrieve() throws DataStoreException(Code) | | Executes the sql statement and retrieves to data. The data is retrieved in a new thread so the beginning of the result set can be accessed before all the data has been retrieved.
You do not need to pass a database connection to this version of retrieve, but in order to use it the DataStore must be created with a constructor that passes an application (not the no args constructor).
|
| retrieve | | public void retrieve(String criteria) throws DataStoreException(Code) | | Executes the sql statement and retrieves to data. The data is retrieved in a new thread so the beginning of the result set can be accessed before all the data has been retrieved.
Parameters:
criteria - Additional selection criteria to use to limit the result set |
| run | | public void run()(Code) | | The run method for the thread that retrieves the data from the database. This method should not be called directly. Instead use the retrieve method.
|
| setEnableThreads | | public void setEnableThreads(boolean truefalse)(Code) | | Use this method to set whether or not the datastore will do retrieves in a separate thread
|
| setKeepDataOnServer | | public void setKeepDataOnServer(boolean keepDataOnServer)(Code) | | Sets whether the data for this Proxy Datastore is also kept on the server
|
| setProperties | | public void setProperties(Properties p)(Code) | | This method builds the datastore from the information in the properties object.
|
| setRemoteID | | public void setRemoteID(String remoteID)(Code) | | Used to set the remote id for the datastore
|
| setUpdateResults | | void setUpdateResults(String updateResults)(Code) | | |
| setUseCompression | | public void setUseCompression(boolean b)(Code) | | Set to true for the DataStore to use compression to transmit data back and forth to the server.
|
| unDeleteRow | | public int unDeleteRow(int row)(Code) | | This method will take a row from the datastores deleted buffer and move it back to the standard buffer.
Parameters:
row - The number of the row to undelete. Note: this is the row number of the row in the deleted buffer not the standard buffer. The number that the deleted row was moved to in the standard buffer or -1 if an error occurs. |
| Methods inherited from com.salmonllc.sql.DataStoreBuffer | public void addBucket(String internalname, int type)(Code)(Java Doc)
public void addBucket(String internalname, int type, String format)(Code)(Java Doc)
public void addExpressionRule(String column, DataStoreExpression expression, String errorMessage, boolean executeOnServer) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(String column, String expression, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(int column, DataStoreExpression expression, String errorMessage, boolean executeOnServer) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(int column, String expression, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addJavaScriptRule(String column, String javaScript, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addJavaScriptRule(int column, String javaScript, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addLookupRule(String column, String lookupTable, String searchExpression, String descriptionColumn, String descriptionBucket, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addLookupRule(int column, String lookupTable, String searchExpression, String descriptionColumn, String descriptionBucket, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addModelChangedListener(ModelChangedListener l)(Code)(Java Doc)
public void addRangeRule(int column, Object minValue, Object maxValue, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRangeRule(String column, Object minValue, Object maxValue, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRequiredRule(String column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRequiredRule(int column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addReqularExpressionRule(String column, String regExp, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addReqularExpressionRule(int column, String regExp, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addTypeCheckRule(String column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addTypeCheckRule(int column, String errorMessage) throws DataStoreException(Code)(Java Doc)
int addValidationRule(int column, ValidationRule rule) throws DataStoreException(Code)(Java Doc)
int addValidationRule(String column, ValidationRule rule) throws DataStoreException(Code)(Java Doc)
public void appendRows(Vector rows)(Code)(Java Doc)
protected boolean areThereModelListeners()(Code)(Java Doc)
public void autoRetrieve() throws Exception(Code)(Java Doc)
public void clearAllValidationRules()(Code)(Java Doc)
public void clearSelectedRow()(Code)(Java Doc)
public void clearTempValues(int row) throws DataStoreException(Code)(Java Doc)
public void clearTempValues() throws DataStoreException(Code)(Java Doc)
public void clearValidationRules(int column) throws DataStoreException(Code)(Java Doc)
public void clearValidationRules(String column) throws DataStoreException(Code)(Java Doc)
public int compareRows(int row1, int row2, int[] cols)(Code)(Java Doc)
public int compareRows(int row1, int row2, String[] cols)(Code)(Java Doc)
public Object convertValue(String val, String columnName) throws DataStoreException(Code)(Java Doc)
public static Object convertValue(String val, int dataType) throws ParseException(Code)(Java Doc)
void copyMasterDataValuesToRow(DataStoreBuffer.TablesRelationshipDescription dsTables, DataStoreRow fromrow, DataStoreRow torow) throws DataStoreException(Code)(Java Doc)
void copyMasterDataValuesToRow(DataStoreBuffer.TablesRelationshipDescription dsTables, DataStoreRow fromrow, DataStoreRow torow, int iTableRow) throws DataStoreException(Code)(Java Doc)
void copyMasterKeyValuesToRow(DataStoreBuffer.TablesRelationshipDescription dsTables, DataStoreRow fromrow, DataStoreRow torow, int iTableRow) throws DataStoreException(Code)(Java Doc)
public boolean deleteRow()(Code)(Java Doc)
public boolean deleteRow(int row)(Code)(Java Doc)
public String export() throws com.salmonllc.sql.DataStoreException(Code)(Java Doc)
public void export(int format, boolean includeHeaders, PrintWriter p)(Code)(Java Doc)
public void export(PrintWriter p) throws com.salmonllc.sql.DataStoreException(Code)(Java Doc)
public void filter(String filter) throws DataStoreException(Code)(Java Doc)
public void filterQBE(QBEBuilder filter) throws DataStoreException(Code)(Java Doc)
public synchronized int find(int start, int end) throws DataStoreException(Code)(Java Doc)
public synchronized boolean findFirst() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findLast() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findNext() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findPrior() throws DataStoreException(Code)(Java Doc)
public static String fixQuote(String data, int dataType)(Code)(Java Doc)
public static String fixQuote(String data, int dataType, String connectionType)(Code)(Java Doc)
protected String fixSpecialHTMLCharacters(String input)(Code)(Java Doc)
public boolean getAllowMasterRowDelete()(Code)(Java Doc)
public Object getAny(int column) throws DataStoreException(Code)(Java Doc)
public Object getAny(int row, int column) throws DataStoreException(Code)(Java Doc)
public Object getAny(int row, String column) throws DataStoreException(Code)(Java Doc)
public Object getAny(String column) throws DataStoreException(Code)(Java Doc)
public boolean getAutoBind()(Code)(Java Doc)
public int getAutoRetrieve()(Code)(Java Doc)
public AutoRetrieveCriteria getAutoRetrieveCriteria()(Code)(Java Doc)
static String getBoolProperty(boolean p)(Code)(Java Doc)
public boolean getBucketsModified()(Code)(Java Doc)
public boolean getBucketsModified(int row)(Code)(Java Doc)
public byte[] getByteArray(int column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(int row, int column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(int row, String column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(String column) throws DataStoreException(Code)(Java Doc)
public int getColumnCount()(Code)(Java Doc)
public int getColumnDataType(int column) throws DataStoreException(Code)(Java Doc)
public int getColumnDataType(String column) throws DataStoreException(Code)(Java Doc)
public int getColumnIndex(String column)(Code)(Java Doc)
public String[] getColumnList()(Code)(Java Doc)
public String getColumnName(int col) throws DataStoreException(Code)(Java Doc)
DSDataRow getDataRow(int rowNo)(Code)(Java Doc)
public DataStoreRow getDataStoreRow(int rowNo, int buffer) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int row, int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(String column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int row, int column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Timestamp getDateTime(String column) throws DataStoreException(Code)(Java Doc)
public int getDeletedCount()(Code)(Java Doc)
DSDataStoreDescriptor getDescriptor()(Code)(Java Doc)
public double getDouble(int column) throws DataStoreException(Code)(Java Doc)
public double getDouble(int row, int column) throws DataStoreException(Code)(Java Doc)
public double getDouble(int row, String column) throws DataStoreException(Code)(Java Doc)
public double getDouble(String column) throws DataStoreException(Code)(Java Doc)
public int getFilteredCount()(Code)(Java Doc)
public float getFloat(int column) throws DataStoreException(Code)(Java Doc)
public float getFloat(int row, int column) throws DataStoreException(Code)(Java Doc)
public float getFloat(int row, String column) throws DataStoreException(Code)(Java Doc)
public float getFloat(String column) throws DataStoreException(Code)(Java Doc)
public String getFormat(int col) throws DataStoreException(Code)(Java Doc)
public String getFormat(String col) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(String column) throws DataStoreException(Code)(Java Doc)
public int getInt(int column) throws DataStoreException(Code)(Java Doc)
public int getInt(int row, int column) throws DataStoreException(Code)(Java Doc)
public int getInt(int row, String column) throws DataStoreException(Code)(Java Doc)
public int getInt(String column) throws DataStoreException(Code)(Java Doc)
static String getIntProperty(int p)(Code)(Java Doc)
public LanguagePreferences getLang()(Code)(Java Doc)
public long getLong(int column) throws DataStoreException(Code)(Java Doc)
public long getLong(int row, int column) throws DataStoreException(Code)(Java Doc)
public long getLong(int row, String column) throws DataStoreException(Code)(Java Doc)
public long getLong(String column) throws DataStoreException(Code)(Java Doc)
protected Vector getModelListeners()(Code)(Java Doc)
public Object getNullDefault(int dataType)(Code)(Java Doc)
protected int getObjectType(Object obj)(Code)(Java Doc)
public Properties getProperties()(Code)(Java Doc)
public int getProxyRow(int rowNo)(Code)(Java Doc)
public String getRemoteID()(Code)(Java Doc)
public String getRemoteUpdateReturnValue()(Code)(Java Doc)
public int getRow()(Code)(Java Doc)
public int getRowCount()(Code)(Java Doc)
public int getRowStatus()(Code)(Java Doc)
public int getRowStatus(int row)(Code)(Java Doc)
public Vector getRows()(Code)(Java Doc)
public short getShort(int column) throws DataStoreException(Code)(Java Doc)
public short getShort(int row, int column) throws DataStoreException(Code)(Java Doc)
public short getShort(int row, String column) throws DataStoreException(Code)(Java Doc)
public short getShort(String column) throws DataStoreException(Code)(Java Doc)
public String getString(int column) throws DataStoreException(Code)(Java Doc)
public String getString(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getString(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getString(String column) throws DataStoreException(Code)(Java Doc)
static String getStringProperty(String p)(Code)(Java Doc)
public String[] getTableList(boolean updateable)(Code)(Java Doc)
TablesRelationshipDescription getTablesRelationshipDescription(DataStoreInterface ds)(Code)(Java Doc)
TablesRelationshipDescription getTablesRelationshipDescription(DataStoreInterface ds, boolean bUpdateable)(Code)(Java Doc)
public String getTempValue(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(String column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int row, int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(String column) throws DataStoreException(Code)(Java Doc)
public static String getTypeDescription(int type)(Code)(Java Doc)
public ValidationRule[] getValidationRulesForColumn(int colNo)(Code)(Java Doc)
public synchronized boolean gotoFirst()(Code)(Java Doc)
public synchronized boolean gotoLast()(Code)(Java Doc)
public synchronized boolean gotoNext()(Code)(Java Doc)
public synchronized boolean gotoPrior()(Code)(Java Doc)
public synchronized boolean gotoRow(int row)(Code)(Java Doc)
public boolean hasManyToOneRelationship()(Code)(Java Doc)
public boolean hasTempValues(int row) throws DataStoreException(Code)(Java Doc)
public void importRow(com.salmonllc.xml.Row row) throws DataStoreException(Code)(Java Doc)
public int insertRow()(Code)(Java Doc)
public int insertRow(int atPosition)(Code)(Java Doc)
protected synchronized void interruptWaitingCancelThreads()(Code)(Java Doc)
protected synchronized void interruptWaitingRetrieveThreads()(Code)(Java Doc)
public boolean isColumnInOneToManyRelationship(String sColumn)(Code)(Java Doc)
public boolean isColumnModified(int row, int column) throws DataStoreException(Code)(Java Doc)
public boolean isColumnModified(int row, String column) throws DataStoreException(Code)(Java Doc)
public boolean isFormattedStringValid(int column, String value) throws DataStoreException(Code)(Java Doc)
public boolean isFormattedStringValid(String column, String value) throws DataStoreException(Code)(Java Doc)
public void notifyListeners(ModelChangedEvent e)(Code)(Java Doc)
protected void notifyListeners(int type)(Code)(Java Doc)
public void removeModelChangedListener(ModelChangedListener l)(Code)(Java Doc)
public boolean removeRow()(Code)(Java Doc)
public boolean removeRow(int row)(Code)(Java Doc)
public synchronized void reset()(Code)(Java Doc)
public void resetStatus()(Code)(Java Doc)
public void setAllowMasterRowDelete(boolean bAllow)(Code)(Java Doc)
public void setAny(int row, int column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(int column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(int row, String column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(String column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAutoBind(boolean value)(Code)(Java Doc)
public void setAutoRetrieve(int value)(Code)(Java Doc)
public void setAutoRetrieveCriteria(AutoRetrieveCriteria crit)(Code)(Java Doc)
static boolean setBoolProperty(String p)(Code)(Java Doc)
public void setBucketsModified(int row, boolean modified)(Code)(Java Doc)
public void setBucketsModified(boolean modified)(Code)(Java Doc)
public void setByteArray(int column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(int row, int column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(int row, String column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(String column, byte[] value) throws DataStoreException(Code)(Java Doc)
protected void setCurrentRow(int currentRow)(Code)(Java Doc)
public void setDataStoreRow(int rowNo, int buffer, DataStoreRow row) throws DataStoreException(Code)(Java Doc)
public void setDate(int row, int column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(int row, String column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(int column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(String column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int row, int column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int row, String column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(String column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDistinct(boolean distinct)(Code)(Java Doc)
public void setDouble(int column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(int row, int column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(int row, String column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(String column, double value) throws DataStoreException(Code)(Java Doc)
public void setFindExpression(String exp) throws DataStoreException(Code)(Java Doc)
public void setFloat(int column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(int row, int column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(int row, String column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(String column, float value) throws DataStoreException(Code)(Java Doc)
public void setFormat(int col, String format) throws DataStoreException(Code)(Java Doc)
public void setFormat(String col, String format) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int row, int column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int row, String column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(String column, String value) throws DataStoreException(Code)(Java Doc)
public void setInt(int row, int column, int value) throws DataStoreException(Code)(Java Doc)
public void setInt(int row, String column, int value) throws DataStoreException(Code)(Java Doc)
public void setInt(String column, int value) throws DataStoreException(Code)(Java Doc)
static int setIntProperty(String p)(Code)(Java Doc)
public void setLang(LanguagePreferences preferences)(Code)(Java Doc)
public void setLong(int row, int column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(int column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(int row, String column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(String column, long value) throws DataStoreException(Code)(Java Doc)
public void setNullDefault(int dataType, Object defaultValue)(Code)(Java Doc)
public void setOrderBy(String orderBy)(Code)(Java Doc)
public void setPrimaryKey(int col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setPrimaryKey(String col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setProperties(Properties p)(Code)(Java Doc)
public void setRemoteID(String remoteID)(Code)(Java Doc)
public void setRemoteUpdateReturnValue(String update)(Code)(Java Doc)
public boolean setRowStatus(int status)(Code)(Java Doc)
public boolean setRowStatus(int row, int status)(Code)(Java Doc)
public void setRows(Vector rows)(Code)(Java Doc)
public void setShort(int row, int column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(int row, String column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(int column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(String column, short value) throws DataStoreException(Code)(Java Doc)
public void setString(int row, int column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(int column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(int row, String column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(String column, String value) throws DataStoreException(Code)(Java Doc)
static String setStringProperty(String p)(Code)(Java Doc)
public void setTempValue(int row, int col, String value) throws DataStoreException(Code)(Java Doc)
public void setTempValue(int col, String value) throws DataStoreException(Code)(Java Doc)
public void setTempValue(String col, String value) throws DataStoreException(Code)(Java Doc)
public void setTime(int row, int column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(int row, String column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(int column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(String column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void sort(int[] col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(int[] col, int dir, boolean bUseQSAlgoritm) throws DataStoreException(Code)(Java Doc)
public void sort(Object[] obj, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(String col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(int col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(DataStoreEvaluator eval, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(String col, int dir) throws DataStoreException(Code)(Java Doc)
public int unDeleteRow(int row)(Code)(Java Doc)
public void undoChanges(int row)(Code)(Java Doc)
public DataStoreException[] validateColumn(int rowNo, String colName, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateColumn(int rowNo, int colNo, DBConnection conn)(Code)(Java Doc)
protected void validateColumn(int rowNo, int colNo, Vector v, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateRow(int rowNo, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateRowsToUpdate(DBConnection conn, boolean stopAtFirstError)(Code)(Java Doc)
public boolean valueEqual(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public boolean valueGreater(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public boolean valueLess(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public void waitForCancel()(Code)(Java Doc)
public void waitForRetrieve()(Code)(Java Doc)
public void waitForRetrieve(int iSeconds)(Code)(Java Doc)
protected void waitForRow(int row)(Code)(Java Doc)
|
|
|