About between

forum_thread

Composite indexes

Hi, I read your manual about defining Indexes for JPA Entities (http://www.objectdb.com/java/jpa/entity/index), but I still have some problems understanding how and when should I use them.   Let's start with some example then. Assume we have an entity that represents an interior design image, called Inspiration : ... Yes. They are useful when the query includes navigation between entities (directly or using JOIN).   ...

 
forum_thread

Open several objectdb databases the same time

We tried to open objectdb databases from application and got following error: ... Also, I didn't face any speed differences between EMBEDDED & SERVER modes, but both methods should be profiled for ...

 
forum_thread

Password Protect Database File

Is there a way to encrypt the odb file so that if hackers somehow steal it they cannot access the data without some kind of password? I would imagine accessing the database from java could just have another connection parameter while accessing from explorer.jar/exe would need to prompt the user for a password for encrypted odb files. ... As explained above, there is no real difference between internal ObjectDB encryption (which is currently not supported) to ...

 
issue

Use temporary files to enable very large transactions

We have transactions in which many objects are created. These objects are no longer needed in the current transaction after creation. Unfortunately, we will receive an OutOfMemory exception because the objects are kept in the first level cache of ObjectDB. In the forum thread http://www.objectdb.com/database/forum/921 on post #4 you wrote, that ObjectDB should support very large transactions in further version. Can you implement it that ObjectDB used temporary files? ... the heap dump information which is a different view between flush and clear. After flush and clear we have invoke a full GC and ... explain to us the difference of memory and file-size usage between in-memory(<2GB) and temporary file(8GB)?   ...

 
forum_thread

An ArrayIndexOutOfBoundsException with nested entities and enhanced entities

We have a new issue like the issue in the forum task http://www.objectdb.com/database/forum/1075. This issue is very important for us, because we want to create a release soon. ObjectDB version: 2.6.8_06 All our entities are enhanced. There are nested entities in following hierarchy: @Entity @Access (AccessType.FIELD) public abstract class ModifierImpl extends DataTypeImpl implements Modifier { ... of the database). We see no connection between the database and the enhanced classes. But perhaps, not quite ...

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... collection. There is, however, one important difference between the result collection and other Java collections. Rather than relying ...

 
release

2.7.2

... Fixed very slow processing of a composite BETWEEN query. Fixed NullPointerException when using AND ... than 2GB. Fixed a bug in running queries between flush and commit. Fixed a deadlock ( issue #62 ). ...

 
forum_thread

@ElementCollection query returning extra result per element in collection

Hi, ... It may help understanding the difference between EclipseLink and ObjectDB in this case. ...

 
release

2.4.1

... than 2GB. Fixed a bug in running queries between flush and commit. Fixed a deadlock ( issue #62 ). ...

 
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. ... + "BETWEEN :fromD AND :toD " ...