ObjectDB Database Search

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

, but I can't repair this right now, so I'm stuck with such a model. I'm trying to fetch 50 records

(symbol); } There are about 18 million DailyEntry records in the database that is sifted

after a few thousands records were added. I'm quite happy to remove this index as we don't really need

Hi, I'm trying to come up with the best approach for supporting some kind of hot standby for my master DB. Basically, I have the master DB running with recording and recovery enabled and have a number of applications connecting to it. I realize that I'm able to stand up read only replications

all the entities and indexes. The overhead of online backup and transaction recording (that are used

Hello, I've just installed ObjectDB and done some tests. I'm inserting 22k of records like 10k iterations of 22 linked entites. I've got indexes on Long id on every entity and additionally one entity have index on String column. Entities are not enhanced and inserts are committed in a separate

the smallest subset of unique records (like for example "isPublished" which is either true or false

) and there was no schema in the left panel. After repairing from this state with doctor, almost 53k records

", authentication.getPrincipal()).getSingleResult(); According to ObjectDB explorer, the record is stored as

Hi! I started to use ObjectDB Explorer to administrate a remote DB (on a server), but it seems to be very slow. The database is quite empty now, just between 5-20 records / entity, but it's still very very slow. That's the only thing that is slow on my server... How can I speed it up? zmirc Mircea

(ReflectionInvocationContext.java:163) at org.apache.openejb.monitoring.StatsInterceptor. record (StatsInterceptor.java:176

.openejb.monitoring.StatsInterceptor. record (StatsInterceptor.java:176) at org.apache.openejb.monitoring

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

instructions for reproducing this new issue? support Support I got this stack trace when enabling recording

correct results We had this problem on records created on 13 and 14 January, problem was detected

operations, and no ObjectDB operations are recorded . It would be be better to use a simple console

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

is called on iptAuditLog id: Before Saving Record into the Entity MAnager.=========="); } } Pojo

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

that  recording is enabled on the master side. If you are using an existing database

has a different persistent structure then the persistent structure that was recorded at enhancement. In

other languages. support Support and what happens with the following records I'm adding, ordering in

to use iterators with no concept of current record --but I digress--I got them working anyway). 4

the parameter value is correct, and there should be a matching record in the database, but my query returns

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

This was done few months ago and we just moved on. As far i remember the data records in the table

Hello, why delete from ... doesnt modify size of odb? Even in in embedded mode, and in server mode i use recovery, not recording mode. mastervoland Vladimir Sadovnikov When objects are deleted from the database their space is marked as unused and becomes available for future objects. The size

to transfering them to Java? Because there about 10^6 records . mastervoland Vladimir Sadovnikov

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

new records had been written): NoSuchFieldException: consultationProcessed com.objectdb.o

Given the following: Predicate isOwnedByUser = cb.equal(root.get("owner").get("id"), userId); Predicate ownerIsNull = cb.isNull(root.get("owner")); Predicate ownerMatchesOrIsNull = cb.or(ownerIsNull, isOwnedByUser); The isNull predicate will only match records when NOT inside the OR predicate

to generate values when the existing record is null. bhamilton Bruce Hamilton  so the only option I

Let's suppose we have two objects and one is the key to another: Language{id:Integer,language: String} Book{id:Integer, title: String, language: Language} This select works: SELECT b from Book b where b.language.language="en" // it returns some records But when I use the same condition

I have a Country entity that has a one-to-many relationship with the Cities entity, When I create the Country records with their respective cities, I have no problems, but when I want to visualize the cities, it does not show them to me, due to the internal error that is created when it persists

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

Support no my question was If i have PhoneNumbers["1234","567","45689"] in an record then "1234

I have tried using online back to test the backup feature.  It's been hour and I still don't see my backup file.  I have 1 million record in 1 table as a test.  https://www.objectdb.com/java/jpa/tool/backup How long does it usually take for a backup?  And are there no temp

the corresponding record must be found... Any help is much appreciated! ralfne Ralf Stefan Neumann

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

Added OSGi support. Added support of MEMBER OF for inverse (mapped by) collections. Changed logging of incomplete recovery records from WARNING to TRACE  ( issue #565 ). Changed main configuration elements from required to optional. Fixed the "Negative snapshot user count" bug ( issue #556

when all the database records had been deleted in a successful transaction immediately prior

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

I got exception. Source code in the attach.  If the number of records is less than 87, no exceptions. Exception in thread "main" [ObjectDB 2.5.3_03] Unexpected exception (Error 990) Generated by Java HotSpot(TM) 64-Bit Server VM 1.7.0_07 (on Mac OS X 10.9.1). Please report this error on http

No idea what happened.  A simple getResultList() opearation. DB table affected size is ~ 26000 records , physical DB file size is ~ 8.5MB Thanks for any help ! Leon log file: ------------------------------------------------------------------------------------------------------------------------ [2016

are not included as they are not recorded in the schema. support Support

This shows pressing an Entity and pressing Table view freezes the program, this is a remote DB not on local machine.  But it should not be this slow with 10 records .  The query is not slow, but if yo just open table view like in the video it's slow/freezes.   Trianglehead Json Error

that it should never happen. Anyway, if there are no records of it happening with version 2.8.4

with 79 million records . I don't know if it's because the size of the DB making the backup process

Added initial support of Record entities. Implemented a new query method:  containsAnyKey . Improved field type error and internal error messages. Improved the Doctor output. Fixed a bug in using inner classes for query results. Fixed an error due to to an unused type referencing a deleted