About COUNT

forum_thread

persitencia (Preguntas y respuestas)

1ra.pregunta:     tengo un formulario y cuando grabo mas de un registro, solo me grava el ultimo mas no los anteriores. 2da.Pregunta:    Tengo un indice que no es el ID y necesito que mi tabla muestre los datos de acuerdo al indice. Como                          puedo hacerlo?. Alguien me sugiere algo. Gracias   ... Implement  getRowCount() with a SELECT COUNT query. Implement  getValueAt() with an ORDER BY ...

 
forum_thread

Failed to read the value of field using reflection

I have recently encountered an issue with reading objects: ... I saved, quitted and reloaded the database. Then I try to count the number of characters my player object I fetched from the database. ...

 
release

2.6.9

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
forum_thread

enumeration table? how to on pure jpa?

Hello , I've relational db , and there is some table named enumerations with , some key and values.We will migrate to objectdb. Our problem is , we want to store some keys and values for global application configs. Like; tablename : enumeration table rows: key                value ... by hand forces users some mistakes when configuration count increase much. It would be good to natively add into ObjectDB like me ...

 
release

2.6.8

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
issue

Unexpected error when loading all entity instance

Hi, when going through all entity instance to find orphaned entries we get the exception: ... [ 1 ] Unexpected total object count: 1041631 ( expected 1041630 )   BTree Value Errors ... - Unexpected object count: 773 ( actual 772 )   Page Relation Errors ...

 
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().... the result objects before the first result (in order to count them). Much more efficient way is to replace setFirstResult ...

 
release

2.6.7

... Fixed a memory leak (Negative snapshot user count) in UPDATE queries on uncommitted changes ( issue #224 ). ... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
release

2.3.6

... optional. Fixed the "Negative snapshot user count" bug ( issue #83 ). Fixed a page cache purge deadlock ( ...

 
forum_thread

collection of embedded objects

1. In general, are there any restrictions of the use of @Embedded objects in collections, compared to @Entity? 2. If you have a large nested collection of @Embedded objects, and you remove the parent @Entity, does the remove cascade through the whole collection? 3. Is searching through collections of @Embedded objects more expensive (time) than searching through collections of @Entity? ... ie. Suppose I want to query: SELECT count ( a ) FROM A a WHERE a . setOfB . value = ...