About query

181-190 of 200Refresh
Manual
12

JPA Primary Key

useful when using queries that return large result sets. As an example, consider a real time ... that queries that retrieve all the events of a specified sensor in a specified period are common and return thousands of Event objects. In that case the following primary key can significantly improve query run
Manual
12

Locking in JPA

); In addition, the hint can be set for a specific retrieval operation or query. Releasing ... ); A lock mode can also be set for a query in order to lock all the query result objects. When a retrieval
Forum
12

Performance issue in a query due to compareTo calls

Hello, we have a question again regarding query performance. The query: SELECT v FROM Values v WHERE v.step.stepNumber = ? is very slow in comparing to the query: SELECT v FROM Values v WHERE v.stepNumber = ? Can you explain why the first query needs so much time or do you have a hint
Forum
12

Speed of queries that return many objects

Hi, I have a DB of 146MB - with 1_000_000 elements. Loading the contents (objectDB query in java ... - according to blackMagicTest app for mac) - so I was expecting the query to take less than one sec (146 ... ();             TypedQuery query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class
Issue
12

unclear syntax for update query

. Query Update Action Set transferred = 0 where a.objectsInCharge.nodePath like "/(PR)W4455NS01%" and a.objectsInCharge.nodePath like "%MARAS%" results in Query Execution Error ===================== Unexpected query token 'a' Update Action Set transferred = 0
Forum
12

Duplicate Entity class names causes Exception in Query

of one of these entities. If I execute that query I get an exception;   Caused by: com.objectdb.o ... ) ... 64 more Here is the class doing the query on objdbTest.Item package objdbTest; import .... @Entity @NamedQueries({ @NamedQuery(name = "objdbTest.Singleton.getItem", query = "SELECT o
Forum
12

Unable to execute update query

Hello! I'm trying to do an update query via the explorer to set a new field value for around 400k ... file that is used in an update query, but the cause is unclear, and according to your report ... javax.persistence.Query; public class T1803 {     public static void main(String[] args
Forum
12

Criteria Query results in a NoResultException instead of returning object

(criteria).getSingleResult(); which evaluates to the query: SELECT $1 FROM IdentityObject $1 ... ._NoResultException: No matching results for a unique query at org.jboss.seam.security.IdentityImpl ... ) Caused by: com.objectdb.o._NoResultException: No matching results for a unique query at com.objectdb.o
Issue
12

Different behavior for two equal queries

Hi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation ... no results... Alex Here're also the execution plans from the explorer if that helps: First query (which works): Query Plan Description ====================== Step 1: Process IndividualContact ($1
Forum
12

Entity has be persistended,but query not fetched?

I create a new entity T newT and persistend it,then I create a query "select t from T t" to fetch all T entities.But  then the newT is not contain in the query result. Why? code order: query.setFlushMode(FlushModeType.AUTO); query.getResultList();   The following example demonstrates