ObjectDB Database Search

is that once we UPDATE a record from the client (via the RMI interface), all SELECT NEW ... queries ... has 3 records which were updateted by a remote client (over RMI). They have IDs 9766, 9890 and 9897. These records cause all SELECT NEW ... type queries, which run internally, to fail

do a delete query, the records don't get deleted "delete from TestTable t " When I insert a record , then delete it, then re-insert it again, the slave server will give this error because the record did not ... Support Hi.  Just add 5 records and the delete using query.  Then add the same 5 records

Hello.  My objectDB had over 100 million records .  I have removed 100,000 records in that DB and the size does not decrease.  In fact it keeps growing as records decrease.  ... records reduce, as it is live in production. I do an hourly backup and the backup file is not any

get corrupted database files in any possible case. I found "recovery" and " recording " in the objectdb.conf ... 2 separate mechanisms for recovery from failure: Recording (transaction log). Recovery (double writing). Every mechanism has its own advantages and disadvantages. In some cases recording is faster

really care which record I'm looking at. I would recommend adding a field where you can enter the maximum number of records 'N' (default to some small number like 10) to display ... that are opened while navigating the results. My initial result might have only a few records

Hello! I try to get a replication setup working on two test servers. So i copied my test database to one of them, enabled recording and started odb. The dbname.odr folder got created so i think ... to the slave only if full recording is available starting transaction #1. If recording is enabled

Hi I'm brand new to objectdb and I'm trying to create an objectdb from a sample db via jdbc. The code all works and for a few thousand records but when I increase the number of records I ... .3.7_13. When you increase the number of records in a transaction ObjectDB has to use temporary

, we might sometimes loose the parent entity record . Well, tell me if am wrong : a) MyEntity contains 10 items ... behaviour. Sometime (a broken index ?) has for consequences a bad retrieve of MyEntity records . So some records just disappears ! I don't know if my index has been broken ( may i have some indications

; , but is is expected to decrease the performance. The  .odr files are related to the recording feature, which is disabled by default. support Support Thanks for the help.  As for recording , I ... . ObjectDB may open a new recording file for new transactions. Currently this happens when the database

, the records at the end continuously purge as the new ones come in(duplicate write, one to in-memory ... may be acceptable. Given I have a fixed DB size(800GB) with the need to purge oldest records as new

a record for a specific time. The hint property is: "javax.persistence.lock.timeout" I have a situation ... on the record , a subsequent access (which is a valid scenario for me) would instantly throw a: com

_ of database adds over a great period of time, and occasional querying.  No record in our database ... ? support Support Yes, we were tinkering with that value yesterday and I recorded some results.  I

big (import lot of data from other source). I didn't catch the size of record log file. For now I ... - attached screenshots. Record log is almost 50MB large. Database is about 73MB large. The strange

I do basic storage and retrieval of Record class. When I stress the retrieval/storage with Apache JMeter sometimes (at some requests) I get this exception.   [ObjectDB 2.5.0] javax.persistence.OptimisticLockException Optimistic lock failed for object entities. Record #'1405/838/2011/121

DESC, r.channelNumber DESC   In both cases we limit the result count to the first 50 records ... with 2800 records ) throws a "java.lang.OutOfMemoryError: Java heap space" exception. Emil prolancer Emil

and returns the records from the DB, but obviously not in order. Here is the stack trace of the exception ... ;   private Date startDateTime;     // Time stamp: start of recording

If you modify an ObjectDB Entity class will it be supported by a database set up using the old class? I already have an idea to iterate through a database, getting each record and then creating a record of the new type and replacing it, but I was just wondering if there is an easier way or

. We use the DB file to store about 540 thousand records . At this stage there is no problem ... and all appears to be fine. 6. Do an update, any update to any record and all appears to be fine. 7. Do a search

over a list of records gives ClassCastException. Problem occurs in both (2.4.6 and 2.5.6) versions. In 2.5.6 version one of the record suddenly switched its id type, although it was created 10 days ago

"), surname)); List allPersons = query.getResultList(); The results will contain records where name ... it an AND condition instead so that it will only contain records with both name AND surname as specified? I

