About Index

forum_thread

Weird behaviour with enhanced classes and embedded entities

Hi, I've found some weird behaviour in my project (www.tinymediamanager.org): Sometimes some entries of my ArrayLists with embedded entities are missing. I've hunted the problem down to an enhanced/proxied list in my entity which contains embedded entities and some .add(obj) are simply failing. Here is a small sscce which reproduces the issue: ... System. out . println ( "Not added index " + i + " in Thread " + id ) ; } ...

 
forum_thread

slow performance for a complex query

Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINCT $1 FROM CDI $1, Organisation $2, Organisation $3 WHERE ((UPPER($1.cdiId) LIKE 'THREAD14%') AND ((($1.parentOrgId='news') OR (($1.parentOrgId=$2.organisationId) AND ($2.parentOrgId='news'))) OR ((($1.parentOrgId=$3.organisationId) AND ($3.parentOrgId=$2.organisationId)) AND ($2.parentOrgId='news')))) I've also tried running the CDI query first and passing the results into the organisation query as follows: #1 2012-02-16 09:16 Hi, We have a query that is constructed dynamically, an example is like this: SELECT DISTINC ...

 
api-jdo

javax.jdo.Query

The Query interface allows applications to obtain persistent instances, values, and aggregate data from the data store.(Interface of JDO)

 
forum_thread

Occasionally slow requests in load testing

We are running load testing against objectdb version 2.3.7_18. The performance is generally OK, however there are quite a few "spikes" in the performance where we are getting a lot of very slow response times from the DB, around 10 - 15 seconds. Looking at the DB server process with AppDynamics we can see that most of the requests get stuck in one of 2 places: com.objectdb.o.PGC:w: line number 232 com.objectdb.o.LFL:U: line number 1068 Please see the attached callgraph examples for full stack trace examples. ... Check the active query. Maybe you have to define a new index or rephrase that query. If the query requires scanning of the entire ...

 
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

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

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

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

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