ObjectDB ObjectDB

Internal Website Search

11-20 of 140 resultsRefresh

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ... expressions - in navigation to persistent date and time fields. as results of predefined JPQL current date and time functions. Current Date and Time JPA defines special JPQL expressions

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... enables as an extension to standard JPQL to use both operators (IN and MEMBER OF) with any type ... Expressions JPQL collection operators and functions (which are described above) are available also as JPA

Strings in JPQL and Criteria Queries

String values may appear in JPQL queries in various forms: as string literals - e.g. 'abc', ''. as ... to persistent string fields. as results of predefined JPQL string manipulation functions. LIKE - String ... operator). Criteria Query String Expressions JPQL string operators and functions (which are described

Paths and Types in JPQL and Criteria API

classes) are represented in JPQL by the following types of expressions: Variables - FROM ... . But more often they are used in JPQL path expressions that navigate to values of simple types (number, boolean ... , a NullPointerException is thrown on any attempt to access a field or a method via a null reference. In JPQL

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as parameters - when numeric values are assigned as arguments. as path expressions - in navigation ... of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic


Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity objects into an EntityManager. Updating the relevant entity object fields within an active transaction. Applying changes to the database by calling the commit method. JPQL UPDATE queries provide


. Applying changes to the database by calling the commit method. JPQL DELETE queries provide

JPA Annotations for JPQL Queries

The following annotations are used to define static named JPA queries: The JPA Named Queries section of the ObjectDB Manual explains and demonstrates how to use these annotations to define named JPQL queries.

GROUP BY and HAVING clauses

The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns ... clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects ... which returns the first letters as result. ObjectDB is very flexible in allowing JPQL expressions anywhere in

JPA Criteria API Queries

for building dynamic queries whose exact structure is only known at runtime. JPA Criteria API vs JPQL JPQL queries are defined as strings, similarly to SQL. JPA criteria queries, on the other hand ... rather than at runtime. On the other hand, for many developers string based JPQL queries, which are very similar to SQL

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support