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

Reading 1.x odb files in ObjectDB 2.x without upgrading

Hi, We have a problem in the backward compatibilty in our software as once we have migrated object db odb file from version 1.x to 2.x, user is unable to open the odb files in the application which is having object db 1.x installed. Is there any way to read odb files from 1.x in object db 2.x without upgrading it ? Or user can see the content in read only mode without upgrading it ? Thanks ... i have observed that coverter is not giving the expected result. Once i found that objectdb 1.x was having one row but after ...

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

 
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: ... the find again. I'd expect this to achieve the same result as querying with a timeout (albeit much less efficient!). ...

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