About query

181-190 of 200Refresh
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
Forum
12

Is named-query supported in orm.xml

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: query name= "DataValue.deleteByCapabilityAndCreationtime"> <query>delete from DataValue d where d.capabilityId = :capabilityId
Forum
12

Query execution time issue

Hi, I have a query similar to this one: select person.name, person.surname, ... ... from ... of this query (running with ObjectDB) takes about 10-12 seconds. If i remove ANY 5 left joins, query execution time drops to about 50 milliseconds. Adding a new left join on remaining 8 slows down query
Forum
12

Calendar in Criteria Querys

Hi, i am having troubles creating criteria querys for Calendar objects. As far as I ... got such methods, but i dont know how to use those in my query. JPA supports 3 temporal types: java ... . Anyway, the following example demonstrates criteria queries with Calendar. The usual comparison methods