About index

release

2.2.9

... Fixed a bug in query plans that use an inherited index. Fixed an ArrayIndexOutOfBoundsException  bug in ... Improved cleanup and reusing space after index deletion. Changed default configuration (enabled recovery, ...

 
api-jpa

javax.persistence.criteria.ListJoin

The ListJoin interface is the type of the result of joining to a collection over an association or element collection that has been specified as a java.util.List.(Interface of JPA)

 
release

2.2.0

... 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

JPA-Query does not lead to any result

Hi, we have a database with a Entitiy inside which we want to fetch with a query. Normally that works without a problem, but in case of this database that query does not have any results. Can anyome help us what the problem is? SELECT FROM UserModelData usr WHERE usr.userName = 'admin' Attached are two databases, one where the query has a result and one where the query does not has any results. ... The query is executed using an index on field userName . In not-working.odb , the index looks: 0 - > UserModelData:"admin" "system" - > ...

 
issue

query.getResultList() throws ClassCastException

I modified the example code to include an index on the Point class like so:     @Index(members={"x","y"}) Then when I run the following query:     TypedQuery<Point> query = em.createQuery("SELECT p FROM Point p where p.x <= :x and p.y >= :y",         Point.class); I get the exception at the end.  I do not get an exception if I: ... I modified the example code to include an index on the Point class like so:     @Index(members={"x","y"}) Then when I run the following query: ... I do not get an exception if I: Use no index Index only on "x" Use an OR in the query ...

 
release

2.2.8

... 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

ArrayIndexOutOfBoundsException

Hi, I've been getting the following exception when trying to query ObjectDB in server mode version 2.3.4_05. ... 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Index Errors ------------ [1] Index com.contextspace.datamodel.attribute.AttributeValue[name] requires rebuild.   - has 280 entries instead of 0 [2] Index com.contextspace.datamodel.config.RAConfig[raId] requires rebuild. ...

 
forum_thread

Join performance in Objectdb

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 ... Page and Image are not annotated with @Id or @Index . In that case, executing the JOIN may require iteration over 160,000 ... 1, It is supposed that there is an implicit index for the @ID in JPA, right? 2, I add @index to each field of ...

 
release

2.2.1

... 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

How best to unbind all names?

My JDO application does inserts with binds, and then subsequently does bulk deletes using this code: ... field, which may be set as a primary key or as a unique index. This will also solve the orphan problem.   ... It is true that in ObjectDB 1.x the free edition had no index support. ObjectDB Support ObjectDB - Fast ...