About query

171-180 of 200Refresh
Tutorial
13

Step 3: Add a Main Class [2011-02-11]

: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); // Find the average X value: Query q2 = em ... > query =  em.createQuery("SELECT p FROM Point p", Point.class); List results
Tutorial
13

Step 3: Add a Main Class

: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); // Find the average X value: Query q2 = em ... ()); // Retrieve all the Point objects from the database: TypedQuery query
Issue
13

Large query parameter - out of memory

as it goes. It then loops through the data from the file and queries for the entity id based ... this should be sufficient as I only create/read one item of data at a time and am only querying for the id. After about 300 queries the test throws an out of memory exception so I assume the query data is being held
Forum
13

Optimization of Map Queries

.get(..) result(s) once to not query the map again and again for each test in my query? 2) Is there anything I could do for shortening the query string? I guess there's no such thing as a "temporary" variable for being used in the query.. I am creating the query using criteriabuilder, then I am converting
Forum
13

Performance issues on aggregate query

we are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1 ... valid;   No the problem is the following: when we query objects that have no objects linked into the relationship ObjectNode.childNodes the query takes around 1 second. when we query objects
Forum
13

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager ... (this.logEntryId)"); query.declareParameters("java.util.List typeIndexes,java.util.List
Forum
13

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
13

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
13

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
13

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