About Index

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

 
forum_thread

"Automatic" Auditing

Any ideas around how I could do "automatic" auditing of changes to objects? (An equivalent to Hibernate's Envers) Thanks. Michael. #1 2011-02-22 06:10 Any ideas around how I could do "automatic" auditing of changes to objects? (An equivalent to Hibernate's Envers) ...

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

 
forum_thread

Vs. EHCache

Hi, I realize this is kind of like an apples vs. oranges comparison, but I would be interested if you have any performance information vs. something like ehcache with a persistent store. I'm currently evaluating for a simple schema to persist only 1 or 2 types of entities (but possibly 10k-100k instances) with simple index based queries which imagine both products could probably solve.... of entities (but possibly 10k-100k instances) with simple index based queries which imagine both products could probably solve. ...

 
issue

InternalException using 2.3.7_12

Sorry can't shed any light on this, other than the code where this came out of, worked fine with 2.3.7_02. I had to upgrade to 2.3.7_12 to pickup the fix for wildcard search on index, and now get this. [ObjectDB 2.3.7_12] Unexpected exception (Error 990)   Generated by Java HotSpot(TM) 64-Bit Server VM 1.6.0_21 (on Linux 3.0.0-16-generic). Please report this error on http://www.objectdb.com/database/issue/new com.objectdb.o.InternalException: java.lang.NullPointerException: null java.lang.NullPointerException... to 2.3.7_12 to pickup the fix for wildcard search on index, and now get this. [ObjectDB 2.3.7_12] Unexpected exception (Error ...

 
forum_thread

Pessimistic Lock Timeouts setting

Hi,   I realise that JPA2 doesn't necessarily define a standard API way for Lock Timeouts. However, there is a standardised query 'hint' that can be setup to make the underlying DB lock a record for a specific time. The hint property is: "javax.persistence.lock.timeout" ... counter (which is used to track separate customers product index) - and my test case is failing here. The issue is that once the ...

 
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

How to convert a boolean to an int in the query?

How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object - approveEmail, approvePhoneNumper, ... I can not sort them ORDER BY approveEmail, approvePhoneNumper, .... because the parameters equivalent. I want to sort them in the query by their sum ORDER BY (approveEmail + approvePhoneNumper + ... ) But I get an exception com.objectdb.o._PersistenceException: Invalid operand type boolean for operator + ... field would be much more efficient (you can also use an index on that field to improve performance), and this solution is available ...

 
issue

Unexpected exception (Error 990) on find

I have a huge amount of inserts/updates and after a about 850.000 Entities I got the following error: ... Unexpected exception in page #203864 entry #2: null Index Errors ------------ [1] Index local.jpa.entity.ebene1a.MyEntity[assignment] requires rebuild. - has ...

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