ObjectDB ObjectDB

Internal Website Search

131-140 of 200 resultsRefresh

Criteria query error: Unexpected query token

.arquillian.spi.ArquillianProxyException: com.objectdb.o._PersistenceException : Unexpected query token ... It seems that the query is invalid because a SELECT is not specified. Unexpected query token 'FROM' (SELECT is expected) A query with no SELECT may be valid in Hibernate HQL but not in JPQL and JPA Criteria

Querys slower when execute a query after every persist

The test case of the java file attachment persists many entities and executes a query ... requires only 20 sec, but the test requires 100 sec. Why the querys will be more and more slower? In ... (i.e. every query execution requires a more expensive flush). Results of your test with enhanced

ObjectDB Explorer query error: Unexpected query token 'value'

Hi, my entity is named "XXXValue": this has several attributes, one of these is "value". In query tab, if I do "select value from XXXValue", I get the error <Unexpected query token 'value'>. I try "select XXXValue.value from XXXValue" and the error is the same. Queries on others attributes work

Paths and Types in JPQL and Criteria API

, string, date). Simple type values are more useful in queries. They have special operators ... through a NULL value The following query retrieves country names with their capital city names: SELECT ... . It might be easier to understand exactly how this works by considering the equivalent JOIN query. Entity


> The CriteriaQuery interface defines functionality that is specific to top-level queries. Since: JPA 2.0 Learn how to define queries using the criteria API in Chapter 4 of the ObjectDB/JPA manual. AbstractQuery<T> distinct(boolean distinct) Specify whether duplicate query results will be eliminated. Specify

Once served to JSF page via @EJB query bean, many list fields are null (but same query ok after fresh persist in @PostConstruct)

, the inability to robustly query relationship fields in a web application renders the ObjectDB ... showing the query result in indexTest.xhtml. The problems is illustrated by running the attached JavaEE ... . For a number of different List fields, a query performed immediately after creating and persisting

JPA Entity Fields

the database, but is still available after retrieval by a special automatic query. Note: Navigation ... , since it requires running queries. Inverse fields are essential for collection fields when using ORM JPA ... the database. ObjectDB accomplishes this by effectively running the following query (where :d represents

Unexpected Query Token / Casting in Query

Hi! Please find the attached database. Doing a simple query with casting SELECT COUNT(DISTINCT $1 ... Query Execution Error ===================== Unexpected query token 'com.quasado.foundation.warehouse ... %') but the query still fails - now on navigation to routingNumber. Another casting will not help

Online Backup

Backup The online backup can be started by executing a special query on an EntityManager (em ... ").getSingleResult(); The backup query string is always exactly "objectdb backup". The backup is created ... query:     Query backupQuery = em.createQuery("objectdb backup");     backupQuery.setParameter

[ODB1] Chapter 6 - Persistent Objects

or queried directly (an embedded object can only be retrieved using a reference from its containing ... the database one by one. If more selective retrieval is needed, a Query can be used to retrieve ... (the commented line in the code above). Retrieval by Query The most advanced method for retrieving objects

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