ObjectDB ObjectDB

Internal Website Search

11-18 of 18 resultsRefresh

JPA Query Expressions (JPQL / Criteria)

, sqrt). String expressions (like, length, locate, lower, upper, concat, substring, ...). Data

ObjectDB Object Database Features

& functions (LIKE, CONCAT, TRIM, SUBSTRING, ...). JPQL collection operators & functions (IS EMPTY, MEMBER

JPA Criteria API Queries

, quot, mod, abs, neg, sqrt). String expressions (like, length, locate, lower, upper, concat, substring

order by string with numbers

The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM Users u ORDER BY SUBSTRING(u.username,4)*1 ASC If you have other alternative for JPA

Database size is much larger than expected (x2)

Uris();    String sLine;    sLine = sss.substring(rd.nextInt(100));    uri.setsUrl(sLine);    int

Partial Indexing

I have a question about partial indexing. For example, a field of String type ttt, will be distinguished by the first 5 characters, then I can make a index of substr(ttt,1,5) in MySQL. With ObjectDB, how can I write the annotation for this purpose? TIA gzdillon Lai Yang Currently ObjectDB supports

combined index not used

combined index not used

com.objectdb.o.InternalException: null

ParseException {         String dateOfBirthStr = personalNumber.substring(0, 8

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