Internal Website Search
1-50 of 143 resultsLiterals in JPQL and Criteria Queries Literals in JPQL , as in Java, represent constant values. JPQL supports various types of literals ... ). JPQL literals should be used sparingly as queries that use parameters instead of literals ... parameter values. Literals should only be embedded in JPQL queries when a single constant value | |
JPA Query Structure (JPQL / Criteria) The syntax of the Java Persistence Query Language ( JPQL ) is very similar to the syntax of SQL ... language and many developers are already familiar with it. The main difference between SQL and JPQL is that SQL works with relational database tables, records and fields, whereas JPQL works with Java | |
FROM clause (JPQL / Criteria API) are always polymorphic. JPQL does not provide a way to exclude descendant classes from iteration ... of an entity class in a JPQL query is the unqualified name of the class (e.g. just Country with no package ... variables represent iteration over all the database objects of a specified entity type. JPQL provides | |
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 ... might be very large even if the database is small, making indexes even more essential. JPQL | |
SELECT clause (JPQL / Criteria API) The ability to retrieve managed entity objects is a major advantage of JPQL . For example ... the ability to use almost any valid JPQL expression in SELECT clauses. Specifying the required query ... code needed. Notice that query results must always be specified explicitly - JPQL does not support | |
Chapter 4 - JPA Queries (JPQL / Criteria) The JPA Query Language ( JPQL ) can be considered as an object oriented version of SQL. Users familiar with SQL should find JPQL very easy to learn and use. This chapter explains how to use JPQL as ... , based on JPQL . The first section describes the API that JPA provides for using dynamic and static | |
JPA Query Expressions (JPQL / Criteria) Query expressions are the foundations on which JPQL and criteria queries are built. Every query ... of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists | |
Comparison in JPQL and Criteria API Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison Operators ... - JPQL / SQL Set 2 - Java / JDO Less Than Less Than or Equal To = Equal = == Not Equal != The two sets differ in the Equal and the Not Equal operators. JPQL follows the SQL notation, where Java uses | |
Logical Operators in JPQL and Criteria API Logical operators in JPQL and in JPA criteria queries enable composition of complex JPQL boolean expressions out of simple JPQL boolean expressions. Logical Operators ObjectDB supports 2 sets of logical operators, as shown in the following table: Set 1 - JPQL / SQL Set 2 - Java / JDO AND && OR | |
ORDER BY clause (JPQL / Criteria API) The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not ... Country c WHERE c.population 1000000 ORDER BY c.population When using ObjectDB, any JPQL expression ... expressions are supported by all the JPA implementations but support for other JPQL expressions is vendor | |
Strings in JPQL and Criteria Queries String values may appear in JPQL queries in various forms: as string literals - e.g. 'abc ... navigation to persistent string fields. as results of predefined JPQL string manipulation functions ... expressions (which are more powerful than the LIKE operator). Criteria Query String Expressions JPQL | |
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-31'} , {t '23:59:59'} . as parameters - when date and time values are assigned as arguments. as ... 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 ... that doesn't contain 'English' . ObjectDB enables as an extension to standard JPQL to use ... are treated as synonyms. Criteria Query Collection Expressions JPQL collection operators and functions | |
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 ... reference. In JPQL , the current FROM variable (or FROM tuple when there are multiple variables | |
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 ... . Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described | |
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. | |
DELETE Queries in JPA/JPQL by a cascading operation. Applying changes to the database by calling the commit method. JPQL | |
UPDATE SET Queries in JPA/JPQL 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 | |
JPA Criteria API Queries 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 queries, are easier to use and understand. For simple static queries - string based JPQL | |
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 Queries these interfaces to build and run JPQL queries. The TypedQuery interface (or alternatively the older Query interface) is the only neccessary interface for defining and running string based JPQL queries  ... ) can be done by concatenating JPQL strings into a valid complete JPQL query. JPA 2 introduced the JPA Criteria | |
JPA Query API. createQuery ("SELECT c FROM Country c", Country.class); In the above code, the same JPQL query ... variant is valid 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 | |
Query Parameters in JPA identified in a query string by their special form, which is a colon (:) followed by a valid JPQL ... ). Ordinal Parameters (?index) In addition to named parameters, whose form is :name , JPQL ... , embedding strings in queries is unsafe and can expose the application to JPQL injection attacks. Suppose | |
Setting and Tuning of JPA Queries.query-language" - sets the query language, as one of " JPQL " (JPA query language), "JDOQL" (JDO query language) or "ODBQL" (ObjectDB query language). The default is ODBQL, which is a union of JPQL , JDOQL and ObjectDB extensions. Setting " JPQL " is useful to enforce portable JPA code by ObjectDB | |
BIRT/ODA ObjectDB Driver and Reporting Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query ... of the ObjectDB data source. Data Sets and JPQL To create the data set: Open the [New Data Set] dialog box ... ) and click Next . Entry a JPQL or a JDOQL query and click Finish . See the Report | |
ObjectDB Object Database Features Support ObjectDB supports two object-oriented query languages - JPQL and JDOQL . Query Languages JPQL ... JOIN and JOIN FETCH ). WHERE (with both JPQL and JDOQL expressions). GROUP BY (including HAVING | |
Database Explorer to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases ... running JPQL and JDOQL queries, as discussed below. Closing a Database Connection Use the File Close ... ] window on the left side enables execution of JPQL and JDOQL queries. To execute a query: Enter | |
Modifying something with Explorer -> app JPQL with Enum doesn't work anymore. The problem is that redeploying the application after that kind of usage of Explorer makes JPQL with Enum ... is that redeploying the application after that kind of usage of Explorer makes JPQL with Enum to don't work ... application. What happens when you run that JPQL query in the Explorer? In another Explorer? Try to bring | |
JPQL JOIN FETCH Error Hello I get an error when executing the following JPQL query: select doi from Doi doi left join ... with Oracle / MySQL / Postgres, so I'm assuming the JPQL is valid. Any ideas? Thanks John johnbrush John Brush The query is not a valid JPQL query since JOIN FETCH should be followed by a path | |
JPQL IN Operator How can I use the standard JPQL IN operator with ObjectDB? This JPQL query works fine with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId == in = :earliest and dv.creationtime = :earliest"   | |
Possible issue for JPQL "LEFT [OUTER] JOIN" Possible issue for JPQL "LEFT [OUTER] JOIN" is doing "[INNER] JOIN". Thanks. eurojet P. F. Martinez Thank you for this report. Please try build 2.3.7_18 that should fix this issue. support Support Great and fast solution but it doesn't work with the following JPQL queries string:   | |
Delete object from collection versus delete from JPQL and use persist() to write them to the database. But does running a JPQL update or delete alter the in-memory objects? There are cases where the JPQL syntax is more expressive than operating | |
JPA JPQL WHERE clause for IN :variable not working if variable is a list of Enums Hi, I have a case where I have a JPQL query like: "select o from MyEntity o WHERE (enumField IN :enumFieldList)" And enum field is defined in MyEntity as: @Enumerated ... understood the JPA JPQL IN clause should work with Enum types - is that the case, or is this an objectdb | |
Show Sql/Jpql Is there a way to show the executed Sql/ Jpql in the console? wua Andreas Wurm You can set the log element in ObjectDB configuration to write logging also to the console:   ... / Jpql style not xml. I can only see select statements, but I also want to see insert, update | |
JPQL keyword in entity - what to do? Hi, I have a problem with entity that is using one of JPQL keywords as one of the fields. It's a 'type' field. When I try to build a query that looks for example like this: select new ResultData(p ... to use JPQL keywords as field names. Please try build 2.1.0_01 that should fix it. support Support I did | |
member visiting in jpql gzdillon Lai Yang The length field of arrays is not supported by JDOQL / JPQL queries. You may maintain | |
Retrieving JPA Entity Objects of JPA is JPQL (Java Persistence Query Language). It enables retrieval of objects from the database by using simple queries as well as complex, sophisticated ones. JPA queries and JPQL are described in | |
Is ObjectDB better than competing object databases?, including aggregate queries, as part of its support of JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is faster than other products. | |
JPA Named Queries A named query is a statically defined query with a predefined unchangeable query string. Using named queries instead of dynamic queries may improve code organization by separating the JPQL query strings from the Java code. It also enforces the use of query parameters | |
What are the main benefits of using ObjectDB? processes JPQL (JPA Query Language) and JDOQL (JDO Query Language) queries directly, where ORM tools first | |
JPA Annotations for SQL Queries The following JPA annotations are designated for SQL queries on relational databases: ObjectDB supports only the preferred JPA query language, JPQL , and silently ignores all the above annotations. | |
ObjectDB 2.9 Developer's Guide; Explains how to use the JPA Query Language ( JPQL ).   | |
Deleting JPA Entity Objects;The DELETE Queries in JPA/ JPQL in chapter 4 explains how to use JPA DELETE queries. | |
Is ObjectDB a NoSQL Database?, using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO | |
Criteria Query Selection and Results.persistence.criteria package, since they might be useful also in string based JPQL queries. Using tuples | |
Updating JPA Entity Objects in one operation. The UPDATE Queries in JPA/ JPQL in chapter 4 explains how to use JPA UPDATE queries. | |
JPQL support for Maps (JPA 2.0) JPQL 2.0 introduces the ability define FROM variables for map keys and values. Currently ObjectDB supports FROM variables for collection elements. FROM variables for map keys and values are expected ... both KEY and VALUE statements with JPQL with the latest version of ObjectDB 2.3.7 | |
JPQL Update & Delete (JPA 1.0) JPQL (Java Persistence Query Language) supports updating and deleting database objects by queries. Currently ObjectDB supports only JPQL SELECT (retrieval) queries. Delete queries are supported for JDOQL (JDO Query Language). support Support spring-data-jpa uses delete queries to implement | |
JPQL Subqueries (JPA 1.0) The JPQL (Java Persistence Query Language) supports defining subqueries, which are nested queries that are embedded in other queries. Subqueries are currently not supported by ObjectDB, and as a workaround, you can use a sequence of two or more queries, where the results of one query serves as a parameter in the next queries. support Support | |
Step 4: Create an ObjectDB Data Set this tutorial contains Point entity objects. We will use a simple JPQL query that retrieves points with x |