About index

release

2.2.6

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
forum_thread

java.lang.NullPointerException when using ORDER BY

We are using ObjectDB 2.5.1_04. The following query causes an internal null pointer exception: SELECT r FROM RecordingMetaData AS r WHERE ((r.mapToCli != '192.168.10.200:9085' AND r.callDirection == 0)) ORDER BY r.startDateTime DESC If we remove the ORDER BY part, the query completes OK and returns the records from the DB, but obviously not in order. Here is the stack trace of the exception: ... related to your other report , i.e. using the composite index with the unexpected entry, so both issues may be solved together. ... to me try ORDER BY with a field that is not part of any index. I can reproduce the problem if a run a query where the ORDER BY filed is ...

 
issue

Negative snapshot user count exception

I found the following stack trace in my log files; it's cropped up a number of times: ... see this error message after eliminating the memory and index issues? ObjectDB Support ObjectDB - Fast ... inadequate memory, which I am sure precipitated additional index problems; I resolved the memory configuration on Sunday night.  I ...

 
release

2.2.7

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
issue

java.lang.ClassCastException: com.objectdb.o.SCU cannot be cast to com.objectdb.o.PRU

Error in production urgent [2017-05-19 13:34:09 #14 server] ... There is a corruption into index when I tried to obtain an object that non exist into database. This was ... but if you have more information about the cause of the index corruption we will be happy to explore this issue further, ...

 
forum_thread

How the sort order (in queries) works for non english letters?

We are considering using ObjectDB in  project where target audience are czech speaking people (we are Czech company). How the sort order works for international (for us 'czech') letters? Does the ordering respects the national requirements? Thank you for clarification ... ... nice if one could just specify they locale as part of the index definition or the ORDER BY clause, so the sort uses the correct collation ... you for this useful link. It makes sense to add index definition support to JPA and include also support of different types of ...

 
api-jdo

Indices.value

The indices(Annotation Element of javax.jdo.annotations.Indices)

 
forum_thread

Query perfromance problem

Hi, I was playing with paging and sorting recently and after trying few different aproaches got some strange behavior from ODB. First of all, I will show you results from page rendering times, but trust me - when debugging application, getting data from ODB takes a long time in one case. Anyway, one of my methods in DAO looks like this: ... ms Refreshing this page with any other column for index with @Index set on it, lowers this time do 1-3 secodns. 2011-03-11 13:08:30.897 ...

 
release

2.2.5

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...

 
release

2.2.4

... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ... Fixed a query execution bug when index with null keys is used. Fixed a bug in tracking field ...