Home » Search

About JPQL

21-30 of 133Refresh
Manual
52

JPA Query API

, the same JPQL query which retrieves all the Country objects in the database is represented by both q1 ... because it introduces the Country class to ObjectDB. Dynamic JPQL, Criteria API and Named Queries Building queries by passing JPQL query strings directly to the createQuery method, as shown
Manual
50

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 ... . On the other hand, for many developers string based JPQL queries, which are very similar to SQL
Tutorial
35

Step 4: Create an ObjectDB Data Set

contains Point entity objects. We will use a simple JPQL query that retrieves points with x value in
Result
35

ObjectDB Object Database Features

- JPQL and JDOQL. Query Languages JPQL - Java Persistence (JPA) Query Language - SQL like syntax. JDOQL ... (including INNER JOIN, LEFT OUTER JOIN and JOIN FETCH). WHERE (with both JPQL and JDOQL expressions ... , &&, ||). Arithmetic operators & functions (+, -, *, /, %, ABS, SQRT, MOD). JPQL string operators & functions
Manual
26

Query Parameters in JPA

(:) followed by a valid JPQL identifier that serves as the parameter name. JPA does not provide an API ... , whose form is :name, JPQL supports also ordinal parameter, whose form is ?index. The following method ... is unsafe and can expose the application to JPQL injection attacks. Suppose that the name parameter
Manual
26

CRUD Database Operations with JPA

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point ... SQL you should find the syntax very familiar. JPQL, the JPA query language, supports a SQL like ... objects from the database using JPA. Running a JPQL query is one of them: TypedQuery query
Manual
23

BIRT/ODA ObjectDB Driver

Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query language ... Sets and JPQL To create the data set: Open the [New Data Set] dialog box by right clicking the Data ... (e.g. ObjectDB Points).  Enter a data set name (e.g. Points by X) and click Next. Entry a JPQL or
Manual
23

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 ... side enables execution of JPQL and JDOQL queries. To execute a query: Enter a query string. In the [Parameters
Manual
23

Setting and Tuning of JPA Queries

. "objectdb.query-language" - sets the query language, as one of "JPQL" (JPA query language), "JDOQL ... of JPQL, JDOQL and ObjectDB extensions. Setting "JPQL" is useful to enforce portable JPA code by
Manual
22

Running JPA Queries

Explains how to use JPA to run Java Persistence Query Language (JPQL) queries.