Home » Search

About query

151-160 of 200Refresh
Forum
13

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
13

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
JPA Doc
13

javax.persistence.criteria.AbstractQuery

The AbstractQuery interface defines functionality that is common to both top-level queries and subqueries. It is not intended to be used directly in query construction. All queries must have: a set of root entities (which may in turn own joins). All queries may have: a conjunction of restrictions
Forum
13

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
12

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
Manual
12

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
12

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
12

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
12

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
11

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