About Data Source

forum_thread

Query fails with numerical values > 2^31

Hi ! I'm trying to execute the following query (from Java-code, also tried ObjectDB Explorer) delete from DataRecord p where p.TimeOfDeletion < 4147483648 This fails with "invalid numerical literal". The field p.TimeOfDeletion is of type long. As far as I know, the maximum value greater than 2^31 (Oracle: "The long data type is a 64-bit two's complement integer.") ... the maximum value greater than 2^31 (Oracle: "The long data type is a 64-bit two's complement integer.") In the database, ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Sorting problem

Hi, I was rewriting our DAO to support pagging in large dataset and I think I have found a problem with sorting. I send you a test case - sorry for using the same project as previous, but it was faster to write this test case. As usual, you can load data with DataLoader and then check problem with QueryData. There is a simple query with "order by" sentence: ... was faster to write this test case. As usual, you can load data with DataLoader and then check problem with QueryData. There is a ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Left join fetch behaviour doesn't retrieve children?

Hello support, I'm a little bit confused about a left join fetch behaviour. In this test case, i try to fetch my 3 children using a left join fetch. But my collection is null after closing the em. It was expected to be fetched before closing the em, no ? In fact, that is the objective of the fetch purpose (i guess ?). ... but unfortunately in this case the test verified that the data is fetched with the query results (which worked, no additional access to ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
issue

JQL-Update Queries fails with activated L2-Cache

When using JQL-Update Queries it is basically not working without calling entityManager.clear() after a transaction commit. When the clear() method isn't called the entityManager will never return a container the updated Entities. Scenario 1: Disabled L2 Cache, updating elements using UPDATE-Query and fetching Entities afterwards from database. Expected result: Getting changed Entities from database - Actual result: No changes are visble. ... EntityManager cache (the persistence context). But if the data is also cached in the L2 cache it may not help. Use refresh to enforce ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Improvement in replication

Hi, I was thinking about some improvement in replication mechanism. Our application do only few writes (mostly reads), but those writes are important for us - objects rating, profile modifications. So in current implementation when master node dies, there is only a chance to read data from slave and all writes fails. ... when master node dies, there is only a chance to read data from slave and all writes fails. I was thinking about special ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

RT Java application recording into 100DB run OOM after a few hours.

Hi, I am running a java application that records data from 100 feeds into 100 different database - this is done is one thread. It works fine several hours - and suddenly i got an out of memory issue (I checked there is no leak in java - I cleared the entity manager every 10 new entity). 1/ I use the default objectDb.conf (i mean i dont use any - so it must be using the default somewhere). 2/ Using Netbeans, I profiled the application and I noticed that there is one thread (ODB FileWriter) running for each open DB. ... Hi, I am running a java application that records data from 100 feeds into 100 different database - this is done is one thread. ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Beginners questions

Hello !! I am new in JPA / ObjectDB development and I have many questions: 1. If I understood correctly, ObjectDB is an implementation of JPA standard (currently 2.0)? 1.1. Is ObjectDB on the same level like Hibernate with only difference that Hibernate stores the data in a RDBMS and ObjectDB has its own format?   ... Hibernate with only difference that Hibernate stores the data in a RDBMS and ObjectDB has its own format? 2. Object creation ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Failed to commit transaction: Java heap space (error 613)

Hi, the following exception occurred in our production machine last night: 2013-07-17 20:41:46,665 pdnsrttor3rc42-WSAgent-2-Existing/16 ERROR ObjectDbMessagePipe - Failed to put a message on queue:  pdnsrttor3rc42-ReportDSGroup_Instance-2 retrying = true [ObjectDB 2.4.6_10] javax.persistence.RollbackException Failed to commit transaction: Java heap space (error 613) We are using ObjectDB 2.4.6_10, JDK 7, and a 30GB heap space. ... configure ObjectDB to use less heap space and persist more data on disk instead? c) Can we configure ObjectDB not to throw the ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
forum_thread

Degrading performance overtime

hi, We have an application that uses embedded odb database. We have configured odb to start at 50meg chunks and grow at 50 megs a time. as the files become larger between 1 and 2 gigs we start to see considerable degrade in performance caused internal objectdb locking: ... port = "6136" max = "100" /> <data path = "$objectdb/db-files" /> </server > ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...

 
issue

Internal Exception and Index Problems

Dear Support Team, we have an urgent issue in a productive database. The objectdb doctor finds no error but one string field of one database item is not editable (even not using the objectdb explorer). The corrupt entry is in entity "UserModelData" with id="7d29d5eb-69a6-4d46-9bf1-802cbb6e439b". Try to change the userName attribute of this entry then the following error occurs: ... 2013-09-09 17:25 The data in that specific object in field userName is not synchronized with the ... block. Avoid overflow of published source code examples by breaking long lines . You may mark in ...