About result

forum_thread

JPA and handling large data sets

This is not a rellay ObjectDB problem, rather a JPA problem. Our web-based DB supports Hibernate or JPA (ElicpseLink/ObjectDB). We implemented a export/import class to export the whole database or single datasets (domains) in a persistence layer/database independent format. This class works fine - DB exports form a Hibernate/MySQL base via the independent formt to ObjectDB is possible. But exporting large binary data sets is very slow. To avoid memory problems the binary data type is read step by step during the export with the  query/setFirstResult() & setMaxResults().... 21:37 Using query result range ( setFirstResult , setMaxResults ) for this purpose is indeed ... because some query processing is required also for all the result objects before the first result (in order to count them). Much ...

 
release

2.6.3

... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ... non public persistable types. Fixed the result type of a sum query on a single value. Version 2.5.6 ...

 
forum_thread

Conflicting modifiers .... (javax.persistence.Id, javax.persistence.ManyToOne)

I have two classes a Container type class and another class that is 'contained' by that class. The contained class, CompoundKeyMapItem, represents an alternate implementation of an object held in a Map, and uses a Compound Primary Key. The contained class therefore uses an @IdClass. This all works fine on Eclipselink. However when I try and run this in ObjectDb I get the following error; ... { //Follow bloch Item 8. int result = 17 ; result = 37 * result + cachedKey. hashCode ( ) ...

 
issue

Large query parameter - out of memory

I have an entity object composed of an id, large data in the form of a string and the hashcode of the string as an index. The attached test saves 2000 of these objects, writing the data to a txt file as it goes. It then loops through the data from the file and queries for the entity id based on the data hashcode and the data itself. ... a failure of ObjectDB in evaluating cached query result size. Since Java doesn't provide information on heap memory ... - ObjectDB does its own evaluation. Every cached result entry contains query request (key) + query result (value). ObjectDB evaluated only the query response, which is usually ...

 
api-jpa

javax.persistence.NonUniqueResultException

Thrown by the persistence provider when Query.getSingleResult() or TypedQuery.getSingleResult() is executed on a query and there is more than one result from the query.(Exception of JPA)

 
release

2.6.2

... ( issue #249 ). Improved title of query result windows in the Explorer. Changed the Enhancer to return ... non public persistable types. Fixed the result type of a sum query on a single value. Version 2.5.6 ...

 
api-jpa

javax.persistence.NoResultException

Thrown by the persistence provider when Query.getSingleResult() or TypedQuery.getSingleResult()is executed on a query and there is no result to return.(Exception of JPA)

 
forum_thread

Using the wrong class to access a database

Hello, just starting to test ObjectDB and ran into a problem. I've created a small program to test the Point database described in the Getting Started section: #1 2013-06-27 16:00 Hello, just starting to test ObjectDB and ran into a problem. I've created a small program to ...

 
forum_thread

Problem with distinct select, order by and equivalent alias/attribute path

Hi, while working with a (standard-)JPA-query generating framework we run into an exception when ordering the results of some projection when the order by expression is different (though logically equivalent) to the projection expression. Here is the example: ... it must follow these restrictions, otherwise the same result may have multiple different order values. Your third query, ...

 
forum_thread

Explorer query functionality

Is there a way in the Explorer to associate JPQL queries with query result windows?  I would really like to be able to open multiple query / result tabbed panes and be able to save out my queries, similar to what you can do in Benthic Golden or Toad in the SQL world. Alternatively are you aware of any other JPA + JPQL workbench tools, commercial or otherwise that would support this? ... a way in the Explorer to associate JPQL queries with query result windows?  I would really like to be able to open multiple query / result tabbed panes and be able to save out my queries, similar to what you can ...