About query

161-170 of 200Refresh
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

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
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
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
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
Tutorial
11

Step 4: Create an ObjectDB Data Set

Queries against the database are represented in BIRT as data sets. To create the data set: Open ... contains Point entity objects. We will use a simple JPQL query that retrieves points with x value in ... and paste to enter the above query and click Finish. When the data set is created successfully - a new
Result
11

Posting to ObjectDB Website - Important Instructions [2018-08-06]

. 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
10

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

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in ... , approvePhoneNumber, .... because the parameters equivalent. I want to sort them in the query by their sum ... them. You can calculate it in a JPA lifecycle event. Currently you cannot convert boolean to int in queries