12 | Database Explorer of elements. Use the [First] and [Max] fields to set the result range. Check [Disable Cache] to bypass query program and result caches. Click the Execute button to run the query. If the query is valid, a default viewer (a Tree window by default) is opened with the query results, and the size of the result |
10 | JPA Named Queries dynamically into the query string and results in more efficient queries. @NamedQuery ... are used to instantiate them. The createNamedQuery method receives a query name and a result type ... .findAll", Country.class); List<Country> results = query.getResultList(); Another form |
10 | ObjectDB Object Database Features other JPA solution. General Highly optimized code (as a result of many profiling sessions). Unique data structures and algorithms (as a result of years of R&D). Outperforms competing products ... queries with different arguments). Query result cache (for repeating queries with the same arguments |
10 | JPA Criteria API Queries, the range variable, c, is also used in the SELECT clause as the query result expression ... ); List<Country> results = query.getResultList(); Using the criteria API introduces some extra work ... ); List<Country> results = query.getResultList(); Because eventually both types of queries |
10 | javax.persistence.criteria.Subquery. Warning: may result in a runtime failure. Parameters: type - intended type of the expression Returns ... Subquery<T> distinct(boolean distinct) Specify whether duplicate query results will be eliminated. Specify whether duplicate query results will be eliminated. A true value will cause duplicates |
9 | javax.persistence.TypedQuery and the transaction is rolled back Since: JPA 1.0 int getFirstResult() The position of the first result the query object was set to retrieve. The position of the first result the query object was set to retrieve ... result Since: JPA 2.0 FlushModeType getFlushMode() Get the flush mode in effect for the query execution |
9 | Index Definition WHERE p.x >= 50 AND p.x <= 80 By using an index on field x, ObjectDB can find the results using ... a more efficient range scan can be performed. ObjectDB also uses indexes for sorting results ... field defined in the index the results would already be produced in the requested order (the order |
9 | javax.persistence.criteria.SetJoin interface is the type of the result of joining to a collection over an association or element ... : may result in a runtime failure. Parameters: type - intended type of the expression Returns: new ... : the resulting fetch join Throws: IllegalArgumentException - if attribute of the given name does not |
9 | javax.persistence.criteria.ListJoin interface is the type of the result of joining to a collection over an association or element ... : may result in a runtime failure. Parameters: type - intended type of the expression Returns: new ... : the resulting fetch join Throws: IllegalArgumentException - if attribute of the given name does |
0 | [ODB1] Chapter 9 - ObjectDB Explorer is valid, the default viewer (the browser window by default) is opened with the query results and the size of the result collection and the query execution time are displayed on the query form. If the query ... and displays the results. On the bottom of the query window there are two assistant tab windows |
