|
|||||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||||
| Uses of SQLContext in planetj.database |
| Methods in planetj.database that return SQLContext | |
SQLContext |
SQLContext.cloneContext()
Creates an unlocked copy of this SQLContext |
SQLContext |
SQLContext.cloneContext(boolean clearExecutingContext)
Creates an unlocked copy of this SQLContext |
SQLContext |
SQLContext.getKeyContext()
Gets the SQLContext to be used as a key in the cache. |
SQLContext |
SQLContext.setAutoRefresh(boolean newAutoRefresh)
Sets if RowCollections retrieved with this SQLContext should automatically refresh themselves when the DataEngine is used to update the database. |
SQLContext |
SQLContext.setAutoStartWOWConnection(boolean newAutoStartWOWConnection)
Sets if WOW Connection retrieved with this SQLContext should automatically start itself when the DataEngine is used to run a WOW operation. |
SQLContext |
SQLContext.setCacheResults(boolean newResultsCached)
Sets whether or not results from a query based on this context should be cached. |
SQLContext |
SQLContext.setCachingLevel(int newCachingLevel)
Sets the current caching level, describing whether the cache should be checked, and whether results should be stored in the cache. |
SQLContext |
SQLContext.setCachingTimeMillis(long milliseconds)
Sets the time in milliseconds the results from executing this context are to be cached. |
SQLContext |
SQLContext.setCheckCache(boolean newCacheChecked)
Sets whether or not queries resulting from this SQLContext should check the cache first, or go directly to the database. |
SQLContext |
SQLContext.setCheckFieldDataFileForFDs(boolean pCheckFieldDataFileForFDs)
Sets whether or not to check the Field data file when retrieving FieldDescriptors for newly created Fields in each Row. |
SQLContext |
SQLContext.setConnection(java.sql.Connection newConnection)
Sets the connection for this SQLContext. |
SQLContext |
SQLContext.setFirstRowIndex(int newFirstRow)
Insert the method's description here. |
protected SQLContext |
SQLContext.setKeyContext(SQLContext newKeyContext)
Sets the SQLContext to be used as a key in the cache. |
SQLContext |
SQLContext.setReportBreakCollection(ReportBreakCollection newReportBreakCollection)
Sets the ReportBreakCollection defining the reports that will be generated in the RowCollection resulting from queries which use this SQLContext |
SQLContext |
SQLContext.setReportBreakCollection(PropertyGroupList pProperties)
Sets the ReportBreakCollection defining the reports that will be generated in the RowCollection resulting from queries which use this SQLContext |
SQLContext |
SQLContext.setResultSetRetained(boolean value)
Sets whether or not the result set for this context should be retained for future accesses. |
SQLContext |
SQLContext.setRowClass(java.lang.Class newRowClass)
Sets the type of Row objects that will be included in the
RowCollection resulting from the query. |
SQLContext |
SQLContext.setRowCollection(RowCollection newRowCollection)
Sets the RowCollection object into which retrieved rows will be inserted. |
SQLContext |
SQLContext.setRowCollectionClass(java.lang.Class newRowCollectionClass)
Sets the type of RowCollection that will contain
this query's results. |
SQLContext |
SQLContext.setRowCount(int rows)
Sets the number of rows to include in the RowCollection. |
SQLContext |
SQLContext.setRowCreator(IRowCreator newRowCreator)
Sets the object used to create the Rows the query should return. |
SQLContext |
SQLContext.setRunInBackground(boolean newRunInBackground)
Sets if SQL commands using this context should run in a background thread. |
SQLContext |
SQLContext.setSQL(java.lang.String newSQL)
Sets the sql statement for this query. |
SQLContext |
SQLContext.setSQL(java.lang.String newSQL,
boolean shadowize)
Sets the sql statement for this query. |
protected SQLContext |
SQLContext.setSQLInternal(java.lang.String newSQL)
Deprecated. This method has a misleading name (JE 8/5/2004) |
SQLContext |
SQLContext.setSystemAlias(java.lang.String pAlias)
Sets the system alias for the SQL operation. |
SQLContext |
SQLContext.setTables(java.util.List pTables)
Deprecated. Pass in a TableCollection instead |
SQLContext |
SQLContext.setTables(TableCollection pTables)
Sets the tables to this query. |
SQLContext |
SQLContext.setTitle(java.lang.String pTitle)
Sets the title of this SQLContext, which will also be the title of any RowCollections retrieved via this SQLContext |
SQLContext |
SQLContext.setUsePreparedStatement(boolean usePS)
Sets if statements run with this SQLContext should use prepared statements. |
SQLContext |
RowCollection.getSQLContext()
Gets the SQL context that was used to create this RowCollection. |
protected SQLContext |
Row.createSQLContextForDelete(ExecutingContext ec)
Creates a new SQLContext which will be used for deleting this row. |
protected SQLContext |
Row.createSQLContextForInsert(ExecutingContext ec)
Creates a new SQLContext which will be used for inserting this row. |
protected SQLContext |
Row.createSQLContextForUpdate(ExecutingContext ec)
Creates a new SQLContext which will be used for updating this row. |
SQLContext |
Row.getCreationContext()
Gets the SQL context that was used when creating this Row |
SQLContext |
Row.getSQLContext()
Returns SQLContext to which the RowCollection this Row belongs has. |
| Methods in planetj.database with parameters of type SQLContext | |
boolean |
Table.createTableInDB(SQLContext context,
boolean overwrite,
java.util.List fds)
Creates this table in the database specified in the SQLContext. |
protected SQLContext |
SQLContext.setKeyContext(SQLContext newKeyContext)
Sets the SQLContext to be used as a key in the cache. |
java.lang.String |
RowCollection.copyToConnection(SQLContext context)
Copies the RowCollection to the specified SQLContext. |
static RowCollection |
RowCollection.createRowCollection(SQLContext context)
Creates a new RowCollection object based on the information in a SQLContext. |
int |
RowCollection.insert(SQLContext context)
Inserts all the rows in this RowCollection into the database. |
int |
RowCollection.insertBatchInternal(SQLContext context)
Inserts all the Rows in this RowCollection into the database in a single batch. |
protected int |
RowCollection.insertInternal(SQLContext context)
Inserts all the rows in this RowCollection into the database. |
boolean |
RowCollection.isOkToReturnMeFromCache(SQLContext pSQLContext)
Return a boolean indicating if it is ok to return this RowCollection for the specified SQLContext. |
boolean |
RowCollection.rowAltered(SQLContext context,
ExecutingContext ec)
This method is invoked when this RowCollection is in the cache, and a single row is deleted, inserted, or updated. |
void |
RowCollection.setInsertSQLContext(SQLContext newSQLContext)
Allows the RowCollection's SQLContext to be set as an insert context. |
protected void |
RowCollection.setSQLContext(SQLContext newSQLContext)
Sets the SQLContext for this RowCollection. |
static Row |
Row.create(SQLContext context,
java.util.List fieldNames,
boolean initializeRow)
Create and return a new Row from the given SQLContext. |
int |
Row.insert(SQLContext context)
Inserts this Row into the specified database. |
protected void |
Row.populate(java.sql.ResultSet pResults,
java.util.List pPhysicalNames,
java.sql.ResultSetMetaData pMetaData,
SQLContext pContext)
Populates this Row with the data from the result set. |
protected void |
Row.populate(java.sql.ResultSet pResults,
java.sql.ResultSetMetaData pMetaData,
SQLContext pContext)
Populates this Row with the data from the result set. |
void |
Row.setCreationContext(SQLContext context)
Sets the SQL context that was used when creating this Row |
void |
IDataEngineListener.exceptionOccurred(SQLContext context,
CMException cme,
int sqlOperation)
This method is invoked when a SQLContext object with which this listener is registered is used in a DataEngine operation which throws an exception. |
void |
IDataEngineListener.executionCompleted(SQLContext context)
Invoked whenever a SQLContext to which this object is listening is used to execute a SQL statement. |
void |
IDataEngineListener.queryCompleted(SQLContext context,
RowCollection rc)
This method is invoked when a SQLContext object with which this listener is registered is used in a DataEngine query. |
void |
IDataEngineListener.updateCompleted(SQLContext context,
int updated)
Invoked whenever a SQLContext to which this object is listening is used to update a database. |
java.sql.ResultSet |
DBSystem.getMetadataColumns(SQLContext context)
Return a ResultSet of Columns |
java.sql.ResultSet |
DBSystem.getMetadataTables(SQLContext context)
Return a ResultSet of Tables |
java.sql.ResultSet |
DBSystem.getMetadataLibraries(SQLContext context)
Return a ResultSet of libraries (schemas) |
static void |
DataEngine.autoStartConnection(SQLContext context)
This will ensure that a WOW connection is started. |
static void |
DataEngine.execute(SQLContext context)
Executes an SQL statement, based on a SQLContext. |
protected static boolean |
DataEngine.executeInternal(SQLContext context)
Executes an SQL statement, based on a SQLContext. |
static java.sql.ResultSet |
DataEngine.executeMetadataQuery(SQLContext context)
Returns a Result set from metadata. |
static java.sql.ResultSet |
DataEngine.executeQuery(SQLContext context)
Returns a Result set from executing a query based on the information in the SQLContext. |
static int |
DataEngine.executeUpdate(SQLContext context)
Updates the database, based on a SQLContext. |
protected static int |
DataEngine.executeUpdateInternal(SQLContext context)
Updates the database, based on a SQLContext. |
static java.lang.String |
DataEngine.fixSQLMetadataLibrary(java.lang.String sql,
SQLContext context)
Temporary fix so hardcoded queries to the PLANETJ library goto the actual metadata library |
static Row |
DataEngine.getRow(SQLContext context)
Retrieves the first row from the database based on the criteria in the SQLContext. |
static RowCollection |
DataEngine.getRows(SQLContext context)
Retrieves rows from the database based on the criteria in the SQLContext. |
protected static RowCollection |
DataEngine.getRowsInternal(SQLContext context)
Retrieves rows from the database based on the criteria in the SQLContext. |
| Uses of SQLContext in planetj.database.connection |
| Methods in planetj.database.connection with parameters of type SQLContext | |
int |
ConnectionRow.insert(SQLContext context)
Inserts this Row into the specified database. |
protected void |
ConnectionRow.populate(java.sql.ResultSet pResults,
java.util.List pPhysicalNames,
java.sql.ResultSetMetaData pMetaData,
SQLContext pContext)
Populates this Row with the data from the result set. |
static int |
ConnectionEvent.getEventType(SQLContext context)
Gets the correct event type for the SQLContext |
| Uses of SQLContext in planetj.database.fielddescriptors |
| Methods in planetj.database.fielddescriptors that return SQLContext | |
protected SQLContext |
FieldDescriptorRow.createSQLContextForUpdate(ExecutingContext ec)
Creates a new SQLContext which will be used for updating this row. |
| Methods in planetj.database.fielddescriptors with parameters of type SQLContext | |
int |
TableDescriptor.insert(SQLContext context)
Inserts this Row into the specified database. |
int |
FieldDescriptorRow.insert(SQLContext context)
Inserts this Row into its table. |
| Uses of SQLContext in planetj.database.flatfile |
| Methods in planetj.database.flatfile with parameters of type SQLContext | |
java.lang.Object |
FileServerOperation.execute(SQLContext sql)
|
| Uses of SQLContext in planetj.database.sql |
| Methods in planetj.database.sql that return SQLContext | |
SQLContext |
SQLStatement.getContext()
Gets the SQLContext from which this statement was created |
| Methods in planetj.database.sql with parameters of type SQLContext | |
static SQLStatement |
SQLStatement.createStatement(java.lang.String sql,
SQLContext context)
|
| Constructors in planetj.database.sql with parameters of type SQLContext | |
UpdateStatement(java.lang.String pSQLString,
SQLContext context)
SelectStatement constructor comment. |
|
SQLStatement(java.lang.String pOriginalSQLString,
SQLContext context)
SQLStatement constructor comment. |
|
SelectStatement(java.lang.String pSQLString,
SQLContext context)
SelectStatement constructor comment. |
|
LabelOnStatement(java.lang.String pOriginalSQLString,
SQLContext context)
LabelOnStatement constructor comment. |
|
InsertStatement(java.lang.String sql,
SQLContext context)
Constructor. |
|
DeleteStatement(java.lang.String pSQLString,
SQLContext context)
SelectStatement constructor comment. |
|
CreateViewStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CreateViewStatement constructor comment. |
|
CreateProcedureStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CreateProcedureStatement constructor comment. |
|
CreateIndexStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CreateIndexStatement constructor comment. |
|
CreateAliasStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CreateAliasStatement constructor comment. |
|
CommentOnStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CommentOnStatement constructor comment. |
|
CallStatement(java.lang.String pOriginalSQLString,
SQLContext context)
CallStatement constructor comment. |
|
| Uses of SQLContext in planetj.database.tracking |
| Methods in planetj.database.tracking with parameters of type SQLContext | |
static void |
DataAccessTrackingManager.insertTrackingRecord(SQLContext context,
long startTime,
long endTime)
|
| Uses of SQLContext in planetj.dataengine |
| Methods in planetj.dataengine with parameters of type SQLContext | |
int |
PropertyRow.insert(SQLContext context)
Inserts this Row into the specified database. |
| Uses of SQLContext in planetj.dataengine.application |
| Subclasses of SQLContext in planetj.dataengine.application | |
class |
ApplicationSQLContext
SQLContext used for queries which correspond to a specific Application or Operation |
| Methods in planetj.dataengine.application that return SQLContext | |
SQLContext |
ApplicationSQLContext.setTitle(java.lang.String title)
Sets the title of this SQLContext, which also becomes the title of its RC's |
protected SQLContext |
Application.createSQLContextForDelete(ExecutingContext ec)
Creates a new SQLContext which will be used for deleting this row. |
protected SQLContext |
Application.createSQLContextForInsert(ExecutingContext ec)
Creates a new SQLContext which will be used for inserting this row. |
protected SQLContext |
Application.createSQLContextForUpdate(ExecutingContext ec)
Creates a new SQLContext which will be used for updating this row. |
| Methods in planetj.dataengine.application with parameters of type SQLContext | |
int |
Application.insert(SQLContext context)
Inserts this Row into the specified database. |
| Uses of SQLContext in planetj.dataengine.cache |
| Methods in planetj.dataengine.cache with parameters of type SQLContext | |
protected RowCollection |
DataEngineCache.get(SQLContext key)
Gets a RowCollection out of the cache, based on the SQLContext. |
RowCollection |
DataEngineCache.getCachedRowCollection(SQLContext context)
Allow Cached RowCollections to decide if they can be used for a query. |
protected void |
DataEngineCache.put(SQLContext key,
RowCollection results)
Puts a RowCollection in the cache, keyed by the SQLContext. |
protected RowCollection |
DataEngineCache.remove(SQLContext key)
Removes a RowCollection from the cache, based on the SQLContext. |
void |
DataEngineCache.rowAltered(SQLContext context,
ExecutingContext ec,
long timestamp)
This method is invoked when a single row is deleted, inserted, or updated. |
RowCollection |
CacheManager.get(SQLContext key)
Gets a RowCollection out of the cache, based on the SQLContext. |
DataEngineCache |
CacheManager.getCache(SQLContext context)
Gets the appropriate cache for the SQLContext. |
void |
CacheManager.put(SQLContext key,
RowCollection results)
Puts a RowCollection in the cache, keyed by the SQLContext. |
RowCollection |
CacheManager.remove(SQLContext key)
Removes a RowCollection from the cache, based on the SQLContext. |
void |
CacheManager.rowAltered(SQLContext context,
ExecutingContext ec,
long timestamp)
This method is invoked when a single row is deleted, inserted, or updated. |
| Uses of SQLContext in planetj.dataengine.operation |
| Methods in planetj.dataengine.operation that return SQLContext | |
protected SQLContext |
Operation.createSQLContextForDelete(ExecutingContext ec)
Creates a new SQLContext which will be used for deleting this row. |
protected SQLContext |
Operation.createSQLContextForInsert(ExecutingContext ec)
Creates a new SQLContext which will be used for inserting this row. |
protected SQLContext |
Operation.createSQLContextForUpdate(ExecutingContext ec)
Creates a new SQLContext which will be used for updating this row. |
| Methods in planetj.dataengine.operation with parameters of type SQLContext | |
int |
Operation.insert(SQLContext context)
Inserts this Row into its table. |
int |
HTMLOperation.insert(SQLContext context)
Inserts this Row into its table. |
| Uses of SQLContext in planetj.dataengine.parameter |
| Methods in planetj.dataengine.parameter that return SQLContext | |
SQLContext |
SQLPromptParameter.getSQLContext()
Gets the SQLContext associated with this parameter |
| Uses of SQLContext in planetj.dataengine.possiblevalues |
| Methods in planetj.dataengine.possiblevalues with parameters of type SQLContext | |
int |
PossibleValuesSearchOperation.insert(SQLContext context)
|
| Uses of SQLContext in planetj.dataengine.sqloperation |
| Methods in planetj.dataengine.sqloperation with parameters of type SQLContext | |
java.lang.Object |
SQLOperation.createInsertObject(SQLContext context,
ExecutingContext ec)
Create an object that can be used to insert an object for this Operation. |
java.lang.Object |
SQLOperation.createInsertObject(SQLContext context,
ExecutingContext ec,
IRowEventListener listener)
Create an object that can be used to insert an object for this Operation. |
java.lang.Object |
SQLOperation.execute(SQLContext context)
Returns a result set that results from the SQL query Creation date: (4/23/2003 7:40:14 AM) |
Row |
SQLOperation.getInsertRow(SQLContext context,
ExecutingContext ec)
Gets the row to use for an insert (if this is an insert operation). |
| Uses of SQLContext in planetj.dataengine.verisign |
| Methods in planetj.dataengine.verisign with parameters of type SQLContext | |
int |
VerisignPaymentRow.insert(SQLContext context)
Here we need to do some special things due to derived field, and multiple database we need to insert into. |
| Uses of SQLContext in planetj.html |
| Methods in planetj.html with parameters of type SQLContext | |
protected java.lang.StringBuffer |
HTMLHorizontalGeneralComparisonInput.appendComparison(SQLContext context,
int colspan,
SQLComparison comparison,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected void |
HTMLHorizontalGeneralComparisonInput.appendComparisons(SQLContext context,
java.util.List comparisons,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected java.lang.StringBuffer |
HTMLHorizontalGeneralComparisonInput.appendValues(SQLContext context,
int colspan,
SQLComparison comparison,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected java.lang.StringBuffer |
HTMLHorizontalComparisonInput.appendComparison(SQLContext context,
boolean sameLine,
int colspan,
SQLComparison comparison,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected void |
HTMLHorizontalComparisonInput.appendComparisons(SQLContext context,
java.util.List comparisons,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected java.lang.StringBuffer |
HTMLHorizontalComparisonInput.appendValues(SQLContext context,
int colspan,
SQLComparison comparison,
boolean sameLine,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected java.lang.StringBuffer |
HTMLComparisonInput.appendComparison(SQLContext context,
SQLComparison comparison,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
protected void |
HTMLComparisonInput.appendComparisons(SQLContext context,
java.util.List comparisons,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
java.lang.StringBuffer |
HTMLComparisonInput.appendInput(Field field,
int unNamedIndex,
SQLContext context,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Deprecated. use HTMLParameterInput.appendInput |
protected static java.lang.StringBuffer |
HTMLComparisonInput.appendParameterId(SQLContext context,
int parameterNumber,
java.lang.StringBuffer buffer)
Appends the parameter id to use for the specified SQLContext, expressionIndex, and parameter number. |
protected java.lang.StringBuffer |
HTMLComparisonInput.appendValues(SQLContext context,
SQLComparison comparison,
java.lang.StringBuffer html,
HttpServletRequest request,
HttpServletResponse response)
Appends the given comparison to the given StringBuffer. |
void |
HTMLComparisonInput.clearValues(SQLContext context,
HttpServletRequest request)
Deprecated. This method affects all display parameters in the context - not just the ones that are part of a specific HTMLComparison |
java.lang.String |
HTMLComparisonInput.generateInput(SQLContext context,
int expressionIndex,
HttpServletRequest request,
HttpServletResponse response)
Generates input fields for all parameters in the SQLStatement contained in the SQLContext. |
static java.lang.String |
HTMLComparisonInput.getParameterId(SQLContext context,
int parameterNumber)
Gets the parameter id to use for the specified SQLContext, expression index and parameter number. |
void |
HTMLComparisonInput.loadSQLParameterValues(SQLContext context,
HttpServletRequest request)
Deprecated. Use HTMLParameterInput.loadParameterValues() instead |
| Uses of SQLContext in planetj.magic |
| Methods in planetj.magic that return SQLContext | |
SQLContext |
AbstractSQLParameterRequest.getContext()
Gets this request's SQLContext |
SQLContext |
AbstractParameterRequest.getContext()
Gets this request's SQLContext |
| Methods in planetj.magic with parameters of type SQLContext | |
void |
SQLParameterRequest.loadParameterValues(SQLContext context,
HttpServletRequest request)
Override super execute select inorder to extract proper values. |
static AbstractSQLParameterRequest |
AbstractSQLParameterRequest.create(java.lang.String id,
SQLContext context,
HttpServletRequest request,
HttpServletResponse response)
Convience method to allow creating distinct SQL parameter request objects for different SQL statements. |
void |
AbstractSQLParameterRequest.setContext(SQLContext newContext)
Sets this request's SQLContext |
void |
AbstractParameterRequest.setContext(SQLContext newContext)
Sets this request's SQLContext |
| Constructors in planetj.magic with parameters of type SQLContext | |
SQLParameterRequest(SQLContext context,
HttpServletRequest req,
HttpServletResponse res)
SQLContextRequest constructor |
|
SQLParameterRequest(java.lang.String id,
SQLContext context,
HttpServletRequest req,
HttpServletResponse res)
SQLContextRequest constructor |
|
InsertSQLParameterRequest(java.lang.String id,
SQLContext context,
HttpServletRequest req,
HttpServletResponse res)
InsertSQLParameterRequest constructor comment. |
|
AbstractSQLParameterRequest(SQLContext context,
HttpServletRequest request,
HttpServletResponse response)
Constructor. |
|
AbstractSQLParameterRequest(java.lang.String id,
SQLContext context,
HttpServletRequest request,
HttpServletResponse response)
Deprecated. - id no longer needed |
|
AbstractParameterRequest(SQLContext context,
HttpServletRequest request,
HttpServletResponse response)
Constructor. |
|
AbstractParameterRequest(java.lang.String id,
SQLContext context,
HttpServletRequest request,
HttpServletResponse response)
Constructor. |
|
| Uses of SQLContext in planetj.possiblevalues |
| Methods in planetj.possiblevalues that return SQLContext | |
protected SQLContext |
DistinctPV.getPVContext(Field field)
Gets the SQLContext to use for a PV query |
protected SQLContext |
DistinctCachePV.getPVContext(Field pField)
Gets the SQLContext to use for a PV query |
| Uses of SQLContext in planetj.processes.logon |
| Methods in planetj.processes.logon with parameters of type SQLContext | |
int |
SignOnAndRegistrationRow.insert(SQLContext context)
Overrides to set some predefined default values |
|
|||||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||||