About results

forum_thread

Doctor - high memory usage

Hi, Is it possible to reduce Doctor memory usage? Right now for recovering 67MB database, I need to set heap space to at least 450MB. Even then whole process takes ages. Optimal setting for this database is about 650MB. It's about ten times of size of database. ... 67895296 Mar 20 18:10 HomplexTool.odb_nonclosed and results: odb@devodb:~/objectdb-2.1.1_04/db-files$ java -Xmx650m -cp ...

 
forum_thread

InternalError on multiple AND and JOIN Query

Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1.contactDetails $2 JOIN $2.addresses $3 JOIN $3.attributeList $4 JOIN $2.phoneNumbers $5 JOIN $5.attributeList $6 WHERE ((($4.name='suburb') AND ($4.valueAsString='Los Angeles')) AND (($6.name='areacode') AND ($6.valueAsString='310'))) Getting: ... 0, Time elapsed: 1.35 sec <<< FAILURE! Results : Failed tests:   ... for the individual test results. [INFO] ...

 
manual

Online Backup

Online Backup enables backing up an ObjectDB database while it is in active use by applications. The ability to create a backup while the system is running is essential in applications and services that have to be available 24/7/365. An ObjectDB database can be backed up by simply copying or archiving the database file while the database is offline (i.e. when it is not open in an ObjectDB server and not in use by any application), since an ObjectDB database is stored as an o ...

 
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 + ... BY approveEmail DESC return different results. Query SELECT ( int ) approveEmail ...

 
forum_thread

mappedBy problem

If I put the mappedBy element to the @OneToMany, the owned side (the many side) will never persist ! for example @Entity public class Employee { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) public Long id; public String name; @OneToMany(targetEntity=Address.class,mappedBy="employee") public List<Address> addresses; }   @Entity #1 2010-06-12 18:03 If I put the mappedBy element to the @OneToMany, the owned side (the many side) will never persist ! for exa ...

 
issue

Pessimistic lock timeout - blocks indefinitely

I've attached a simple test which creates an object then kicks off several threads which each try to update the object. I'm using a pessimistic lock with timeout as follows: Bug Version: 2.3.1 Priority: Normal Status: Fixed Replies: 3 Type:  Bug ...

 
manual

Database Doctor

Explains how to use the ObjectDB object database Doctor tool to diagnose and repair database files and damaged Java/JPA/JDO objects.... file (e.g. my.odb as shown above). Diagnosis results are printed to the standard output. Running ObjectDB Doctor ...

 
forum_thread

Getting sales quantity per country with a query, an idea anyone?

Hi, For the purpose of some charts on a dashboard for our ERP i would like to get the list of countries and the sales quantity for each of them. I am pretty sure it is somehow possible to get that directly from a more or less complex query but i failed to find it; Does any have an idea? The entity (we call it OrderData) contains fields and other entities related to an order, fields we are interrested in are  buyerCountry and orderPrice. #1 2015-07-12 19:18 Hi, For the purpose of some charts on a dashboard for our ERP i would like to get the list of countries a ...

 
forum_thread

Vacuum - Reclaiming Unused Space In Odb

I was curious if you could assist me with a challenge we are having with our objectdb database.  Our odb files are about 50Gb in size and are written to about a million times a day with both adds and updates.  This is creating a lot of unused space in the database that we are wanting to reclaim.  Other database vendors provide a vacuum process to allow dumping a database to a flat file (basically a sql dump) and reload.  Is there a capability in ObjectDb to provide a vacuum?  The online backup feature appears to copy the dead space as well so isn't performing... a couple times on some larger database we have.  The results were somewhat surprising.  Neither execution of Doctor found any ...

 
issue

InternalException

I'm getting a new InternalException (see below). No repeatable example as yet but will work on that and let you know as soon as we have one. If there's anything in the exception which could help us narrow down the problem please let me know. Bug Version: 1.04 Priority: High Status: Closed Replies: 9 Type:  Bug ...