About paging

forum_thread

First query takes 4+ minutes to complete

Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. We observed that in our case it takes on average more than 4 minutes to complete the first SELECT query that we run on the DB which contains about 320,000 records of a single type of object. SQLite in comparison responds within few seconds on average with the same number of records. We hope to receive your recommendation on how to improve this result with this post.   Test System #1 2013-08-05 05:44 Hi, we are evaluating ObjectDB 2.5.1_04 in embedded mode hoping to replace SQLite in our application. ...

 
forum_thread

Failed to commit transaction: Attempt to commit a rollback only transaction

Anyone know what this means?? Suddenly cropped up.   Failed to commit transaction: Attempt to commit a rollback only transaction (error 613) at com.objectdb.jpa.EMImpl.commit(EMImpl.java:271) at javax.jdo.Transaction$commit.call(Unknown Source) #1 2011-05-24 22:22 Anyone know what this means?? Suddenly cropped up. Failed to commit transaction: Attempt to commit ...

 
forum_thread

Spring Data JPA - PersistenceException thrown

In a Spring-managed application that has 2 EntityManagerFactories (one Hibernate and one ObjectDB), I see the 2 EMFs created successfully on startup, but then subsequently when the application is initializing Spring JPA repositories with Hibernate EntityManagers, the application throws the following stacktrace. I've seen a couple of similar posts regarding a NPE when looking for resources, but they seem different enough that they might be a different issue.   #1 2015-06-23 22:49 In a Spring-managed application that has 2 EntityManagerFactories (one Hibernate and one ObjectDB), I see the 2 E ...

 
forum_thread

Failed to validate XML

[ObjectDB 2.6.7_05] javax.persistence.PersistenceException Failed to validate xml file /{erased-by-me}/tiro/lib-core/build/resources/test/META-INF/persistence.xml: (error 211) at com.objectdb.jpa.Provider.createEntityManagerFactory(Provider.java:88) at com.objectdb.jpa.Provider.createEntityManagerFactory(Provider.java:32) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:54) #1 2016-04-20 10:21 [ObjectDB 2.6.7_05] javax.persistence.PersistenceException Failed to validate xml file /{erased-by-me}/tiro/li ...

 
forum_thread

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the retrieved list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed. What is the problem? #1 2014-09-27 17:42 When using the CriteriaBuilder to query, the loaded list are not refreshed according to the latest updates. B ...

 
forum_thread

Doctor - high memory usage

Hi, Is it possible to reduce Doctor memory usage? Right now for recovering 67MB database, I need to set heap space to at least 450MB. Even then whole process takes ages. Optimal setting for this database is about 650MB. It's about ten times of size of database. #1 2011-03-22 22:08 Hi, Is it possible to reduce Doctor memory usage? Right now for recovering 67MB database, I need to set h ...

 
forum_thread

Efficient query on EmbeddedId

Hi! I have an entity class with an @EmbeddedId (field1 int and field2 int). Based on the manual, I understand that making a query just on entity.id.field1 is efficient. Of course, making a query containing the whole EmbeddedId is the ideal case, and I use it, but I need more use cases. #1 2014-07-25 16:29 Hi! I have an entity class with an @EmbeddedId (field1 int and field2 int). Based on the manual, I unders ...

 
api-jdo

javax.jdo.FetchGroup

FetchGroup represents a named fetch group for a specific class or interface.(Interface of JDO)

 
forum_thread

Eclipse/JPA database tutorial

Hello Sir/Madam, I followed all the steps correctly as given in the tutorial. But when i run it , I'm getting an error saying, the resource not available. Please help regarding the issue as soon as possible. Thank you. #1 2012-09-16 07:20 Hello Sir/Madam, I followed all the steps correctly as given in the tutorial. But when i run it , ...

 
forum_thread

Vacuum - Reclaiming Unused Space In Odb

I was curious if you could assist me with a challenge we are having with our objectdb database.  Our odb files are about 50Gb in size and are written to about a million times a day with both adds and updates.  This is creating a lot of unused space in the database that we are wanting to reclaim.  Other database vendors provide a vacuum process to allow dumping a database to a flat file (basically a sql dump) and reload.  Is there a capability in ObjectDb to provide a vacuum?  The online backup feature appears to copy the dead space as well so isn't performing #1 2016-03-02 06:42 I was curious if you could assist me with a challenge we are having with our objectdb database.  Our odb fil ...