| com.completex.objective.components.persistency.QueryFactory
All known Subclasses: com.completex.objective.components.persistency.core.impl.query.QueryFactoryImpl,
Method Summary | |
Query | newConnectedForwardPageQuery(AbstractPersistentObject singularResultFactory, long pageSize) Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. | Query | newConnectedForwardPageQuery(String sql, long pageSize) Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. | Query | newConnectedForwardPageQuery(long pageSize) Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. | Query | newConnectedForwardPageQuery(Query query, long pageSize) Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. | Query | newDisconnectedPageQuery(AbstractPersistentObject singularResultFactory, long offset, long pageSize) | Query | newDisconnectedPageQuery(String sql, long offset, long pageSize) | Query | newDisconnectedPageQuery(long offset, long pageSize) | Query | newDisconnectedPageQuery(Query query, long offset, long pageSize) | Query | newDisconnectedPageQuery(AbstractPersistentObject singularResultFactory, Page page) | Query | newDisconnectedPageQuery(Query query, Page page) | Query | newDisconnectedPageQuery(Page page) | Query | newDisconnectedPageQuery(String sql, Page page) | Query | newQuery(String sql) | Query | newQuery(PersistentObjectFactory singularResultFactory) | Query | newQueryByCompoundExample(Compound compound) | Query | newQueryByCompoundExample(Compound compound, Compound.ImplicitJoinMode joinMode) Creates new QBE out of compound object. | Query | newQueryByCompoundExample(Compound compound, CompoundColumnFilter filters) | Query | newQueryByCompoundExample(Compound compound, Compound.ImplicitJoinMode joinMode, CompoundColumnFilter filters) | Query | newQueryByExample(PersistentObject persistentObject) | Query | newQueryByExample(PersistentObject persistentObject, CompoundColumnFilter filters) |
newConnectedForwardPageQuery | Query newConnectedForwardPageQuery(AbstractPersistentObject singularResultFactory, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. It keeps cursor/result set open and only closes it either
when there is nothing to retrieve or on transaction commit.
The following snippet shows how to use it:
Query query = persistency.getQueryFactory().newConnectedForwardPageQuery(new Person(), 1000);
List persons;
while ((persons = persistency.select(query).size() > 0 ) {
// Do your processing here
}
Parameters: singularResultFactory - singular result factory Parameters: pageSize - page size new Query instance |
newConnectedForwardPageQuery | Query newConnectedForwardPageQuery(String sql, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. It keeps cursor/result set open and only closes it either
when there is nothing to retrieve or on transaction commit.
The following snippet shows how to use it:
Query query = persistency.getQueryFactory().newConnectedForwardPageQuery("select * from person", 1000);
List persons;
while ((persons = persistency.select(query).size() > 0 ) {
// Do your processing here
}
Parameters: sql - SQL statement Parameters: pageSize - page size new Query instance |
newConnectedForwardPageQuery | Query newConnectedForwardPageQuery(long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. It keeps cursor/result set open and only closes it either
when there is nothing to retrieve or on transaction commit.
The following snippet shows how to use it:
Query query = persistency.getQueryFactory().newConnectedForwardPageQuery(1000);
// query setup
List persons;
while ((persons = persistency.select(query).size() > 0 ) {
// Do your processing here
}
Parameters: pageSize - page size new Query instance |
newConnectedForwardPageQuery | Query newConnectedForwardPageQuery(Query query, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
and does not disconnect from the database. It keeps cursor/result set open and only closes it either
when there is nothing to retrieve or on transaction commit.
The following snippet shows how to use it:
Query nonPaginatedQuery = persistency.getQueryFactory().newQuery(new Person());
// nonPaginatedQuery setup ...
Query query = persistency.getQueryFactory().newConnectedForwardPageQuery(nonPaginatedQuery, 1000);
List persons;
while ((persons = persistency.select(query).size() > 0 ) {
// Do your processing here
}
Parameters: query - non-paginated Query object Parameters: pageSize - page size new Query instance |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(AbstractPersistentObject singularResultFactory, long offset, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: singularResultFactory - singular result factory Parameters: offset - 0-based offset Parameters: pageSize - page size new Query instance |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(String sql, long offset, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: sql - SQL statement Parameters: offset - 0-based offset Parameters: pageSize - page size new Query instance |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(long offset, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: offset - 0-based offset Parameters: pageSize - page size new Query instance |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(Query query, long offset, long pageSize)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: query - query object Parameters: offset - 0-based offset Parameters: pageSize - page size new Query instance |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(AbstractPersistentObject singularResultFactory, Page page)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: singularResultFactory - Parameters: page - Page attributes new Query instance See Also: Page |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(Query query, Page page)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: query - Parameters: page - Page attributes new Query instance See Also: Page |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(Page page)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: page - Page attributes new Query instance See Also: Page |
newDisconnectedPageQuery | Query newDisconnectedPageQuery(String sql, Page page)(Code) | | Creates preset query object which when executed brings only one page of results
Parameters: sql - SQL statement Parameters: page - Page attributes new Query instance |
newQuery | Query newQuery(String sql)(Code) | | Creates preset query object
Parameters: sql - SQL statement new Query instance |
newQuery | Query newQuery(PersistentObjectFactory singularResultFactory)(Code) | | Creates preset query object
Parameters: singularResultFactory - singular result factory new Query instance |
newQueryByCompoundExample | Query newQueryByCompoundExample(Compound compound)(Code) | | Creates preset query object by Compound with set values which are used in where clause
Parameters: compound - Compound with set values new Query instance |
newQueryByCompoundExample | Query newQueryByCompoundExample(Compound compound, Compound.ImplicitJoinMode joinMode)(Code) | | Creates new QBE out of compound object. Entries are joined explicitely in joinMode.
Mode set to compound object initially gets reset.
Parameters: compound - compound object which values are used in SQL condition Parameters: joinMode - Compound.INNER, Compound.OUTER or Compound.NONE new Query |
newQueryByExample | Query newQueryByExample(PersistentObject persistentObject)(Code) | | Creates preset query object by PersistentObject with set values which are used in where clause
Parameters: persistentObject - PersistentObject with set values new Query instance |
|
|