ObjectDB ObjectDB

Internal Website Search

21-30 of 200 resultsRefresh
115

order by string with numbers

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

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

:query"); q.setParameter("query", "%myQuery%"); I don't get any error! The order of the WHERE clauses
23

criteria api / embedded objects / where order

to the order of the where clouse and the 2.7.4 wasn't. Unfortunatly I was not able to strip ... to the order of the where clause, meaning that the result set differs. As far as I understand there might be some performence issues related to the order but no different result set. Because we have different
23

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
19

Criteria Query Selection and Results

The JPA Criteria API interfaces in this group are used for setting the SELECT and ORDER BY clauses ... : See the SELECT in Criteria Queries section for more details and examples. ORDER BY Clause Elements Elements in the ORDER BY clause are represented by the Order interface: The Order interface is a thin wrapper
16

Database Explorer

. You can also execute a query using the Window > Open Tree Window or the Window > Open Table Window commands in order ... the Edit > Delete command. The order of elements in an ordered collection can be modified by using ... windows and their order of appearance. This may be useful when working with classes with a large number
13

JPA Lifecycle Events

NoDefaultListenersForThisEntityEither extends NoDefaultListenersForThisEntity { } Callback Invocation Order ... listeners) the invocation order is based on the following rules: All the external callback methods ... . If there is more than one default listener or more than one listener at the same level in the hierarchy, the invocation order
1

[ODB1] Chapter 9 - ObjectDB Explorer

of the query. Optional JDOQL components, such as filter, parameters, variables, ordering and imports (chapter ... from the auto completion list when you write the query filter and also when you fill the ordering field ... is useful in order to avoid losing values of that field if the field has been renamed in the IDE
1

[ODB1] Chapter 6 - Persistent Objects

that is required by JDO, ObjectDB manages another cache containing database pages, in order to improve ... . Therefore, a null value can also be specified, but in order to keep the application JDO portable, a proper ... order is from the oldest object to a newest, i.e. from a lower object ID to a higher one. Unlike
1

[ODB1] Chapter 4 - JDO Metadata

of each class in several .jdo files in a pre defined order. If a metadata description is found ... the order shown): META-INF/package.jdo WEB-INF/package.jdo package.jdo a/package.jdo a/b/package.jdo ... the order shown): META-INF/package.jdo WEB-INF/package.jdo package.jdo X.jdo A metadata file with the name

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