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

 
issue

RDBMS-ObjectDB Replication

Replication between ObjectDB and RDBMS will enable managing the same synchronized data in ObjectDB and in an external relational database, using a JPA ORM provider. This could be useful in systems that must use an RDBMS for other purposes, but need better performance for specific tasks. For systems that already use JPA - this feature might enable using ObjectDB as a performance booster, without writing new code.... 14:31 Replication between ObjectDB and RDBMS will enable managing the same synchronized data in ...

 
forum_thread

Entity Management Config questions

Hi, the manual states the following regarding config of Entities: http://www.objectdb.com/java/jpa/setting/entities  : <cache ref="weak" level2="0mb" /> The <cache> element specifies settings of the two cache mechanisms for entities:... Question : What exactly is the difference between "weak", "soft", and "strong" references? ...

 
api-jdo

compareTo(o)

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

 
forum_thread

Evaluating ObjectDB for SaaS Application

We are currently evaluating objectdb for our SaaS(multi-tenant) product. It is a data intensive health care product . We would like to know the horizontal scalability options available. ... provides better performance because the coordination between the servers  is simpler and requires less networking operations. ...

 
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)

 
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

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