48 | Performance issue in a query due to compareTo callsHello, 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 |
48 | 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 |
48 | Unable to execute update queryHello! I'm trying to do an update query via the explorer to set a new field value for around 400k ... reading a temporary file that is used in an update query, but the cause is unclear, and according ... and temporary files): import javax.persistence.*; import javax.persistence.Query; public class |
47 | 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(); maozf maozf The following example demonstrates |
47 | Calendar in Criteria QuerysHi, 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. suez Tobias JPA supports 3 temporal ... limitations. Anyway, the following example demonstrates criteria queries with Calendar. The usual comparison |
47 | 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 ... by: com.objectdb.o._NoResultException: No matching results for a unique query at com.objectdb.o.JPE |
47 | Query execution time issueHi, 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 |
9 | 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 |
9 | Different behavior for two equal queriesHi, I've got two equal queries though they behave differently: SELECT FROM com.quasado.foundation ... if that helps: First query (which works): Query Plan Description ====================== Step 1: Process ... query (which fails): Query Plan Description ====================== Step 1: Process |
9 | Unexpected exception when execute query without enhanced entitiesObjectDB 2.8.7.b08 Our entities are not enhanced and we execute a query "select max(uid) from ... of the query: Caused by: com.objectdb.o.UserException: Unexpected query token 'uid' at com ... ..." instead of the UserException: Unexpected query token 'uid'. If the entities are enhanced then the query |
