Internal Website Search

101-110 of 200 resultsRefresh

Failure after ObjectDB 2.4.5_07 upgrade from 2.4.4_06

Failure after ObjectDB 2.4.5_07 upgrade from 2.4.4_06

Catching exceptions from client-server mode online backup

Catching exceptions from client-server mode online backup

ORDER BY clause (JPQL / Criteria API)

the country name: SELECT c.name FROM Country c WHERE c.population > ... the FROM clause produces objects for examination and the WHERE clause selects which objects ... that are derived directly from expressions in the SELECT clause are allowed in the ORDER BY clause

JPA Query Structure (JPQL / Criteria)

objects rather than just field values from database tables, as with SQL. That makes JPQL more object ... class="pre-query"> SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ... /jpa/query/jpql/from">FROM are required in every retrieval query (update and delete queries

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is essential in any JPQL query that retrieves selective objects from the database. Out of the four optional ... -query"> SELECT c FROM Country c WHERE c.population > :p The FROM clause

DELETE Queries in JPA/JPQL

objects can be deleted from the database by: Retrieving the entity objects into an EntityManager. Removing these objects from the EntityManager ... >SELECT queries, which are used to retrieve data from the database, DELETE queries do not

ObjectDB Object Database Features

, grouping queries and aggregate queries) which are usually missing from Object Oriented Databases ... > ObjectDB can manage databases of various sizes efficiently, ranging from kilobytes ... > Recovery from failure by using a 

GROUP BY and HAVING clauses

>The position of a GROUP BY clause in the query execution order is after the FROM and WHERE clauses ... of database objects) that are generated by the FROM clause iteration and pass the WHERE clause ... SUBSTRING(c.name, 1, 1) FROM Country c GROUP BY SUBSTRING(c.name, 1, 1); The FROM

JPA Criteria API Queries

string represents a minimal JPQL query: SELECT c FROM Country ... /criteria/Root">Root<Country> c = q.from_Class_">from(Country.class); q.

[ODB1] Chapter 9 - ObjectDB Explorer

the Explorer. You can also start the Explorer from the command line. For instance ... all the persistent classes in the database. You can select a class from the list of classes at the top ... elements from the auto completion list when you write the query filter