Uses of Class
planetj.database.SQLContext

Packages that use SQLContext

planetj.database
planetj.database.connection
planetj.database.fielddescriptors
planetj.database.sql
planetj.dataengine
planetj.dataengine.application
planetj.dataengine.cache
planetj.dataengine.operation
planetj.dataengine.parameter
planetj.dataengine.sqloperation.http
planetj.html
planetj.magic
planetj.processes.logon

Uses of SQLContext in planetj.database

Subclasses of SQLContext in planetj.database

class

AssociationContext Deprecated. - no longer used - old way of getting associations

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.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(Connection newConnection) Sets the connection for this SQLContext.
SQLContext	SQLContext.setFirstRowIndex(int newFirstRow) Insert the method's description here.
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(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(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(String newSQL) Sets the sql statement for this query.
SQLContext	SQLContext.setSQL(String newSQL, boolean shadowize) Sets the sql statement for this query.
SQLContext	SQLContext.setSystemAlias(String pAlias) Sets the system alias for the SQL operation.
SQLContext	SQLContext.setTables(List pTables) Deprecated. Pass in a TableCollection instead
SQLContext	SQLContext.setTables(TableCollection pTables) Sets the tables to this query.
SQLContext	SQLContext.setTitle(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.
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, List fds) Creates this table in the database specified in the SQLContext.
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.
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.
int	Row.insert(SQLContext context) Inserts this Row into the specified database.
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.
static void	DataEngine.execute(SQLContext context) Executes an SQL statement, based on a SQLContext.
static 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.
static String	DataEngine.fixSQLMetadataLibrary(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.

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.

Uses of SQLContext in planetj.database.fielddescriptors

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.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(String sql, SQLContext context)

Constructors in planetj.database.sql with parameters of type SQLContext

UpdateStatement(String pSQLString, SQLContext context)
SelectStatement constructor comment.

SQLStatement(String pOriginalSQLString, SQLContext context)
SQLStatement constructor comment.

SelectStatement(String pSQLString, SQLContext context)
SelectStatement constructor comment.

InsertStatement(String sql, SQLContext context)
Constructor.

DeleteStatement(String pSQLString, SQLContext context)
SelectStatement constructor comment.

CreateAliasStatement(String pOriginalSQLString, SQLContext context)
CreateAliasStatement constructor comment.

CallStatement(String pOriginalSQLString, SQLContext context)
CallStatement constructor comment.

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 View

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

RowCollection	DataEngineCache.getCachedRowCollection(SQLContext context) Allow Cached RowCollections to decide if they can be used for a query.
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 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.sqloperation.http

Methods in planetj.dataengine.sqloperation.http with parameters of type SQLContext

Row	HttpOperationManager.getInsertRow(SQLContext context, DataEngineServlet servlet, javax.servlet.http.HttpServletRequest request) Prepares the given Operation to be inserted.

Uses of SQLContext in planetj.html

Methods in planetj.html with parameters of type SQLContext

void	HTMLComparisonInput.clearValues(SQLContext context, javax.servlet.http.HttpServletRequest request) Deprecated. This method affects all display parameters in the context - not just the ones that are part of a specific HTMLComparison
String	HTMLComparisonInput.generateInput(SQLContext context, int expressionIndex, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) Generates input fields for all parameters in the SQLStatement contained in the SQLContext.
static 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, javax.servlet.http.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, javax.servlet.http.HttpServletRequest request) Override super execute select inorder to extract proper values.
static AbstractSQLParameterRequest	AbstractSQLParameterRequest.create(String id, SQLContext context, javax.servlet.http.HttpServletRequest request, javax.servlet.http.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(String id, SQLContext context, javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res)
SQLContextRequest constructor

InsertSQLParameterRequest(String id, SQLContext context, javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res)
InsertSQLParameterRequest constructor comment.

AbstractSQLParameterRequest(String id, SQLContext context, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
Constructor.

AbstractParameterRequest(String id, SQLContext context, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
Constructor.

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