15 | WHERE clause (JPQL / Criteria API) The following query retrieves only countries with a population size above a population size p: SELECT c ... them to the SELECT clause. For example, the following query retrieves all the countries with population size |
15 | UPDATE SET Queries in JPA/JPQL instances of subclasses). For example, the following three equivalent queries increase the population size ... the population size of countries whose population size is smaller than a specified limit: UPDATE |
15 | ObjectDB Object Database Features can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... . Capabilities and Limitations Database file size up to 128 TB (= 131,072 GB = 134,217,728 MB ... OF, SIZE). Java standard methods in queries. User defined methods in queries. Multi User Support |
12 | Database Explorer, a default viewer (a Tree window by default) is opened with the query results, and the size of the result ... the combo boxes on the right side to choose font face, font size, font style, background color |
8 | ORDER BY clause (JPQL / Criteria API)The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY Expressions The following query returns names of countries whose population size |
8 | FROM clause (JPQL / Criteria API), NOT, NULL, NULLIF, OBJECT, OF, OR, ORDER, OUTER, POSITION, SELECT, SET, SIZE, SOME, SQRT, SUBSTRING |
8 | SELECT clause (JPQL / Criteria API), depending on the size of the query result list and other factors. SELECT in Criteria Queries |
8 | DELETE Queries in JPA/JPQL, the following query deletes the countries with population size that is smaller than a specified limit |
1 | [ODB1] Chapter 9 - ObjectDB Explorer is valid, the default viewer (the browser window by default) is opened with the query results and the size ... side to choose font face, font size, font style, background color and foreground color. Click |
0 | javax.jdo.FetchPlan should be unloaded prior to detachment. Since: JDO 2.0 int FETCH_SIZE_GREEDY For use with setFetchSize. For use with setFetchSize. Value: -1. Since: JDO 2.0 int FETCH_SIZE_OPTIMAL For use with setFetchSize ... getFetchSize() Return the fetch size, or FETCH_SIZE_OPTIMAL if not set, or FETCH_SIZE_GREEDY to fetch |
