About Index

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

 
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

Set timeout for BatchQueryItr

Hello Support, For an unknow reason, some of my object query never finish ( deadlock maybe ).  My tomcat temp directory is full of "BatchQueryItr" files. I can't found the origin of the issue but i wonder if it's possible to put a timeout for too long query. Regards, Xirt #1 2016-07-25 19:15 Hello Support, For an unknow reason, some of my object query never finish ( deadlock maybe ).  ...

 
forum_thread

client server set up and load

Hello All, Can objectdb handle client - server connections from over 200 users? Can it be efficiently used in client-server mode? Code examples where possible will be appreciated. Thank you. Regards #1 2015-09-01 14:38 Hello All, Can objectdb handle client - server connections from over 200 users? Can it be efficiently use ...

 
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

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

 
forum_thread

Connection performace after upgrade to objectdb 2

Hi, I have a problem with objectdb 2 when I tried to get the PersistenceManagerFactory and PersistenceManager : In objectdb 1 : PersistenceManagerFactory pmf = JDOHelper.getPersistenceManagerFactory(getProperties(physicalPath, objectName), JDOHelper.class.getClassLoader()); takes only 3ms PersistenceManager pm = pmf.getPersistenceManager(); takes 40ms However, with objectdb 2, the same instructions take respectively : 257ms and 238ms which is very expensive. #1 2012-12-10 17:32 Hi, I have performance problems with objectdb 2 when I tried to get the PersistenceManagerFactory and Per ...

 
forum_thread

OutOfMemoryError on search after update on DB created with DB Doctor

It looks like there may be an issue with the DB files created with DB Doctor in recovery mode. This is the scenario that results in the OutOfMemory exception problem (using Object DB 2.5.4_04): 1. We instruct Object DB to create a 1Gb DB file on initial start-up using: <database> <size initial="1024mb" resize="256mb" page="2kb" /> This happens as expected. ... mode to generate a recovered DB file. No schema (and index) changes - just testing the use of DB Doctor to check DB files during ...

 
forum_thread

selecting objects that have a particular key/value in persistant HashMap

Hi, First post here and exploring ObjectDB.  I have an class Person which has a HashMap<String, String> called 'pMap' as a persistable field.  I am able to create Person objects and persist them as expected. ... If you need a more efficient solution (using an index), please look at this forum thread . ObjectDB ...