About query

131-140 of 200Refresh
Manual
35

SELECT clause (JPQL / Criteria API)

, the following query returns Country objects that become managed by the EntityManager em: TypedQuery query = em.createQuery("SELECT c FROM Country c", Country.class); List results = query.getResultList(); Because the results are managed entity objects they have all the support
Forum
34

JPA Query language support in OBjectDB / Sub query or nested Query

have given a sample typed query below which fails to work with ObjectDB and it runs very well with the Hibernate/MySQL JPA. We are using Spring Data here. It looks like a problem with Sub query or nested queries where I am using IN clause like below. @Query("SELECT product FROM Product product
Issue
30

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
Issue
28

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 ...     )     .bankAccounts     .routingNumber   )   LIKE UPPER('%28%') but the query still fails - now
Forum
28

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
28

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
28

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
Forum
28

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
Result
27

ObjectDB Object Database Features

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ... ). Database file page cache. Query program cache (for repeating queries with different arguments). Query result cache (for repeating queries with the same arguments). Many other internal caches. Indexing
Result
27

ObjectDB Object Database Features [2018-10-27]

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ...  (per EntityManagerFactory). Database file page cache. Query program cache (for repeating queries with different arguments). Query result cache (for repeating queries with the same arguments). Many