About query

141-150 of 200Refresh
Result
27

ObjectDB Object Database Features [2018-01-27]

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ...  (per EntityManagerFactory). Database file page cache. Query program cache (for repeating queries with different arguments). Query result cache (for repeating queries with the same arguments). Many
Manual
25

GROUP BY and HAVING clauses

The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns ... clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects
Manual
24

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

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); The query string ("SELECT
Manual
24

CRUD Database Operations with JPA

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); The query string ("SELECT
Manual
24

Database Explorer [2011-09-21]

to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases ... ) in the database and their persistent fields and indexes. The [Query] window enables running JPQL and JDOQL queries, as discussed below. Closing a Database Connection Use the File > Close menu command
Manual
24

Database Explorer

to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases ... ) in the database and their persistent fields and indexes. The [Query] window enables running JPQL and JDOQL queries, as discussed below. Closing a Database Connection Use the File > Close menu command
Manual
23

WHERE clause (JPQL / Criteria API)

JPQL query that retrieves selective objects from the database. Out of the four optional clauses of JPQL queries, the WHERE clause is definitely the most frequently used. How a WHERE Clause Works The following query retrieves only countries with population size that exceeds a specified limit
Forum
22

Query problem after transaction commit

to it. The client program can connect to the server and query to get all the records. However, after transaction ... > Test_Connection: connected 03> UI: start query [query for all object Goods successfully] 04> SELECT u FROM Goods u where u._code like :code AND u._desc like :desc  05> code= %, desc= % 06> UI: end query
Issue
22

queries under 2.7.6_4 significantly slower than under 2.7.6

indicating deep query plan checks and an overall significant performance loss in all queries ... that could possibly effect query execution. Could you please explain or post some of these logs that show deep query plan checks (and are new in 2.7.6_04)? In addition, if you can identify the exact build in
Forum
22

IN expression in a Criteria Query

, it is written that ObjectDB is 100% compatible with JPA. However, I have problem with this JPQL query ... .employeeEntity = e) ORDER BY e.name with Hibernate, there was no problem with this query, but ObjectDB throws exception: com.objectdb.o.UserException: Unexpected query token 'EXISTS' Second problem