About comparison

1-10 of 52Refresh
Manual
337

Comparison in JPQL and Criteria API

Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison Operators ObjectDB supports two sets of comparison operators, as shown in the following table:   Set 1 - JPQL ... The following table shows how NULL values are handled by each comparison operator. One column presents
Manual
62

JPA Query Expressions (JPQL / Criteria)

: * (multiplication), / (division), + (addition) and - (subtraction). Comparison operators ... , isMember, isNotMember, size). Comparison expressions (equal, notEqual, gt, ge, lt, le, between, isNull, ...) Logical expressions (and, or, not, isTrue).
FAQ
55

Is ObjectDB better than competing object databases?

Naturally, this is not the place to look for an unbiased answer for this question. However, you should consider the following points when doing your own objective comparison of object databases: ObjectDB is unique in supporting the standard APIs. It is the only object database with built in support
FAQ
39

What are the main benefits of using ObjectDB?

All about What are the main benefits of using ObjectDB? in Java/JPA database - explanations, examples, references, links and related information.
Manual
28

Literals in JPQL and Criteria Queries

that comparison with NULL in JPQL follows the SQL rules for NULL comparison rather than the Java rules, as explained in the Comparison Operators page. Boolean Literals Similarly to Java and SQL, JPQL supports
Manual
28

Paths and Types in JPQL and Criteria API

persistable classes can participate in direct comparison using the = and <> operators ... and functions (e.g. for strings and for numbers), they can be compared by all six comparison operators ... the above example, the comparison is between the type of the e object (which may represent any path including
Forum
25

java.sql.Date equals comparison not working with CriteriaAPI

Hello, Using ODB 2.4.5 and the Criteria API, doing a simple equals comparison with java.sql.Date value doesn't match any results in the database. Our code looks like this: CriteriaBuilder builder ... everywhere also in the Entity property field to ensure pure date comparison and saving without time
Forum
24

ObjectDB vs DB4O comparison

ObjectDB and DB4O are the only two real object database I known. Why didn't you give a comparison between them in JPA Performance Benchmark (JPAB)?  TIA The focus of JPAB is JPA implementations and ObjectDB is the only object database that supports JPA. However, since DataNucleus provides partial
Forum
24

String comparison in query where clause

I am having trouble getting a simple string comparison to work in an SQL "where" clause.  It is my understanding that queries are case sensitive by default and I do not want that, so I am constructing the query as follows... SELECT e FROM Exercise AS e WHERE UPPER(e.name) = ?0 and then I
Manual
23

Query Parameters in JPA

the above example, a comparison of :name to a field whose type is String indicates that the type ... part of the newly constructed java.util.Date instance is discarded. This is very useful in comparison