ObjectDB ObjectDB

Internal Website Search

1-10 of 53 resultsRefresh
376

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
161

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
157

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
157

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 gzdillon Lai Yang The focus of JPAB is JPA implementations and ObjectDB is the only object database that supports JPA. However, since DataNucleus
148

Java 6/7 Performance Comparison

Java 6/7 Performance Comparison
32

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
32

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
26

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).
26

Query Parameters in JPA

the above example, a comparison of :name to a field whose type is String indicates that the type ... comparison against a specific date, when time should be ignored. The get methods support different ways
5

[ODB1] Chapter 7 - JDOQL Queries

object in other operations, such as method calls and comparison expressions. Fields Persistent fields ... can participate in queries in combination with comparison expressions, as in "this.age >= 18 ... expression (for example, when the || operator is used). Operators Comparison operators Comparison operators

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support