About FROM

101-110 of 200Refresh
Manual
14

DELETE Queries in JPA/JPQL

As explained in chapter 2, entity objects can be deleted from the database by: Retrieving the entity objects into an EntityManager. Removing these objects from the EntityManager within an active ... an alternative way for deleting entity objects. Unlike SELECT queries, which are used to retrieve data from
Manual
14

GROUP BY and HAVING clauses

clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT ... ) that are generated by the FROM clause iteration and pass the WHERE clause filtering (if any) are sent ... .name, 1, 1) FROM Country c GROUP BY SUBSTRING(c.name, 1, 1); The FROM clause defines iteration
Manual
12

Database Schema Evolution

), a conversion is required. If the old type is inconvertible to the new type (for instance a change from ... with a default value (0, false or null). The following type conversions are supported: From any numeric type ... that are stored as numeric ordinal values (the default). From any type to Boolean or boolean (0, null
Manual
12

CRUD Database Operations with JPA [2011-02-11]

objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point ... COUNT(p) FROM Point p") instructs JPA to count all the Point objects in the database. If you have used ... of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
Manual
12

CRUD Database Operations with JPA

objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point ... COUNT(p) FROM Point p") instructs JPA to count all the Point objects in the database. If you have used ... of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
Manual
12

Index Definition

, float, double. Equivalent wrapper classes from package java.lang: Byte, Short, Character, Integer ... execution. Indexes are especially efficient in lookup and range queries: SELECT p FROM Point p WHERE p.x = 100 SELECT p FROM Point p WHERE p.x BETWEEN 50 AND 80 SELECT p FROM Point p WHERE p.x >= 50
Manual
12

JPA Query Structure (JPQL / Criteria)

rather than just field values from database tables, as with SQL. That makes JPQL more object oriented friendly ...  of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ...] The first two clauses, SELECT and FROM are required in every retrieval query
Result
12

ObjectDB Object Database Features [2018-01-27]

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... operating system resources). Unlimited CPUs and cores. Reliability and Stability Recovery from failure by
Result
12

ObjectDB Object Database Features [2018-10-27]

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... operating system resources). Unlimited CPUs and cores. Reliability and Stability Recovery from failure by
Result
12

ObjectDB Object Database Features

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... ). Unlimited CPUs and cores. Reliability and Stability Recovery from failure by using a recovery file