About result

release

2.6.5

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

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

 
manual

Database Management Settings

Explains settings and performance tuning of the ObjectDB Java object database for JPA/JDO.... The results attribute specifies the size of the query result cache. Caching results is very useful for recurring queries with ...

 
issue

Strange Error with Criteria API and Sorting

We're creating a simple selection (distinct) including an order clause. When watching the created criteria in debugger we get the correct expression: SELECT DISTINCT $1 FROM MyEntity $1 WHERE ((TYPE($1)=class test.MyEntity)) ORDER BY UPPER($1.name) DESC You can see that in the order by there's correctly a "$1" var. Running this (without the type thing before) in the explorer correctly returns the sorted results. However, running this with the criteria API produces this error: ... ( true ) ; List<TestEntity> result = em. createQuery ( query ) . getResultList ( ... ) ;   for ( TestEntity e : result ) { System. out . println ( "Name: " ...

 
forum_thread

Possible issue with timestamps

Hi, If I query doing something like: select c from CDI c where c.creationDate > {ts '2012-03-29 11:00:00} and c.creationDate < {ts '2012-03-29 12:00:00'} the test fails. Its ONLY for 12:00:00. When I started digging I found that if I queried 00:00:00 to 00:25:00 and then did 12:00:00 to 12:25:00 I got IDENTICAL results. For some reason 12:00:00 is being treated the same as 00:00:00. All other hours seem to be fine. #1 2012-03-29 05:07 Hi, If I query doing something like: select c from CDI c where c.creationDate > {ts '2012-03-29 11 ...

 
forum_thread

EntityManagerFactory Fails To Swtich Over To Slave When Master Is Unavailable

I have a simple task to validate the sample code will switch over to the slave database when the master is unavailable. I simulate the master unavailable by stopping the master server; which generates the following exception below. What am I doing wrong? It appears the connection manager fails to try the second URL in the list: objectdb://10.9.2.15:9998//10.9.2.15:9999/test.odb;user=admin;password=password Thank you in advance. #1 2013-05-06 20:16 I have a simple task to validate the sample code will switch over to the slave database when the master is unavai ...

 
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)