Home » Search

About query

151-160 of 200Refresh
Forum
12

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 API
Forum
11

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 query token 'value'>. I try  "select XXXValue.value from XXXValue" and the error is the same. Queries on others attributes work
Forum
11

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 ... . If you have more objects in the current transaction it takes more time (i.e. every query execution
Manual
11

Shared (L2) Entity Cache

. Cache of query programs. Cache of query execution results. The scope of these server side caches ... can also be overridden for a specific retrieval operation: // Before executing a query:   query.setHint
FAQ
11

What are the main benefits of using ObjectDB?

JPQL (JPA Query Language) and JDOQL (JDO Query Language) queries directly, where ORM tools first convert these queries to SQL and then transition the SQL to the DBMS for execution through a JDBC driver
Result
11

Posting to ObjectDB Website - Important Instructions

. Use appropriate styles for formatted lines (Java code, stack trace, query, console/shell input ... MyEntity("test");         em.persist(e);         em.getTransaction().commit();         Query query = em.createQuery("SELECT e FROM MyEntity e");         List resultList = query.getResultList
Forum
11

Query problem after transaction commit

to it. The client program can connect to the server and query to get all the records. However, after transaction ... > Test_Connection: connected 03> UI: start query [query for all object Goods successfully] 04> SELECT u FROM Goods u where u._code like :code AND u._desc like :desc  05> code= %, desc= % 06> UI: end query
Forum
11

Cache configuration of database file pages, query programs, query results

Are there some possibilities to configure following caches in order to keep cache data for only some important entity types and for the entire life cycle of the EntityManagerFactory. Cache of database file pages. Cache of query programs. Cache of query execution results. These caches are fully
Forum
11

IN expression in a Criteria Query

, it is written that ObjectDB is 100% compatible with JPA. However, I have problem with this JPQL query ... .employeeEntity = e) ORDER BY e.name with Hibernate, there was no problem with this query, but ObjectDB throws exception: com.objectdb.o.UserException: Unexpected query token 'EXISTS' Second problem
Forum
10

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the loaded list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed, and, when I querying for primitive ... side does not any diference. The problem is only solved when changing the query mode, from