ObjectDB ObjectDB

Internal Website Search

11-20 of 200 resultsRefresh

NULL prefered in ORDER BY?

Hi! Is there a way to NOT prefer NULL in Order BY? I.e. assume this: @Entity class Hint ... Test ORDER BY hint.name It orders ASC like this (assuming I've got three Test Entities whereas first ... supported. null values are smaller than any other value so they appear first in ordering

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 ... Hi Anyone could help me I need to order a string for example user1, user2, ..., user1000 I found

Alias not used in ORDER BY

(builder.asc(upperPath)) I would have expected the alias to be used in the ORDER BY clause, something like SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY TEST However what I actually get as query string is SELECT $1, UPPER($1.someStringProperty) AS TEST FROM T ORDER BY UPPER($1


javax.persistence.criteria Interface Order An object that defines an ordering over the query results. Since: JPA 2.0 Learn how to use JPA Criteria API's Order in Chapter 4 of the ObjectDB/JPA manual. Expression<?> getExpression() Return the expression that is used for ordering. Return


Method javax.persistence.criteria.Order Order reverse() Switch the ordering. Returns: a new Order instance with the reversed ordering Since: JPA 2.0


Method javax.persistence.criteria.Order boolean isAscending() Whether ascending ordering is in effect. Returns: boolean indicating whether ordering is ascending Since: JPA 2.0


javax.jdo.annotations Annotation Order Target: Fields (including property get methods) Annotation for the ordering component of an ordered container member, such as Java Collections Framework Array and List types and Java native array types. Corresponds to the xml element "order". Since: JDO 2.1

[ODB1] Chapter 9 - ObjectDB Explorer

the "Shown Fields" and the "Hidden Fields" lists. You can change the order of the shown fields by using ... Some JVM arguments can be useful. For instance, by default Java does not use more than 64MB ... . Otherwise, the required executable jar would not be found by explorer.exe. By default, running explorer.exe


Annotation Element javax.jdo.annotations.Order Column[] columns The definition of the column(s) to use for ordering. Returns: the columns to use for ordering Default value: {} Since: JDO 2.1


Annotation Element javax.jdo.annotations.Order String column The name of the column to use for ordering the elements of the member. Returns: the name of the ordering column Default value: "" Since: JDO 2.1

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