About result

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. #1 2011-03-22 22:08 Hi, Is it possible to reduce Doctor memory usage? Right now for recovering 67MB database, I need to set h ...

 
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: #1 2011-07-22 01:36 Hi, Using objectdb 2.2.8_06. Running the following query: SELECT DISTINCT $1 FROM CDI $1 JOIN $1. ...

 
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.... be in progress. The backup query returns as a result a Thread instance that represents the backup run. This thread can be ...

 
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 + #1 2013-08-27 12:52 How to convert a boolean to an int in the query? I have five parameters of type boolean in the entity object ...

 
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... I followed your post and I got the correct result. But the standard JPA should establish the link automatically! Is the ...

 
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 #1 2016-03-02 06:42 I was curious if you could assist me with a challenge we are having with our objectdb database.  Our odb fil ...

 
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. The ObjectDB Doctor tool provides two related services: Diagnosis and validation of an ObjectDB database file Checks a given ObjectDB database file, verifies that it is healthy and valid, and if the file is not valid (it is c ...

 
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

JPQL JOIN FETCH Error

Hello I get an error when executing the following JPQL query: ... OutOfMemoryError may be related to this issue  (result of using many variables in the query, since every JOIN, including ...

 
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. ... I think that such an exception is possible as a result of schema change, in which id fields are removed. Notice that changing ...