About between

forum_thread

Multi-tenant setup

Hi, does anybody have experience with multi tenant setup of objectDB. For example using multiple schema or multiple database. How to handle connections between app (Jboss Wildfly) and pass query request to appropriate database, how to dynamically add new database or schema. There are lot of discussions on how to do it with hibernate Thanks     ... schema or multiple database. How to handle connections between app (Jboss Wildfly) and pass query request to appropriate database, how ...

 
forum_thread

Calculating age in query?

Hi! I've got an issue: I have a birthdate as java.sql.Date and a separate field int age. However, of course the age is not accurate because it gets set only once. So what's the best bet (JPA Standard way) to solve the issue of accessing and filtering by an age (having a birthdate) in a query? thanks! Alex ... SELECT p FROM Person p WHERE p . birthDate BETWEEN : FROM AND : TO The values for the FROM and TO ...

 
forum_thread

ObjectDB data migration/extraction

Hi What is the way to extract data from ObjectDB to relational databases (Oracle). We need to feed an Oracle database with data for reporting/datawarehosing. Should JPQL be used or is there some tools to do it. Thanks. ... You may consider using JPA in order to migrate data between ObjectDB and Oracle. By using a JPA implementation to access your ...

 
manual

Collections in JPQL and Criteria Queries

Shows how collections and maps can be used in JPQL queries.... is contained in a collection. JPA distinguishes between the MEMBER OF operator, which should be used for checking a ...

 
api-jdo

javax.jdo.identity.IntIdentity

This class is for identity with a single int field.(Class of JDO)

 
api-jdo

compareTo(o)

Determine the ordering of identity objects.(Method of javax.jdo.identity.StringIdentity)

 
forum_thread

Duplicatable and Disposable JPA Repository for Unit Testing

Hi Folks, I seek an in-memory JPA implementation which can be easily instantiated, populated, and then duplicated for use in separate tests.  Tests might be JUnit or Fitnesse based.  There is no reason for file-system storage (preferably there would be none).  The ability to "duplicate" the populated repository is pretty important, as this allows individual tests to execute quickly (very little spin-up time and no need to pre-populate the db) and to execute without side-effects from other tests (db instance is not shared between tests). ... side-effects from other tests (db instance is not shared between tests). Is this use-case appropriate for ObjectDB? Many ...

 
forum_thread

Query results are not up to date for entities, not primitives

When using the CriteriaBuilder to query, the retrieved list are not refreshed according to the latest updates. But, when using the JPQL Query, the list are refreshed. What is the problem? ... results from the cache. There is no difference between criteria queries and string based JPQL queries regarding the cache (and ...

 
forum_thread

Problem with merging / persisitng objects with @Embeddable field

Hi, After migration to version 2.4.2_01, I have noticed a strange problem with persisting object with field that contains @Embeddable object. Please check attached exception. Relation between entities looks like this: ... check attached exception. Relation between entities looks like this: @ Entity public class ...

 
forum_thread

ORDER BY problem, when String starts with language specific character

Dear all, I have a problem with ORDER BY clause. I have a simple query: select u from User u order by u.name When the name starts with "normal/english" character, records are ordered correctly. But when it starts with language specific character like 'Č', these records are placed after records with normal charaters. So records with 'Č' are after 'Z', but this is not correct, because 'Č' is between 'C' and 'D'. ... but this is not correct, because 'Č' is between 'C' and 'D'. Is there any way, how to sort the ...