About page

forum_thread

Date field Index is corrupted due to time change

Hi, can you shed some light on why we cannot delete data from the attached DB file. A delete attempt with DB explorer results in the following exception: ... structure... 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Page Relation Errors -------------------- [1] Page #12592 last key is 2015-10-24 03:00:00|1:71540, parent page #10513 next ...

 
manual

Setting and Tuning of JPA Queries

Explains various JPA query settings - result range, flush and lock.... used to control query execution. See JavaDoc Reference Page... and  TypedQuery javax.persistence.TypedQuery ... the execution of typed queries. See JavaDoc Reference Page... interfaces define various setting and tuning methods that may ...

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... structure is only known at runtime. This page covers the following topics: JPA Criteria API vs JPQL ... predicates, orderings. See JavaDoc Reference Page... cb = em. getCriteriaBuilder getCriteriaBuilder() ...

 
manual

JPA Metamodel API

Explains how to use the JPA Metamodel API to retrieve details on the types and attributes of the persistent object model.... provides for general Java types. This page covers the following topics: The Metamodel Interface ... entities in the persistence unit. See JavaDoc Reference Page... . It can be obtained either by the EntityManagerFactory ...

 
manual

Storing JPA Entity Objects

Explains how to use JPA to store (persist) entity objects in the database.... instance managed and persistent. See JavaDoc Reference Page... method or implicitly as a result of a cascade operation. This page covers the following topics: Explicit Persist ...

 
manual

SELECT clause (JPQL / Criteria API)

Explains how to use the SELECT clause and projections in a JPA/JPQL query.... with the persistence context. See JavaDoc Reference Page... em : TypedQuery javax.persistence.TypedQuery ... the execution of typed queries. See JavaDoc Reference Page... <Country> query = em. createQuery ...

 
manual

Index Definition

Describes how to define indexes in JPA entity classes and explains how indexes are used in JPQL queries.... define with indexes should be done carefully. This page covers the following topics: Single Field Index ... Annotation for a database index. See JavaDoc Reference Page... and @Unique javax.jdo.annotations.Unique JDO ...

 
api-jpa

javax.persistence.criteria.Expression

Type for query expressions.(Interface of JPA)

 
manual

Numbers in JPQL and Criteria Queries

Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries.... into a more complex expression. This page covers the following topics: Arithmetic Operators ... predicates, orderings. See JavaDoc Reference Page... interface provides factory methods for building these ... Type for query expressions. See JavaDoc Reference Page... <Integer> path = country. get get(attributeName) ...

 
manual

Strings in JPQL and Criteria Queries

Explains string expressions in JPQL queries, including LIKE, LOCATE, LOWER, UPPER, TRIM, CONCAT and SUBSTRING.... JPQL string manipulation functions. This page covers the following topics: LIKE - String Pattern ... predicates, orderings. See JavaDoc Reference Page... interface provides factory methods for building these ... Type for query expressions. See JavaDoc Reference Page... <String> path = country. get get(attributeName) ...