About result

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 ...

 
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

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 ...

 
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

Slow searching with two indexes

I'm running queries on a large database (tens of millions of objects), and I'm running into a performance problem using two indexes.  An entity I'm querying has two indexed fields - one is the primary key (id) and so is different for each object, and the other is an object reference that only has a few tens of different values.   When I query by just the primary key, it's (of course) extremely fast, but when I also query using the other key, queries can take minutes. #1 2016-11-15 12:01 I'm running queries on a large database (tens of millions of objects), and I'm running into a performance ...

 
api-jpa

getResultList()

Execute a SELECT query and return the query results as an untyped List.(Method of javax.persistence.Query)

 
api-jdo

javax.jdo.annotations.Query

Annotation for a named query.(Annotation of JDO)