|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.enhydra.shark.instancepersistence.data.ActivityQuery
ActivityQuery is used to query the SHKActivities table in the database.
It returns objects of type ActivityDO.
General usage:
In DODS: Create a Data Object named "Dog", and create an Attribute named "Name", and set that Attribute to "Can be queried." DODS will then generate the method DogQuery.setQueryName().
In your Business Layer, prepare the query:
DogQuery dq = new DogQuery(); dq.setQueryName("Rex") if ( Rex is a reserved name ) dq.requireUniqueInstance();Then, get the query results one of two ways:
#1:
String names = ""; DogDO[] dogs = dq.getDOArray(); for ( int i = 0; i < dogs.length; i++ ) { names += dogs[i].getName() + " "; }or #2:
String names = ""; DogDO dog; while ( null != ( dog = dq.getNextDO() ) ) { names += dog.getName() + " "; }
Note: If requireUniqueInstance()
was called,
then getDOArray()
or getNextDO()
will throw an exception if more than one "Rex" was found.
Note: Results of the query will come from the Data Object cache if:
- The cache is available.
- Matches were found in the cache.
- No other tables (Data Objects of other types) were involved
in the query.
This can happen if you extend the DogQuery
class
and you make calls to the QueryBuilder
object
to add SQL involving other tables.
If any of these conditions is not true,
then any results from the query will come from the database.
To reuse the query object, call:
dq.reset();
Constructor Summary | |
ActivityQuery()
Public constructor. |
|
ActivityQuery(com.lutris.appserver.server.sql.DBTransaction dbTrans)
Public constructor. |
Method Summary | |
void |
addOrderByAccepted()
Add Accepted to the ORDER BY clause. |
void |
addOrderByAccepted(boolean direction_flag)
Add Accepted to the ORDER BY clause. |
void |
addOrderByAcceptedTZO()
Add AcceptedTZO to the ORDER BY clause. |
void |
addOrderByAcceptedTZO(boolean direction_flag)
Add AcceptedTZO to the ORDER BY clause. |
void |
addOrderByActivated()
Add Activated to the ORDER BY clause. |
void |
addOrderByActivated(boolean direction_flag)
Add Activated to the ORDER BY clause. |
void |
addOrderByActivatedTZO()
Add ActivatedTZO to the ORDER BY clause. |
void |
addOrderByActivatedTZO(boolean direction_flag)
Add ActivatedTZO to the ORDER BY clause. |
void |
addOrderByActivityDefinitionId()
Add ActivityDefinitionId to the ORDER BY clause. |
void |
addOrderByActivityDefinitionId(boolean direction_flag)
Add ActivityDefinitionId to the ORDER BY clause. |
void |
addOrderByActivitySetDefinitionId()
Add ActivitySetDefinitionId to the ORDER BY clause. |
void |
addOrderByActivitySetDefinitionId(boolean direction_flag)
Add ActivitySetDefinitionId to the ORDER BY clause. |
void |
addOrderByBlockActivityId()
Add BlockActivityId to the ORDER BY clause. |
void |
addOrderByBlockActivityId(boolean direction_flag)
Add BlockActivityId to the ORDER BY clause. |
void |
addOrderByDescription()
Add Description to the ORDER BY clause. |
void |
addOrderByDescription(boolean direction_flag)
Add Description to the ORDER BY clause. |
void |
addOrderById()
Add Id to the ORDER BY clause. |
void |
addOrderById(boolean direction_flag)
Add Id to the ORDER BY clause. |
void |
addOrderByIsPerformerAsynchronous()
Add IsPerformerAsynchronous to the ORDER BY clause. |
void |
addOrderByIsPerformerAsynchronous(boolean direction_flag)
Add IsPerformerAsynchronous to the ORDER BY clause. |
void |
addOrderByLastStateTime()
Add LastStateTime to the ORDER BY clause. |
void |
addOrderByLastStateTime(boolean direction_flag)
Add LastStateTime to the ORDER BY clause. |
void |
addOrderByLastStateTimeTZO()
Add LastStateTimeTZO to the ORDER BY clause. |
void |
addOrderByLastStateTimeTZO(boolean direction_flag)
Add LastStateTimeTZO to the ORDER BY clause. |
void |
addOrderByLimitTime()
Add LimitTime to the ORDER BY clause. |
void |
addOrderByLimitTime(boolean direction_flag)
Add LimitTime to the ORDER BY clause. |
void |
addOrderByLimitTimeTZO()
Add LimitTimeTZO to the ORDER BY clause. |
void |
addOrderByLimitTimeTZO(boolean direction_flag)
Add LimitTimeTZO to the ORDER BY clause. |
void |
addOrderByName()
Add Name to the ORDER BY clause. |
void |
addOrderByName(boolean direction_flag)
Add Name to the ORDER BY clause. |
void |
addOrderByPDefName()
Add PDefName to the ORDER BY clause. |
void |
addOrderByPDefName(boolean direction_flag)
Add PDefName to the ORDER BY clause. |
void |
addOrderByPerformer()
Add Performer to the ORDER BY clause. |
void |
addOrderByPerformer(boolean direction_flag)
Add Performer to the ORDER BY clause. |
void |
addOrderByPriority()
Add Priority to the ORDER BY clause. |
void |
addOrderByPriority(boolean direction_flag)
Add Priority to the ORDER BY clause. |
void |
addOrderByProcess()
Add Process to the ORDER BY clause. |
void |
addOrderByProcess(boolean direction_flag)
Add Process to the ORDER BY clause. |
void |
addOrderByProcessId()
Add ProcessId to the ORDER BY clause. |
void |
addOrderByProcessId(boolean direction_flag)
Add ProcessId to the ORDER BY clause. |
void |
addOrderByResourceId()
Add ResourceId to the ORDER BY clause. |
void |
addOrderByResourceId(boolean direction_flag)
Add ResourceId to the ORDER BY clause. |
void |
addOrderByState()
Add State to the ORDER BY clause. |
void |
addOrderByState(boolean direction_flag)
Add State to the ORDER BY clause. |
void |
addOrderByTheResource()
Add TheResource to the ORDER BY clause. |
void |
addOrderByTheResource(boolean direction_flag)
Add TheResource to the ORDER BY clause. |
void |
closeParen()
Place a closing parenthesis in the WHERE clause.
|
boolean |
containsWildcards(java.lang.String dbSearchValue)
Check whether a string contains DB wildcards |
java.lang.String |
convertUserSearchValue(java.lang.String userSearchValue)
Convert a String with user wildcards into a string with DB wildcards |
java.sql.ResultSet |
executeQuery(com.lutris.appserver.server.sql.DBConnection conn)
Method to query objects from the database. |
int |
get_FetchSize()
reads the current fetchsize for this query |
int |
get_QueryTimeout()
Reads the current queryTimeout for this query. |
org.enhydra.dods.cache.QueryResult |
getCachedResults(org.enhydra.dods.cache.QueryResult result)
Return QueryResult with read DOs or DataStructs from caches. |
int |
getCount()
Get the rowcount of the query If possible, do it without reading all rows |
int |
getDatabaseLimit()
Get the database limit of the query |
boolean |
getDatabaseLimitExceeded()
Get the database limit exceeded flag of the query. |
ActivityDO[] |
getDOArray()
Return array of DOs constructed from ResultSet returned by query. |
boolean |
getLoadData()
Return true if Query is prepared for select t1.* statement. |
java.lang.String |
getLogicalDatabase()
Return logical name of the database that ActivityQuery object uses |
int |
getMaxRows()
Return limit of rows (DOs) returned. |
ActivityDO |
getNextDO()
Return successive DOs from array built from ResultSet returned by query. |
com.lutris.dods.builder.generator.query.QueryBuilder |
getQueryBuilder()
Returns the QueryBuilder that this ActivityQuery
uses to construct and execute database queries.
|
int |
getReadSkip()
Get the readSkip number of the query |
java.sql.PreparedStatement |
getStatement()
Return java.sql.PreparedStatement from QueryBuilder class |
boolean |
getUnique()
Get the unique flag of the query |
boolean |
getUserStringAppendWildcard()
Get user string append wildcard. |
java.lang.String |
getUserStringSingleWildcard()
Get user string single wildcard. |
java.lang.String |
getUserStringSingleWildcardEscape()
Get user string single wildcard escape. |
boolean |
getUserStringTrim()
Get user string trim. |
java.lang.String |
getUserStringWildcard()
Get user string wildcard. |
java.lang.String |
getUserStringWildcardEscape()
Get user string wildcard escape. |
void |
hitDatabase()
Set that all queries go to database, not to cache. |
boolean |
isOrderRelevant()
Returns attribute orderRelevant. |
java.lang.Object |
next(java.sql.ResultSet rs)
WARNING! |
void |
openParen()
Place an open parenthesis in the WHERE clause.
|
void |
or()
Insert an OR between WHERE clauses.
|
void |
requireUniqueInstance()
Set "unique instance" assertion bit. |
void |
reset()
Reset the query parameters. |
int |
selectCount()
Get the rowcount of the query by using count(*) in the DB |
void |
set_CursorType(int resultSetType,
int resultSetConcurrency)
set the current cursor type - overrides default value from dbVendorConf file. |
void |
set_FetchSize(int iCurrentFetchSizeIn)
Set fetch size for this query |
void |
set_QueryTimeout(int iQueryTimeoutIn)
Sets the current queryTimeout for this query. |
void |
setDatabaseLimit(int newLimit)
Set the database limit of the query |
void |
setDBMatchActivityDefinitionId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchActivitySetDefinitionId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchBlockActivityId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchDescription(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchName(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchPDefName(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchPerformer(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchProcessId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setDBMatchResourceId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setLoadData(boolean newValue)
Set loadData parameter. if parameter is set to true, Query select t.* is performed. |
void |
setLogicalDatabase(java.lang.String dbName)
Change logical database to another logical database (which name is dbName) |
protected void |
setMaxExecuteTime(int maxExeTime)
Sets attribute maxExecuteTime. |
void |
setMaxRows(int maxRows)
Limit the number of rows (DOs) returned. |
void |
setOrderRelevant(boolean newOrderRelevant)
Sets attribute orderRelevant. |
void |
setQueryAccepted(long x)
Set the Accepted to query, with a QueryBuilder comparison operator. |
void |
setQueryAccepted(long x,
java.lang.String cmp_op)
Set the Accepted to query, with a QueryBuilder comparison operator. |
void |
setQueryAcceptedTZO(long x)
Set the AcceptedTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryAcceptedTZO(long x,
java.lang.String cmp_op)
Set the AcceptedTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryActivated(long x)
Set the Activated to query, with a QueryBuilder comparison operator. |
void |
setQueryActivated(long x,
java.lang.String cmp_op)
Set the Activated to query, with a QueryBuilder comparison operator. |
void |
setQueryActivatedTZO(long x)
Set the ActivatedTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryActivatedTZO(long x,
java.lang.String cmp_op)
Set the ActivatedTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryActivityDefinitionId(java.lang.String x)
Set the ActivityDefinitionId to query, with a QueryBuilder comparison operator. |
void |
setQueryActivityDefinitionId(java.lang.String x,
java.lang.String cmp_op)
Set the ActivityDefinitionId to query, with a QueryBuilder comparison operator. |
void |
setQueryActivitySetDefinitionId(java.lang.String x)
Set the ActivitySetDefinitionId to query, with a QueryBuilder comparison operator. |
void |
setQueryActivitySetDefinitionId(java.lang.String x,
java.lang.String cmp_op)
Set the ActivitySetDefinitionId to query, with a QueryBuilder comparison operator. |
void |
setQueryBlockActivityId(java.lang.String x)
Set the BlockActivityId to query, with a QueryBuilder comparison operator. |
void |
setQueryBlockActivityId(java.lang.String x,
java.lang.String cmp_op)
Set the BlockActivityId to query, with a QueryBuilder comparison operator. |
void |
setQueryDescription(java.lang.String x)
Set the Description to query, with a QueryBuilder comparison operator. |
void |
setQueryDescription(java.lang.String x,
java.lang.String cmp_op)
Set the Description to query, with a QueryBuilder comparison operator. |
void |
setQueryHandle(java.lang.String handle)
Set the object handle to query. |
void |
setQueryId(java.lang.String x)
Set the Id to query, with a QueryBuilder comparison operator. |
void |
setQueryId(java.lang.String x,
java.lang.String cmp_op)
Set the Id to query, with a QueryBuilder comparison operator. |
void |
setQueryIsPerformerAsynchronous(boolean x)
Set the IsPerformerAsynchronous to query, with a QueryBuilder comparison operator. |
void |
setQueryIsPerformerAsynchronous(boolean x,
java.lang.String cmp_op)
Set the IsPerformerAsynchronous to query, with a QueryBuilder comparison operator. |
void |
setQueryLastStateTime(long x)
Set the LastStateTime to query, with a QueryBuilder comparison operator. |
void |
setQueryLastStateTime(long x,
java.lang.String cmp_op)
Set the LastStateTime to query, with a QueryBuilder comparison operator. |
void |
setQueryLastStateTimeTZO(long x)
Set the LastStateTimeTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryLastStateTimeTZO(long x,
java.lang.String cmp_op)
Set the LastStateTimeTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryLimitTime(long x)
Set the LimitTime to query, with a QueryBuilder comparison operator. |
void |
setQueryLimitTime(long x,
java.lang.String cmp_op)
Set the LimitTime to query, with a QueryBuilder comparison operator. |
void |
setQueryLimitTimeTZO(long x)
Set the LimitTimeTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryLimitTimeTZO(long x,
java.lang.String cmp_op)
Set the LimitTimeTZO to query, with a QueryBuilder comparison operator. |
void |
setQueryName(java.lang.String x)
Set the Name to query, with a QueryBuilder comparison operator. |
void |
setQueryName(java.lang.String x,
java.lang.String cmp_op)
Set the Name to query, with a QueryBuilder comparison operator. |
void |
setQueryOId(com.lutris.appserver.server.sql.ObjectId oid)
Set the OID to query. |
void |
setQueryPDefName(java.lang.String x)
Set the PDefName to query, with a QueryBuilder comparison operator. |
void |
setQueryPDefName(java.lang.String x,
java.lang.String cmp_op)
Set the PDefName to query, with a QueryBuilder comparison operator. |
void |
setQueryPerformer(java.lang.String x)
Set the Performer to query, with a QueryBuilder comparison operator. |
void |
setQueryPerformer(java.lang.String x,
java.lang.String cmp_op)
Set the Performer to query, with a QueryBuilder comparison operator. |
void |
setQueryPriority(short x)
Set the Priority to query, with a QueryBuilder comparison operator. |
void |
setQueryPriority(short x,
java.lang.String cmp_op)
Set the Priority to query, with a QueryBuilder comparison operator. |
void |
setQueryProcess(ProcessDO x)
Set the Process to query, with a QueryBuilder comparison operator. |
void |
setQueryProcess(ProcessDO x,
java.lang.String cmp_op)
Set the Process to query, with a QueryBuilder comparison operator. |
void |
setQueryProcessId(java.lang.String x)
Set the ProcessId to query, with a QueryBuilder comparison operator. |
void |
setQueryProcessId(java.lang.String x,
java.lang.String cmp_op)
Set the ProcessId to query, with a QueryBuilder comparison operator. |
void |
setQueryResourceId(java.lang.String x)
Set the ResourceId to query, with a QueryBuilder comparison operator. |
void |
setQueryResourceId(java.lang.String x,
java.lang.String cmp_op)
Set the ResourceId to query, with a QueryBuilder comparison operator. |
void |
setQueryState(ActivityStateDO x)
Set the State to query, with a QueryBuilder comparison operator. |
void |
setQueryState(ActivityStateDO x,
java.lang.String cmp_op)
Set the State to query, with a QueryBuilder comparison operator. |
void |
setQueryTheResource(ResourceDO x)
Set the TheResource to query, with a QueryBuilder comparison operator. |
void |
setQueryTheResource(ResourceDO x,
java.lang.String cmp_op)
Set the TheResource to query, with a QueryBuilder comparison operator. |
protected void |
setQueryTimeLimit(int qTimeLimit)
Sets attribute QueryTimeLimit. |
void |
setReadSkip(int newReadSkip)
Set the readSkip number of the query |
void |
setUnique(boolean newUnique)
Set the unique flag of the query |
void |
setUserMatchActivityDefinitionId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchActivitySetDefinitionId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchBlockActivityId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchDescription(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchName(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchPDefName(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchPerformer(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchProcessId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserMatchResourceId(java.lang.String x)
Deprecated. Use comparison operators instead WebDocWf extension |
void |
setUserStringAppendWildcard(boolean userStringAppendWildcard)
Set user string append wildcard. |
void |
setUserStringSingleWildcard(java.lang.String newUserStringSingleWildcard)
Set user string single wildcard. |
void |
setUserStringSingleWildcardEscape(java.lang.String newUserStringSingleWildcardEscape)
Set user string single wildcard escape. |
void |
setUserStringTrim(boolean userStringTrim)
Set user string trim. |
void |
setUserStringWildcard(java.lang.String newUserStringWildcard)
Set user string wildcard. |
void |
setUserStringWildcardEscape(java.lang.String newUserStringWildcardEscape)
Set user string wildcard escape. |
void |
writeXML(java.io.Writer ow)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public ActivityQuery()
public ActivityQuery(com.lutris.appserver.server.sql.DBTransaction dbTrans)
dbTrans
- current database transactionMethod Detail |
public java.lang.String getLogicalDatabase()
public java.sql.PreparedStatement getStatement()
getStatement
in interface com.lutris.appserver.server.sql.ExtendedQuery
public void setLogicalDatabase(java.lang.String dbName) throws java.sql.SQLException, com.lutris.appserver.server.sql.DatabaseManagerException
dbName
- the logical name of the database
java.sql.SQLException
com.lutris.appserver.server.sql.DatabaseManagerException
public void setUnique(boolean newUnique)
newUnique
- The unique flag for the query
WebDocWf extensionpublic boolean getUnique()
public void setReadSkip(int newReadSkip)
newReadSkip
- The number of results to skip.
WebDocWf extensionpublic int getReadSkip()
public void setDatabaseLimit(int newLimit)
newLimit
- The limit for the query
WebDocWf extensionpublic int getDatabaseLimit()
public boolean getDatabaseLimitExceeded()
public void hitDatabase()
public void setUserStringWildcard(java.lang.String newUserStringWildcard)
newUserStringWildcard
- New user string wildcard.
WebDocWf extensionpublic void setUserStringSingleWildcard(java.lang.String newUserStringSingleWildcard)
newUserStringSingleWildcard
- New user string single wildcard.
WebDocWf extensionpublic void setUserStringSingleWildcardEscape(java.lang.String newUserStringSingleWildcardEscape)
newUserStringSingleWildcardEscape
- New user string single wildcard escape.
WebDocWf extensionpublic void setUserStringWildcardEscape(java.lang.String newUserStringWildcardEscape)
newUserStringWildcardEscape
- New user string wildcard escape.
WebDocWf extensionpublic void setUserStringAppendWildcard(boolean userStringAppendWildcard)
userStringAppendWildcard
- New user string append wildcard.
WebDocWf extensionpublic void setUserStringTrim(boolean userStringTrim)
userStringTrim
- New user string trim.
WebDocWf extensionpublic java.lang.String getUserStringWildcard()
public java.lang.String getUserStringSingleWildcard()
public java.lang.String getUserStringSingleWildcardEscape()
public java.lang.String getUserStringWildcardEscape()
public boolean getUserStringAppendWildcard()
public boolean getUserStringTrim()
public void setMaxRows(int maxRows) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.NonUniqueQueryException
maxRows
- Max number of rows (DOs) returned.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.NonUniqueQueryException
- If too many rows were found.public int getMaxRows()
public boolean isOrderRelevant()
public void setOrderRelevant(boolean newOrderRelevant)
newOrderRelevant
- new value of attribute orderRelavant.protected void setQueryTimeLimit(int qTimeLimit)
qTimeLimit
- new value of attribute QueryTimeLimit.protected void setMaxExecuteTime(int maxExeTime)
maxExeTime
- new value of attribute maxExecuteTime.public org.enhydra.dods.cache.QueryResult getCachedResults(org.enhydra.dods.cache.QueryResult result) throws com.lutris.dods.builder.generator.query.DataObjectException
result
- QueryResult object with result oids.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.public void writeXML(java.io.Writer ow) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.NonUniqueQueryException
com.lutris.dods.builder.generator.query.DataObjectException
com.lutris.dods.builder.generator.query.NonUniqueQueryException
public ActivityDO[] getDOArray() throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.NonUniqueQueryException
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.NonUniqueQueryException
- If too many rows were found.public ActivityDO getNextDO() throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.NonUniqueQueryException
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.NonUniqueQueryException
- If too many rows were found.public void setQueryOId(com.lutris.appserver.server.sql.ObjectId oid)
SHKActivities
has a column named "oid"
.
This method is called from the DO classes to retrieve an object by id.
oid
- The object id to query.public void setQueryHandle(java.lang.String handle) throws com.lutris.appserver.server.sql.ObjectIdException
handle
- The string version of the id to query.
com.lutris.appserver.server.sql.ObjectIdException
public void requireUniqueInstance()
public void setLoadData(boolean newValue)
newValue
- boolean (true/false)public boolean getLoadData()
public void reset()
public java.sql.ResultSet executeQuery(com.lutris.appserver.server.sql.DBConnection conn) throws java.sql.SQLException
executeQuery
in interface com.lutris.appserver.server.sql.Query
conn
- Handle to database connection.
java.sql.SQLException
- If a database access error occurs.public java.lang.Object next(java.sql.ResultSet rs) throws java.sql.SQLException, com.lutris.appserver.server.sql.ObjectIdException
next
in interface com.lutris.appserver.server.sql.Query
rs
- JDBC result set from which the next object
will be instantiated.
java.sql.SQLException
- If a database access error occurs.
com.lutris.appserver.server.sql.ObjectIdException
- If an invalid object id was queried from the database.public java.lang.String convertUserSearchValue(java.lang.String userSearchValue)
userSearchValue
- The string with user wildcards
public boolean containsWildcards(java.lang.String dbSearchValue)
dbSearchValue
- The string with possible DB wildcards
public int getCount() throws com.lutris.dods.builder.generator.query.NonUniqueQueryException, com.lutris.dods.builder.generator.query.DataObjectException, java.sql.SQLException, com.lutris.appserver.server.sql.DatabaseManagerException
com.lutris.dods.builder.generator.query.NonUniqueQueryException
com.lutris.dods.builder.generator.query.DataObjectException
java.sql.SQLException
com.lutris.appserver.server.sql.DatabaseManagerException
- WebDocWf extensionpublic void set_CursorType(int resultSetType, int resultSetConcurrency)
resultSetType
- a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.resultSetConcurrency
- a concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
public void set_FetchSize(int iCurrentFetchSizeIn)
iCurrentFetchSizeIn
- Query fetch size.public int get_FetchSize()
public int get_QueryTimeout()
public void set_QueryTimeout(int iQueryTimeoutIn)
iQueryTimeoutIn
- current queryTimeout.public int selectCount() throws java.sql.SQLException, com.lutris.appserver.server.sql.DatabaseManagerException
java.sql.SQLException
com.lutris.appserver.server.sql.DatabaseManagerException
- WebDocWf extensionpublic void setQueryId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Id of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Id of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderById(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderById()
public void setUserMatchId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Id of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Id of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryActivitySetDefinitionId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivitySetDefinitionId of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryActivitySetDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivitySetDefinitionId of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByActivitySetDefinitionId(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByActivitySetDefinitionId()
public void setUserMatchActivitySetDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivitySetDefinitionId of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchActivitySetDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivitySetDefinitionId of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryActivityDefinitionId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivityDefinitionId of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryActivityDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivityDefinitionId of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByActivityDefinitionId(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByActivityDefinitionId()
public void setUserMatchActivityDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivityDefinitionId of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchActivityDefinitionId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivityDefinitionId of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryProcess(ProcessDO x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Process of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryProcess(ProcessDO x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Process of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByProcess(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByProcess()
public void setQueryTheResource(ResourceDO x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The TheResource of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryTheResource(ResourceDO x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The TheResource of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByTheResource(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByTheResource()
public void setQueryPDefName(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The PDefName of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryPDefName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The PDefName of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByPDefName(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByPDefName()
public void setUserMatchPDefName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The PDefName of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchPDefName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The PDefName of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryProcessId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ProcessId of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryProcessId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ProcessId of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByProcessId(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByProcessId()
public void setUserMatchProcessId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ProcessId of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchProcessId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ProcessId of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryResourceId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ResourceId of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryResourceId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ResourceId of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByResourceId(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByResourceId()
public void setUserMatchResourceId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ResourceId of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchResourceId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ResourceId of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryState(ActivityStateDO x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The State of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryState(ActivityStateDO x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The State of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByState(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByState()
public void setQueryBlockActivityId(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The BlockActivityId of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryBlockActivityId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The BlockActivityId of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByBlockActivityId(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByBlockActivityId()
public void setUserMatchBlockActivityId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The BlockActivityId of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchBlockActivityId(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The BlockActivityId of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryPerformer(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Performer of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryPerformer(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Performer of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByPerformer(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByPerformer()
public void setUserMatchPerformer(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Performer of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchPerformer(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Performer of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryIsPerformerAsynchronous(boolean x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The IsPerformerAsynchronous of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryIsPerformerAsynchronous(boolean x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The IsPerformerAsynchronous of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByIsPerformerAsynchronous(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByIsPerformerAsynchronous()
public void setQueryPriority(short x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Priority of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryPriority(short x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Priority of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByPriority(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByPriority()
public void setQueryName(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Name of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Name of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByName(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByName()
public void setUserMatchName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Name of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchName(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Name of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setQueryActivated(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Activated of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryActivated(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Activated of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByActivated(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByActivated()
public void setQueryActivatedTZO(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivatedTZO of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryActivatedTZO(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The ActivatedTZO of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByActivatedTZO(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByActivatedTZO()
public void setQueryAccepted(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Accepted of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryAccepted(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Accepted of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByAccepted(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByAccepted()
public void setQueryAcceptedTZO(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The AcceptedTZO of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryAcceptedTZO(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The AcceptedTZO of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByAcceptedTZO(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByAcceptedTZO()
public void setQueryLastStateTime(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LastStateTime of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryLastStateTime(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LastStateTime of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByLastStateTime(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByLastStateTime()
public void setQueryLastStateTimeTZO(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LastStateTimeTZO of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryLastStateTimeTZO(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LastStateTimeTZO of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByLastStateTimeTZO(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByLastStateTimeTZO()
public void setQueryLimitTime(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LimitTime of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryLimitTime(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LimitTime of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByLimitTime(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByLimitTime()
public void setQueryLimitTimeTZO(long x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LimitTimeTZO of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryLimitTimeTZO(long x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The LimitTimeTZO of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByLimitTimeTZO(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByLimitTimeTZO()
public void setQueryDescription(java.lang.String x, java.lang.String cmp_op) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Description of the SHKActivities to query.cmp_op
- QueryBuilder comparison operator to use.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void setQueryDescription(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Description of the SHKActivities to query.
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If comparison operator is inappropriate
(e.g. CASE_SENSITIVE_CONTAINS on an integer field).public void addOrderByDescription(boolean direction_flag)
direction_flag
- True for ascending order, false for descendingpublic void addOrderByDescription()
public void setUserMatchDescription(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Description of the SHKActivities to query with user wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public void setDBMatchDescription(java.lang.String x) throws com.lutris.dods.builder.generator.query.DataObjectException, com.lutris.dods.builder.generator.query.QueryException
x
- The Description of the SHKActivities to query with DB wildcards
com.lutris.dods.builder.generator.query.DataObjectException
- If a database access error occurs.
com.lutris.dods.builder.generator.query.QueryException
- If a query error occurs.public com.lutris.dods.builder.generator.query.QueryBuilder getQueryBuilder()
QueryBuilder
that this ActivityQuery
uses to construct and execute database queries.
ActivityQuery.setQueryXXX
methods use
the QueryBuilder
to
append SQL expressions to the "WHERE"
clause to be executed.
The QueryBuilder.addEndClause method.
can be used to
append freeform SQL expressions to the WHERE
clause,
e.g. "ORDER BY name".
Notes regarding cache-enabled DO classes:
DO classes can be cache-enabled.
If when using a ActivityQuery
, the application developer
does not call getQueryBuilder
,
then ActivityQuery.setQueryXXX
methods
simply prune the DO cache and return the remaining results.
However, a QueryBuilder
builds
SELECT
statements for execution by the actual database,
and never searches the built-in cache for the DO.
So, if the DO class is cache-enabled, and getQueryBuilder
is called, this ActivityQuery
object ignores the cache
and hits the actual database.
public void or()
OR
between WHERE
clauses.
Example: find all the persons named Bob or Robert:
PersonQuery pq = new PersonQuery();
pq.setQueryFirstName( "Bob" );
pq.or();
pq.setQueryFirstName( "Robert" );
Note: Calls to setQueryXxx
methods
are implicitly AND
ed together,
so the following example will always return nothing:
PersonQuery pq = new PersonQuery();
pq.setQueryFirstName( "Bob" );
// AND automatically inserted here.
pq.setQueryFirstName( "Robert" );
NOTE: The DO cache does not yet support the OR operator.
Using the or() method forces the query to hit the database.
QueryBuilder to construct more elaborate queries.
author Jay Gunter
public void openParen()
WHERE
clause.
Example usage: find all the Bobs and Roberts who are 5 or 50 years old:
PersonQuery pq = new PersonQuery();
pq.openParen();
pq.setQueryFirstName( "Bob" );
pq.or();
pq.setQueryFirstName( "Robert" );
pq.closeParen();
// AND automatically inserted here.
pq.openParen();
pq.setQueryAge( 5 );
pq.or();
pq.setQueryAge( 50 );
pq.closeParen();
NOTE: The DO cache does not yet support the Open Paren operator.
Using the openParen() method forces the query to hit the database.
QueryBuilder to construct more elaborate queries.
author Jay Gunter
public void closeParen()
WHERE
clause.
NOTE: The DO cache does not yet support the Close Paren operator.
Using the closeParen() method forces the query to hit the database.
openParen
author Jay Gunter
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |