About result

forum_thread

In memory processing for ObjectDB

Hi there ! We are building a platform for trades processing where we want to keep our processing speeds very high. We like ObjectDb because its simplicity and the performance benchmarks, but to take it to next level really we wanted to check whether is there any In memory mode available for ObjectDB where recovery is possible, something like prevalyer etc. ... I see in settings is query cache, is it only that query result sets are cached or I can actually have a all of my Objects in Cache ? ...

 
manual

GROUP BY and HAVING clauses

Explains how to use the GROUP BY and HAVING clauses in a JPA/JPQL query.... to the SELECT clause which returns the first letters as result. ObjectDB is very flexible in allowing JPQL expressions ... Create a CriteriaQuery object with the specified result type. See JavaDoc Reference Page... ( Country. class ...

 
api-jpa

getSingleResult()

Execute a SELECT query that returns a single untyped result.(Method of javax.persistence.Query)

 
manual

Query Parameters in JPA

Explains how to use parameters (named parameters and ordinal parameters) in JPA queries.... method Execute a SELECT query that returns a single result. See JavaDoc Reference Page... ( ) ; ... method Execute a SELECT query that returns a single result. See JavaDoc Reference Page... can be chained to the same ...

 
page

ObjectDB Object Database Features

ObjectDB provides a rich set of features, many of them as the result of supporting the JPA and JDO APIs.... Highly optimized code (as a result of many profiling sessions). Unique data structures and algorithms (as a result of years of R&D). ...

 
forum_thread

Memory leak with OutOfMemoryError exception

Hi, I'm new to using object databases. Currently I'm experience the following error: #1 2012-02-11 19:15 Hi, I'm new to using object databases. Currently I'm experience the following error: Except ...

 
forum_thread

Join performance in Objectdb

select count(e) from Meta e, ImageNet i, Page p where e.idImage=i.id and e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records. What formula can predict the time for such counting? TIA ... completed." ) ;   long ms, result, elapsedTime ;   System. out . println ( ... AND a.cId = c.id" , Long. class ) ; result = q1. getSingleResult ( ) ; elapsedTime ...

 
issue

JQL-Update Queries fails with activated L2-Cache

When using JQL-Update Queries it is basically not working without calling entityManager.clear() after a transaction commit. When the clear() method isn't called the entityManager will never return a container the updated Entities. Scenario 1: Disabled L2 Cache, updating elements using UPDATE-Query and fetching Entities afterwards from database. Expected result: Getting changed Entities from database - Actual result: No changes are visble. ... fetching Entities afterwards from database. Expected result: Getting changed Entities from database - Actual result: No changes are visble. Scenario 2 : Disabled L2 Cache, ...

 
forum_thread

Retrieve data of all entity classes in a single query

I have in an objectdb file 10 Entity Classes with some data in each (Athlete, Trainer, Stadium etc) This is the code I use to retrieve all Managed Types and data for the Athlete class ... ( ) ; for ( Athlete result : results ) { System. out . println ( result. Code + ", " + result. Name + ", " + ...

 
forum_thread

g when using SIZE in combination with date lower parameter

Hello, I have 2 entity types, which I want to query, ParserJob and Tag. Unfortunately there seems to be a bug if I use the lower date select: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated < :date This returns a SIZE(j.tags) of 0 Tags, but the only existing ParserJob has 1 Tag. If I run the query: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated >= :date I get the correct result (1 Tag). ... . dateCreated >= :date I get the correct result (1 Tag). You find a test case at <deleted>. Please ... same results but they do not. The first query returns 1 result and a tags size of 1 which is correct, the second query also returns 1 ...