Home » Search

About comparison

1-10 of 52Refresh
Manual
366

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
66

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
59

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
42

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
29

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
29

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
27

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
26

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
26

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
Forum
25

Java 6/7 Performance Comparison

Java 6/7 Performance Comparison