About result

issue

Issue with DISTINCT Select

It is getting more and more frustrating :( We've introduced distinct select instead of regular selection in our code (no changes else) and suddenly receive invalid identifiers in queries exceptions in various queries. Here's the stacktrace: ... Implicit variables that are generated as a result of path navigation (e.g. x.a.b ). Only explicit ... than on tuple, e.g. if (1,2a) and (1,2b) are both result tuples - only 1 is returned. How should it be ordered as 2a.lastName or ...

 
manual

JPA Query API

Describes the API that JPA provides for running queries against the database.... interface should be used mainly when the query result type is unknown or when a query returns polymorphic results and the lowest known common denominator of all the result objects is Object . When a more specific result type is expected ...

 
release

2.6.6

... in queries. Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a ... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ...

 
forum_thread

Caching/Paging Questions...

Greetings ObjectDB team, All below questions assume a very large database (~1,000,000,000 objects): Q1: Two queries with a big overlap between their result sets. If I query the first set and hold the results in memory somehow, would that speed up the execution of the second query since many of its result objects already created and reside in memory ?... Q1: Two queries with a big overlap between their result sets. If I query the first set and hold the results in memory somehow, ... up the execution of the second query since many of its result objects already created and reside in memory ? Q2: Do I need to ...

 
manual

Logical Operators in JPQL and Criteria API

Explains how to use AND, OR and NOT in JPQL queries.... operand is NULL and the other operand is FALSE the result is FALSE , because one FALSE operand is sufficient for a FALSE result. If one operand is NULL and the other operand is either TRUE or ...

 
forum_thread

Explorer in 2.3

First, the new Explorer in ObjectDB is fantastic! This is exactly what we've needed - an easy way to do ad-hoc JPQL queries and navigate through the results and even make small changes to primitive data and Strings. After playing with it for a while, here is a list of additional features I'd love to have: 1. Export of selected data: a. Simple - Select a range of cells or a column header and copy text to the clipboard or save to a file (csv, html, etc..). (There appear to be copy menu options, but I cannot get them to work.) ... Viewing all the objects of a class without a query and max result limit is not a common feature in database viewers. Any idea how this can ... that are opened while navigating the results. My initial result might have only a few records, but they may contain collections ...

 
api-jpa

javax.persistence.SqlResultSetMapping

Specifies the mapping of the result of a native SQL query.(Annotation of JPA)

 
manual

JPA Named Queries

Explains how to define and how to run JPA named queries.... Page... method receives a query name and a result type and returns a TypedQuery javax.persistence.TypedQuery ...

 
forum_thread

Should derived fields of an EmbeddedId be manually maintained by app code?

If I have an Entity which has a primary key which is derived and I am implementing it using @EmbeddedId, am I responsible for maintaining the derived fields of the @EmbeddedId? I could not find anything in the JPA 2.0 spec http://download.oracle.com/auth/otn-pub/jcp/persistence-2.0-fr-oth-JSpec/persistence-2_0-final-spec.pdf?e=1317047713&h=54831c176e81a244a4c309e13eba0b27 which tells me what to expect. ... { //Follow bloch Item 8. int result = 17 ; result = 37 * result + cachedKey. hashCode ( ) ...

 
release

2.6.7

... in queries. Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a ... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ...