ObjectDB Database Search

ObjectDB can record its internal engine operations in special binary recording (journal) files. Recording is enabled by default and can be disabled in the configuration . The ObjectDB Replayer tool can apply recorded database operations on a matching database backup (if available). This ability

Database engine operations can be recorded in files and later replayed using the ObjectDB Replayer tool. Recording provides an alternative (which is sometimes more efficient) to recovery . When recording is enabled and recovery is disabled, recorded operations are used to automatically fix

Hi, I am enabling recording at ObjectDB server...  The database is quite busy updating state of objects. I am observing that the recording directory (*.odr.. 19GB!!) is keep growing ... the size or history of recording ? Is there any setting in configuration file? Thank you  

Hi, I get the following when ODB starts in embedded mode: Replaying recorded requests... then I ... ;      Questions: 1) Why am I seeing this if I've set recording enabled to false? 2 ... have recording sets when that is turned off in the config file? b) should I be worried about so many

need to delete  records in both tables (TransportationEvent and Conclusion) here i am trying to delete conclusion table records like bellow: removeConclusions(conclusion.getId()); public void ... can some one help me how exactly i need to use this to delete the records from Conclusion

Hi, does anyone have experience with database with more than billion records (ie. more than 1000 million records ) in one table. What is the limit of ObjectDB and is the database still fast. We are planing to do an application which handles document records and there metadata. peric.emil Emil

Hi, I know a single command in MySQL can find repeated records : Select * from TTT t where id in ... query from 430,000 records and put them into hashmap, finally it cost one hour and failed: Exception in ... follow your suggestion, implement the first query; it will not succeed with 480,026 records .(#3

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 ... .DB.writeToDB(DB.java:39) DB.DB.write2DB(DB.java:59) DB.DBRecorder. record (DBRecorder.java:107) DB

When we need to run doctor on some DB file, which is used on ObjectDB master server. I suppose, that we need in that case delete recording data, and copy fixed file manually also to all slaves? Or ... ) database for the slave to start with and with no recording files. support Support

Hi  I have a db of around 1.6 lakh records . But now am getting some unexpected error when accessing some of the entities. And when am fetching all the records using objectdb explorer its showing exception. I have diagnosis the db with objectdb doctor but not find any error. Please check

Hi!, Does anyone know how I can use this type of Query with Like and that does not give an error when you search in an Integer type field? I have been forced to change the "CodigoTienda" record in my entity from an Integer type to a String type. Greetings. televoip2 Antonio Gonzalez Bonilla

Hello.  What happens when both Recover and Recording are set to true?  Trianglehead Json Error In that case both are expected to work. They are used for different purposes. support Support

Getting this error when fetching records from mem db.

objectdb got hang after fetch some record.

Not able to update records

Record is not clearing properly on remove

) is that in JPA data is represented by classes and objects rather than by tables and records as in ... representation in the relational database (as tables and records ) and the representation in the Java application

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

or convert objects to records / records to objects using SQL or ORM, as opposed to when using

(but not in embedded mode) can function as a master database in a cluster.  Recording

is that SQL works with relational database tables, records and fields, whereas JPQL works with Java

an email and for other related website statistics (for example, recording the popularity of a certain

that ability and require multiple tables, multiple records and join operations in order to support

or NetBeans . Forget relational databases, JDBC, drivers, tables, records , ORM tools and mapping

- supports full transaction recording and replaying . Automatic diagnosis and repair of corrupted

the following exception every time an attempt was made to add a record to the DB.   2015-10-28 13:51:35,552 ERROR [Sniffer Provider Timer] - Failed to add Recording (meta data) to the DB [ObjectDB 2.5.5 ... ) at com.arunta.dom. recorder . Recorder .addToDatabase( Recorder .java:2137) at com.arunta.dom. recorder

enable " recording " on slave and then restart, I will get: java.lang.NullPointerException at com ... information about recording mode and replication in order to figure out how can I clean unused recording ... get over a million transactions. mastervoland Vladimir Sadovnikov You should only enable recording for the master

This shows how hard it is to add a record with explorer.  When you add it, you have to find it in the list, if the list is real big you're in trouble., and since new object has no IDs you can't really search for it easily.  Should pop up a window to let you add values before adding

Not sure if we should post this here but there're a "Website" Marker type for issue so I'll try that. It'd be great to see more records on your website at once (i.e. in the task tracker, forum etc. etc.) and to customize that view how many items per page one would like to see.  quasado

and in 100K records it will show up in about 1.5K records with no obvious pattern. Also it appears ... has 9 records and as you can see the startTime parameter is set to "31 Dec 1969 hh:mm:ss ... , but see further explanation of some odd values below. Here is the data used to create the 9 records : 2015-12-19 18:12:53,000

to stop master, clear all recording files, switch to all mode: Then I stopped also the slave Removed ... . transaction recording of the master is available from the moment of the last slave database update. support Support 1. Thank You 2. Do you have somewhere written, how the recording works in

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 ... , each running in a different thread: 1. The first EntityManager only adds records to the DB at a rate

 odb file and inserts 200 records at a time. The transaction obtained from the PersistentManager is commited after persisting 200 records and then the same transaction object from the same ... PersistenceManager instance (com.objectdb.jdo.PMImp) The application tries to persist records

with large records sets. Our issue is with tables with 100.000+ records . Everything was OK when we had few thousand records . We have a simple SELECT statement which selects from a table with 100.000+ records by UserID atribute, tables have from 5 to 20 atributes. Usualy the results range from

database. Their size and number of records are almost identical. When running production database in ... ObjectDB explorer on complete database which has 12000 records takes 30ms which we think is very good ... server from the Explorer. • Result 1: aprox 20000 records in 30ms • Result 2: 14000 Document

: start of recording in local time zone private Date startDate; // Date: date part of startDateTime ... = startTime; }   When adding records to the DB close to time when a clock change is expected ... the attached DB) to the DB:   Record 1:     startDateTime = Sun Oct 25 02:00:25 CEST 2015

, there are two Chapter records (usually added in sequential id) on the Chapter table when viewed in ... to the Book entity ON THE SERVER SIDE, then the Chapter table is OK (no duplicate records ). I ... , when prompted first enter:     1 + enter    to persist a Book record to database

(); emf.close(); } public void storeRecord( Record r) { em.getTransaction().begin(); em.persist(r); em ... in order to persist records .  For example : @EJB RecordDao recordDao; recordDao.storeRecord ... is to retrieve records from database using : Record r = em.find( Record .class, recordNo); The issue (error

. the searchString is always decorated with %searchString%.  The Person object can contain many Record ... applicable field (String) of each element of the List of Records (see pseudo code).  //using MetaModel Expression records = root.get(Person_. records ); Expression param = builder.parameter(String

to it. The client program can connect to the server and query to get all the records ... records but only the latest stored record . I tried to run database explorer on the server machine and able to see all the records including the new stored record . The trick is, after I ran the database

by u.name When the name starts with "normal/english" character, records are ordered correctly. But when it starts with language specific character like 'Č', these records are placed after records with normal charaters. So records with 'Č' are after 'Z', but this is not correct, because 'Č

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

with tables, records and SQL in addition to the application's classes and objects. ObjectDB is JDO ... . Most other JDO implementations map classes and objects to tables and records in an RDBMS. Using ... , you can forget relational databases, tables, records , fields, SQL, JDBC and drivers, and focus your attention

. Example: @Entity @Table(name="CUST", schema=" RECORDS ") public class Customer { ... } Since: JPA 1.0

" + propertyClassName + " AS property, " + recordClassName + " AS record " + "WHERE property.uid MEMBER OF record ... works as expected. The above exception occurs only when the Set record .properties contains more than 20.000 elements. The field 'properties' (query: record .properties) of CoverageRecordImpl is a list

, but we expected only one verdict object: Although there is only one record which has an executionConfig with uid = '23A' the query engine ignores this condition and select all records . SELECT DISTINCT ... .internal.dmos.execution.ExecutionRecordImpl as record , com.btc.ep.simulation.bl.internal.dmos

then or later. If you could run the system for awhile with recording enabled then if this happens again we may be in a position to reproduce the problem by running the recorded transactions. support ... week in a state where the fix is active ? we are probably not able to use the recording as

. New database copy is ready at: db/smartcal.odb.fixed I enabled Recording so next time I will be able to attach a record file as well. Maybe this will help investigation. Thanks, Markus doppelrittberger ... and the recording . There are currently no other reports of database corruptions from other users

(ReflectionInvocationContext.java:164) at org.apache.openejb.monitoring.StatsInterceptor. record (StatsInterceptor.java:180 ... ) at org.apache.openejb.monitoring.StatsInterceptor. record (StatsInterceptor.java:180) at org.apache.openejb ... .StatsInterceptor. record (StatsInterceptor.java:180) at org.apache.openejb.monitoring.StatsInterceptor

. 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