About Index

issue

ClassCastException thrown when running count query

Hello! Attached you find a full stacktrace. The query was: ... provide more information, particularly: Index definition for the fields in the query. Log of the query ...

 
release

2.0.1

Release date: 2010-10-05 Download (3.39 MB) Binary:  objectdb-2.0.1.zip ObjectDB 2 is already in use in production in several applications and is ...

 
forum_thread

can removing an entity throw an exception if the entity is in use?

Suppose you have an entity @Entity class A { ... } and other entities with references to A.   e.g. @Entity class B { A a; // explicit reference to A List<A> list; // list of A's Set<A> set; // set of A's Set untyped; // general collection that may include A's } Objectdb allows me to remove an instance of A, even if a managed B has some reference to that A. When I then find the B instance and try to reference the A, I get an EntityNotFoundException. #1 2011-05-12 11:21 Suppose you have an entity @Entity class A { ... } and other entities with references to A. &nbs ...

 
forum_thread

Optimistic locking: prevent version increment on entity collection attribute

Hello, I have an entity E with an attribute which is a collection of entities (one to many relationship) with an optimistic locking strategy supported by a version field. Is it possible to prevent the increment of the version of entity E when entities are added to or removed from the collection? Something like the equivalent of @OptimisticLock(excluded=true) in Hibernate? Thanks, Farid ... because it will require executing a query. Adding an index on the owner side could make this query run faster. ...

 
forum_thread

A bidirectional OneToOne association with a shared primary key

Hi, In Hibernate, it is possible (using Hibernate specific annotations) to define a bidirectional @OneToOne association that has a shared primary key, example: http://fruzenshtein.com/bidirectional-one-to-one-primary-key-association/ ... is more common, and you may want to set an index on the field to accelerate traversing in the other direction. ...

 
release

2.1.1

Release date: 2011-03-10 Download (3.89 MB) Binary:  objectdb-2.1.1.zip You should start by following a  tutorial or reading the manual ...

 
forum_thread

CASE WHEN...THEN...ELSE...END not working using JPQL/JDOQL

When I try to use the "case...when...then...else...end" like in the following query "SELECTCASE WHEN g.name="a" THEN "e" ELSE "o" END g from Guest g", I get the issue: Unexpected query token 'CASE' SELECT  ==> CASE <==  WHEN g.name="a" THEN "e" ELSE "o" END g from Guest g Have I mismatched something or is it an issue with ObjectDB? Anyone could help me on how to use the "case" in JPQL? Thank you in advance. #1 2016-07-29 06:59 When I try to use the "case...when...then...else...end" like in the following query "SELECTCASE WHEN g.name="a" T ...

 
forum_thread

ORDER BY problem, when String starts with language specific character

Dear all, I have a problem with ORDER BY clause. I have a simple query: select u from User u order 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 between 'C' and 'D'. ... field to the entity class and maybe even an index on that field (this will also keep your code JPA portable). ...

 
release

2.0.0

Release date: 2010-09-26 Download (3.39 MB) Binary:  objectdb-2.0.0.zip ObjectDB 2 is already in use in production in several applications and is ...

 
release

2.1.0

Release date: 2011-02-23 Download (3.89 MB) Binary:  objectdb-2.1.0.zip You should start by following a  tutorial or reading the manual ...