About results

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().... order value. For example, if your query returns results ordered by the primary key, use the value of the primary key of the ...

 
release

2.6.3

... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ... in using JPQL operations (e.g. UPPER ) in DISTINCT results. Fixed an exception in handling user defined serializable ...

 
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; #1 2011-09-23 10:36 I have two classes a Container type class and another class that is 'contained' by that class. The co ...

 
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. Bug Version: Priority: Normal Status: Fixed Replies: 1 Type:  Bug ...

 
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

... Fixed a bug of returning managed hollow objects in query results. Fixed an error message for invalid DELETE query ( issue ... in using JPQL operations (e.g. UPPER ) in DISTINCT results. Fixed an exception in handling user defined serializable ...

 
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: ... p" , Point. class ) ; List<Point> results = query. getResultList ( ) ; System. out . println ( "number of entries: " + results. size ( ) ) ; }   static ...

 
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: ... framework we run into an exception when ordering the results of some projection when the order by expression is different (though ... order expression 's_location' for distinct results (error 745) (position 85) at ... Invalid order expression 's_location' for distinct results at com.objectdb.o.MSG.d(MSG.java:62) at ...

 
forum_thread

How to do multithreading with embedded ObjectDB

Hi, I've tried to implement a counter with ObjectDB, but the following code doesn't work as expected: ... , Point. class ) ; List<Point> results = myquery. getResultList ( ) ; System. out . println ( "X coordinate is: " + results. get ( 0 ) . getX ( ) ) ; ...