.Member extends customer.Customer We have database records within each class type (Contact, Customer ... has no records either. However, looking at the DB-Size, it still has the same size? The DB-Server

tomee7.0.0SNAPSHOT,objectdb 2.6.4 The OneToMany Entities are filled with 40.000 Records and they have between 20-40 Columns. It takes over 50s to load all Project Enities that contains the OneToMany ... Relation at Example Datapoint (10.000 Recors). The API need for 50 Records 1 second to remove

here have been recorded carefully at every step, including Git tracking and tracking in a CMS web ... the odb log.       webel Dr Darren Kelly For the record , none of these problems happened

We have an application that runs on a single server in embedded mode to write server million records .  Is it possible to use the single server license for embedded mode use?  I've looked ... server that needs to write the number of records over the evaluation limit, it doesn't seem to fit

dalei The stack trace indicates using recording , which may not be supported with memory databases. Please try to disable recording . support Support

after index deletion. Changed default configuration (enabled recovery, disabled recording ). Fixed

256,000 records in 9 seconds (laptop). Pretty good!!!! If anyone is interested in my mistake, the fixed

after every persist . support Support Just for the record , the reason I am using flush at the moment

the target existence, if yes then accumulate, else insert a new record . String sQ2 = "select i from ItemList

that records athletic/swimming, etc results. The core of the projects works as expected. The problem is in

my app is that the 'count' of the records is different to the actual retrieval (both using the same

In Mysql, one can divide records by select * from ttt limit x,length. Then how to do it in Objectdb? gzdillon Lai Yang This is explained in the manual . support Support

Exception in thread "main" [ObjectDB 2.2.9_04] javax.persistence.RollbackException Failed to commit transaction: Attempt to reuse an existing primary key value (image.Meta:0) (error 613) at com.objectdb.jpa.EMImpl.commit(EMImpl.java:277) I check the db by explorer.jar, and find the only one record

. Possible immediate solutions that may help could be: Enabling recording , as the database can be restored from recording files. Enabling replication , generating a live backup database ... behaviour to enable us communicating that to our customer For my understanding - does the recording

Gergely Jakab The stack trace indicates an exception in using  recording . Assuming recording ... Support You were right. With recording disabled, the exception was not thrown. So any suggestion how it should work correctly with recording . jakab Gergely Jakab Could you please try build 2.8.8

? Do you have the full transaction history ( recording ) in an odr directory? If you have it the corruption may be reproduced ... at which point data sizes increased substantially. felixobjectdb Richard Szurgot Recording ... the additional stack traces do not provide more info and replaying the recorded transactions fail. I

if you enable recording it would be possible to recreate the problem by replaying the recorded transactions ... news! I'll let you know how it goes. In other news, I tried a run with recorded transactions

get any records by index. To help the troubleshooting I have attached the database example as ... out what fields were added. Also I have the full DB record history if that would help? Is it common ... Ben Steele The database record history may help. You are right about running the Doctor diagnosis

_points from Record as n where n.student.nume=:nume and n.student.prenume=:prenume and n.student ... ().begin() ; updateEm.createQuery( "update Record as n set n.lab_points=:points where n.student.nume=:nume ... .lab_points from Record as n where n.student.nume=:nume and n.student.prenume=:prenume and n.student

Richard Szurgot This may reflect a normal situation in which the last record in the recovery file is incomplete. In that case the last record is ignored (since it represents a transaction that has not

or recording directory if it exists, or copying, moving or transferring an ObjectDB database file without its recovery file or recording directory. Power failure when the database is being updated

. Please consider enabling recording . If we cannot find the cause now by analyzing the database ... for recording (we have heavy traffic all the time serving hundreds of clients, so the mode all option

I found that it is impossible to insert a record with @Unique byte[] var; after initial insertion of a single  record . Below is the exception:   Nbl3hQfe6LHayqZ7TQKivA== iWbldTBdz3etGCqHspWw3Q== Exception in thread "main" [ObjectDB 2.7.4_05] javax.persistence.RollbackException Failed

may be to enable recording :          This is rarely used, may slow ... on your production server. It records all the transactions, so playing them later may reproduce the issue and enable

Thomas Gregory Hi, we have a similar request. We are runing a Police records management system on top

synonym searches: SYN("database"); It would return records with "database", "datastore", "RDBMS

/sales audit records over a period of time quite easily in order to make good pricing decisions.... I

a bug in the new log based ( recording ) recovery from failure mechanism. Fixed a bug in finding

We would like to add to records start and end timestamp fields. When end field is null, it indicates the last version of this item. Few questions: in terms of performance, what would be faster, having a single timestamp and looking for the top1 when ordered by time or the above solution, looking

, disabled recording ). Fixed a critical database structure bug ( issue #187 ). Fixed a critical bug in