48 | Speed of queries that return many objectsHi, 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<BenchEnt> query = em.createQuery("SELECT a FROM BenchEnt a", BenchEnt.class |
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 |
48 | 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 |
48 | 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 |
48 | 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 |
48 | 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 |
48 | Is named-query supported in orm.xmlI prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: <named-query name= "DataValue.deleteByCapabilityAndCreationtime"> <query>delete from DataValue d where d.capabilityId = :capabilityId |
47 | Debuging query before executionHi, Is is possible in any way to get string representation of a query right before execution, after setting parameters? Of course it's easy to print out query string when we build it by concatenating ... implementation. What exactly do you suggest? The query string with parameter values embedded, replacing |
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 |
