ObjectDB Database Search

WHERE YEAR( record _date) = 2009 GROUP BY YEAR( record _date), MONTH( record _date) or maybe something like this: SELECT COUNT(id) FROM stats WHERE YEAR( record _date) = 2009 GROUP BY DATE_FORMAT( record _date

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

master and verifying it works as expected and the DB's are recording from the very first transaction ... ://www.objectdb.com/database/forum/346 even though this shouldn't be relevant since I have recording ... without too much pain, assuming recording is enabled from the start. bensteele Ben Steele I managed to fix this by

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

; , 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

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

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

, 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

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

.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

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

"), 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

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

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

. 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

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

_ 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

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

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

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

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

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

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

, 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

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

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

to get records that have part of the strSupPart field from the Embedded class in the ItemDB class, my code looks

Hi, From time to time we are getting following error in our project when trying to insert/update a record in database [ObjectDB 2.4.6_13] javax.persistence.RollbackException 10:29:14,880 ERROR [stderr] (http--10.23.3.98-8081-5) Failed to commit transaction: Object 'pbdmodel.impl.OrgJedinicaImpl#8

. But when updating(merging existing record ) somehow the rotation overrides the position. I

When a transaction ID is specified as a second argument the Replayer applies recorded operations only until that specific transaction is reached. support Support

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

on power failure:  Recovery File and  Recording . If you try a 'kick the plug

SELECT count(e) FROM Meta e, ImageNet i, Page p WHERE e.idImage=i.id AND e.idPage=p.id; So simple a command cause me half an hour and is running now! Each table has about 160K records . What formula can predict the time for such counting? TIA gzdillon Lai Yang Now, after 2 hours

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

HI I am trying to use @PrePersist annotation in my project.This application is using struts2 with jpa combination .so can u please tell me how to us this annotaton before save the record into persistence.   claerly how to use in pojo and in action class rameshanem rameshanem Please read this manual page . support Support

which acts as archiving device for processing and storing logs, records and transactions. Hardware

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

_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

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

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

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

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

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

. 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

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

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

the entire server on which it's running.  The only recorded symptom is a client-side error

will be produced. support Support The orphan Position records are there because i deleted some Units with a DELETE