61 | alias(name)Method javax.persistence.criteria.Selection Selection<X> alias( String name ) Assigns an alias to the selection item. Once assigned, an alias cannot be changed or reassigned. Returns the same selection item. Parameters: name - alias Returns: selection item Since: JPA 2.0 |
61 | isCompoundSelection()Method javax.persistence.criteria.Selection boolean isCompoundSelection() Whether the selection item is a compound selection. Returns: boolean indicating whether the selection is a compound selection Since: JPA 2.0 |
60 | select(expression)Method javax.persistence.criteria.Subquery Subquery<T> select( Expression<T> expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying the item that is to be returned as |
59 | SharedCacheMode.ENABLE_SELECTIVEEnum Constant javax.persistence.SharedCacheMode ENABLE_SELECTIVE Caching is enabled for all entities for Cacheable(true) is specified. All other entities are not cached. Since: JPA 2.0 |
59 | SharedCacheMode.DISABLE_SELECTIVEEnum Constant javax.persistence.SharedCacheMode DISABLE_SELECTIVE Caching is enabled for all entities except those for which Cacheable(false) is specified. Entities for which Cacheable(false) is specified are not cached. Since: JPA 2.0 |
26 | GROUP BY and HAVING clauses clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT ... to grouping by the GROUP BY clauses before arriving at the SELECT clause. GROUP BY as DISTINCT (no Aggregates) The following query groups all the countries by their first letter: SELECT SUBSTRING(c |
25 | FROM clause (JPQL / Criteria API) over all the Country objects in the database: SELECT c FROM Country AS c The AS keyword is optional, and the same query can also be written as follows: SELECT c FROM Country c By default, the name ... returns all the pairs of countries that share a common border: SELECT c1, c2 FROM Country c1, Country c2 |
25 | ORDER BY clause (JPQL / Criteria API) is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population > 1000000 ... clause produces objects for examination and the WHERE clause selects which objects to collect as results. Then the SELECT clause builds the results by evaluating the result expressions. Finally the results |
25 | Database Explorer Embedded... command and select a local database file. To open a database in client-server mode select File > Open C/S Connection... and provide host, port, username and password for a client-server ... the tree). To open a new viewer window either write a query in the [Query] tabbed window or select |
3 | [ODB1] Chapter 9 - ObjectDB Explorer toolbar button) and in the Open dialog box select the desired local database file and click ... " button that opens the "Remote File Selection" dialog box. Closing the Database Use the "File | Close ... is open. The "Class" window shows all the persistent classes in the database. You can select a class from |
