| Package | Description | 
|---|---|
| org.apache.cayenne.query | Defines standard queries supported by Cayenne and extension mechanism to create
custom queries. | 
| Modifier and Type | Method and Description | 
|---|---|
| SQLSelect<T> | SQLSelect. append(String sqlChunk)Appends a piece of SQL to the previously stored SQL template. | 
| SQLSelect<T> | SQLSelect. cacheGroup(String cacheGroup) | 
| SQLSelect<T> | SQLSelect. cacheStrategy(QueryCacheStrategy strategy) | 
| SQLSelect<T> | SQLSelect. cacheStrategy(QueryCacheStrategy strategy,
             String cacheGroup) | 
| SQLSelect<T> | SQLSelect. columnNameCaps(CapsStrategy columnNameCaps)Sets a column name capitalization policy applied to selecting queries. | 
| static SQLSelect<DataRow> | SQLSelect. dataRowQuery(String sql)Creates a query that selects DataRows and uses default routing. | 
| static SQLSelect<DataRow> | SQLSelect. dataRowQuery(String dataMapName,
            String sql)Creates a query that selects DataRows and uses routing based on the
 provided DataMap name. | 
| SQLSelect<T> | SQLSelect. limit(int fetchLimit) | 
| SQLSelect<T> | SQLSelect. localCache()Instructs Cayenne to look for query results in the "local" cache when
 running the query. | 
| SQLSelect<T> | SQLSelect. localCache(String cacheGroup)Instructs Cayenne to look for query results in the "local" cache when
 running the query. | 
| SQLSelect<T> | SQLSelect. lowerColumnNames()Equivalent of setting  CapsStrategy.LOWER | 
| SQLSelect<T> | SQLSelect. offset(int fetchOffset) | 
| SQLSelect<T> | SQLSelect. pageSize(int pageSize) | 
| SQLSelect<T> | SQLSelect. params(Map<String,?> parameters) | 
| SQLSelect<T> | SQLSelect. params(String name,
      Object value) | 
| SQLSelect<T> | SQLSelect. paramsArray(Object... params)Initializes positional parameters of the query. | 
| SQLSelect<T> | SQLSelect. paramsList(List<Object> params)Initializes positional parameters of the query. | 
| static <T> SQLSelect<T> | SQLSelect. query(Class<T> type,
     String sql)Creates a query that selects DataObjects. | 
| static <T> SQLSelect<T> | SQLSelect. scalarQuery(Class<T> type,
           String sql)Creates a query that selects scalar values and uses default routing. | 
| static <T> SQLSelect<T> | SQLSelect. scalarQuery(Class<T> type,
           String dataMapName,
           String sql)Creates a query that selects scalar values and uses routing based on the
 provided DataMap name. | 
| SQLSelect<T> | SQLSelect. sharedCache()Instructs Cayenne to look for query results in the "shared" cache when
 running the query. | 
| SQLSelect<T> | SQLSelect. sharedCache(String cacheGroup)Instructs Cayenne to look for query results in the "shared" cache when
 running the query. | 
| SQLSelect<T> | SQLSelect. statementFetchSize(int size)Sets JDBC statement's fetch size (0 for no default size) | 
| SQLSelect<T> | SQLSelect. upperColumnNames()Equivalent of setting  CapsStrategy.UPPER | 
Copyright © 2001–2023 Apache Cayenne. All rights reserved.