About join

forum_thread

Query becomes slower on moving from ObjectDB 1.x to ObjectDB 2.x

Hi, I upgraded the odb file using converter.jar which is having 15943 entry. Previously, with object 1.x, the same query was getting executed within an seconds and now the same is taking around 40 seconds in object db 2.x I have build the query using the follwoing Query query = persistanceManager.newQuery("LogEntryAttrebuteImpl.calss", "typeIndexes.contains(this.type) && logEntryIdList.contains(this.logEntryId)"); #1 2012-09-07 15:06 Hi, I upgraded the odb file using converter.jar which is having 15943 entry. Previously, with object 1.x, ...

 
forum_thread

Eclipse plugin problem (using ObjectDB as a separate bundle)

Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest in the 2.2.8.01 release of objectDb. However I still get this error.   Here is my scenario (Groovy 1.8 and Eclipse 3.6) used. I have a com.epimss.lab.data.toxicology.TherapeauticDrugScreenRqst. Nested in this class are the following two classes: com.epimss.lab.data.misc.OtherRqst and com.epimss.lab.data.misc.RequestDateAndNumber. #1 2011-07-11 15:49 Hello support, I have seen multiple attempts to correct similar errors as in the title above - the latest ...

 
issue

JPQL support for Maps (JPA 2.0)

JPQL 2.0 introduces the ability define FROM variables for map keys and values. Currently ObjectDB supports FROM variables for collection elements and FROM variables for map keys and values are expected to be supported in future versions. ... Query : "SELECT s FROM Session s JOIN s.data d WHERE VALUE(d) = :value" Object : public ... yet. Try: SELECT s FROM Session s JOIN s . DATA d WHERE d = :value ...

 
forum_thread

find() cost unreasonable time!

Hi, I make a full binary tree of 4095 node, I check the first 9 node, but the root cost 24 seconds, why? Result: #1 2011-06-29 12:58 Hi, I make a full binary tree of 4095 node, I check the first 9 node, but the root cost 24 seconds, why? ...

 
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 #1 2013-04-30 15:49 Hello, I have an entity E with an attribute which is a collection of entities (one to many relationship) ...

 
forum_thread

Suspected memory leak

Hi, We are running soak testing with Object DB and it is showing signs of memory leak: used memory is growing overtime until Object DB JVM fails with OutOfMemoryException. Object DB is running in a separate JVM. All the config is attached. We are continuing to investigate this and will create memory dump next time this happens. In the meantime, could you please check if there is anything wrong with our configuration? Kind regards, Natalia. #1 2012-01-22 21:46 Hi, We are running soak testing with Object DB and it is showing signs of memory leak: used memory is gro ...

 
forum_thread

@OneToMany(fetch = FetchType.LAZY) list is always null

Hello. @OneToMany(fetch = FetchType.LAZY) doesn't work when using EJB or something else related to J2EE. parent.getChildren() returns null. Here is a simple example: Bean: #1 2014-06-05 20:19 Hello. @OneToMany(fetch = FetchType.LAZY) doesn't work when using EJB or something else related to J2 ...

 
forum_thread

Failed to commit transaction: Attempt to commit a rollback only transaction

Anyone know what this means?? Suddenly cropped up.   Failed to commit transaction: Attempt to commit a rollback only transaction (error 613) at com.objectdb.jpa.EMImpl.commit(EMImpl.java:271) at javax.jdo.Transaction$commit.call(Unknown Source) #1 2011-05-24 22:22 Anyone know what this means?? Suddenly cropped up. Failed to commit transaction: Attempt to commit ...

 
forum_thread

Performance issues on aggregate query

we are using this aggregate query to collect some data: ... from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2  INNER JOIN o.properties p3 INNER JOIN o.properties p4 INNER JOIN o.properties p5 ...

 
release

2.5.4

... and maps of invalid types. Changed JOIN FETCH to act as LEFT JOIN in path expressions. Updated the PDF manual. ...