About Index

manual

JPA Entity Fields

Explains how to define and use primary keys in JPA, including composite and embedded primary keys.... side is not stored and calculated by a query. An index on the owner field may accelerate the inverse query and the load of the inverse field. But even with an index, executing a query for loading a field is relatively slow. Therefore, if ...

 
issue

again merger missing logs + objectdb exception

we are facing similar problems as we had before, in the log we have a lot of entries merger ... missing + an objectdb exception. Some objects in the system behave strange. This is a part of the log: ... [2017-09-26 12:16:14 #1222 store] SectionClassifier: SectionClassifier{238146996->merger[3309]-missing:1} [2017-09-26 12:16:25 #1223 store] SectionClassifier: SectionClassifier{238146996->merger[3309]-missing:1} ... ObjectProperty instance). Hopefully there is an index corruption that is caused by the nested section key wrapper problem, ...

 
issue

Large query parameter - out of memory

I have an entity object composed of an id, large data in the form of a string and the hashcode of the string as an index. The attached test saves 2000 of these objects, writing the data to a txt file as it goes. It then loops through the data from the file and queries for the entity id based on the data hashcode and the data itself. ... the form of a string and the hashcode of the string as an index. The attached test saves 2000 of these objects, writing the data to a txt ...

 
forum_thread

Internal objectdb error when open a database or open an entity manager

we get following exception when we open a database or open an entity manager   ... this report. The stack trace indicates an issue in the new index activation that was added in version 2.6.6 (probably when there are ...

 
issue

[ObjectDB 2.6.9] Unexpected exception (Error 990)

[2017-03-29 14:04:44 #1 client] [ObjectDB 2.6.9] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) 64-Bit Server VM 1.8.0_121 (on Windows 8.1 6.3). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: null com.objectdb.o.InternalException at com.objectdb.o.BYR.o(BYR.java:113) at com.objectdb.o.BYR.w(BYR.java:206) at com.objectdb.o.VUT.j(VUT.java:350) at com.objectdb.o.RST.C(RST.java:194) at com.objectdb.o.RTT.l(RTT.java:134)... Unexpected exception in page #36230484 entry #5: null Index Errors ------------ [1] Index cl.intelidata.jpaodb.Movil[id] requires rebuild. - has 142351616 ...

 
forum_thread

EntityManager.refresh takes a long time

EntityManager.refresh takes a long time for entity object Person in this code: ...  for these relationships, as possible. Index the owner side, i.e. add indexes to the fields that are specified in ...

 
forum_thread

TimeSeries and ObjectDB

Hi, I am using ObjectDB for storing TimeSeries (large ones) - when I get new points to add to the TimeSerie entity - I currently have to retrieve the whole timerserie since beginning of time, then add the new points, and then commit the whole timeserie again. I looked at Update queries - but they seem to be handling simple tasks - like multiply one field of the entity by a constant. More generally: 1- is ObjectDB suitable for large time series? 2/ If so - any example would be helpful - on how to organise the data. ... would not be required as the database would have some index map already (not sure what the right terminology is) - so do i really ...

 
manual

Database Explorer

Explains how to run and use the ObjectDB object database Explorer to view and manage Java/JPA/JDO objects visually. ObjectDB Database Explorer is a visual GUI tool for managing ObjectDB databases. It can be used to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases. This page covers the followi ...

 
manual

Database Explorer

Explains how to run and use the ObjectDB object database Explorer to view and manage Java/JPA/JDO objects visually. ObjectDB Database Explorer is a visual GUI tool for managing ObjectDB databases. It can be used to view data in ObjectDB databases, execute JPQL and JDOQL queries and edit the content of databases. This page covers the followi ...

 
issue

Server crash - Mismatch client-server protocol prefix

We've been having a problem where our ObjectDB server goes unresponsive every 2 days or so.  I've reviewed the server-side logs, and there are no events logged shortly before the crash.  Once the server gets in this state, it is unresponsive to bin/server.sh restart; I have had to reboot the entire server on which it's running.  The only recorded symptom is a client-side error (which fortunately gets auto-mailed to me): ... running with -Xmx1024m) and some issues with a particular index, which was also flagged when I ran the database doctor on a backup of the ... may be related. Please report again after repairing the index and increasing the heap size (-Xmx1024m may not be sufficient). ...